Skip to main content

Virtual Tables

You may sometimes need to construct a new view on an existing table. One option is to create a new view, but anyone who uses a view is exposed to the details of how the view is created. If you'd like to hide those details, then you should create a virtual table.

A virtual table lets you present the results of a query as if it were its own table. It allows you to share a new view on your data without exposing the details of how it was constructed.

To create a virtual table:

  1. Use the control bar at the top of the app to construct a query.
  2. Click the view menu in the left-hand side of the control bar.
  3. Click “Add View”.
  4. Enter a name for your view.
  5. Click on the dotted menu on the right-hand side of the control bar and select “Create virtual table from view”.
  6. Enter a name for your virtual table.
  7. Click “Submit”. Your new virtual table will appear in the left-hand nav bar.
  8. (Optional). By default, a new virtual table is only visible to the user who created it. To share with other members in your workspace, right click on the virtual table and select “Make visible to team”.

Notes

  • A virtual table is based on the view used to define it. If that view is changed, the virtual table will also change.
  • To see which view a virtual table is based on, hover over the info icon in the nav bar entry for the virtual table.