Table Format

The queries must return a date column, one or more value columns for the variables, and optional columns for dimensions, dimension mappings, or cohorts. The variable columns can be numbers or dates. Here is an example:

select date, users, country, region as "country > region" from users_tableselect date, users, country, region as "country > region" from users_table

• The first column has the dates of the transactions (timestamp or date type)
• The second column contains the values of the "users" variable (number type)
• The third column is a dimension column, the users are broken down by country (string)
• The fourth column is a dimension mapping. The region is not an independent dimension, but the countries are assigned to regions. The name of the column is important, it should have the format from dimension > to dimension. For more details on dimension mappings check out linking dimensions

If you only want to import constant values (no time series) the date column can be null.

select null as date, price, plan_name from price_table