Create a Stored Table

Permissions required: Data Source Admin

Now you’re ready to add a Stored Table to your Data Store. From the Data Stores tab, find your Data Store and click the +Stored Table button.

Add Data Store Table

You’ll be redirected to the Data Explorer.

Select your data source, and then select data as you would for a chart. Add datasets and Data Pipeline steps as needed.

Editing Column names

When editing your Stored Table, be careful when changing column names - doing so will break any existing charts that are using the Stored Table.

Query Mode

If you are creating your Stored Table in SQL Mode, you’ll need to use special syntax to apply a limit. At the end of your query, be sure to add:

LIMIT {QUERY_LIMIT};

This ensures that the Query Limit in your Stored Table settings (see below) is applied to your query.

Stored Table Settings

  • Table Alias: The display name used for your Stored Table.
  • SQL Name: This is the table name you’ll use when using the Stored Table in a SQL Mode chart. It is auto-generated from the Table Alias. The SQL Name cannot be changed - this is to prevent breaking any charts that reference the SQL Name.
  • Refresh Period: determines how often the query data is refreshed. If your query returns a lot of results or takes a long time to run, you may want to set your Refresh Period to weekly, or nightly.
  • Refresh Interval setting: schedule when you would like your Stored Table query to fetch new data.
  • Query Limit: limits the number of rows included in your Stored Table. The maximum is 1 million rows. The limit is applied to each dataset, and a 1 million row limit is applied to the chart overall.
  • Max Query Duration: optional setting that overrides the queried data source’s maximum query duration.

A note on Query Duration

If you want to allow your Stored Table query additional time to run, set the Max Query Duration in your Stored Table settings.

The maximum possible query duration for Stored Tables is 30 minutes.

Add data store table