Custom tables and columns

You can write and save SQL queries in your data source schema to create custom tables and columns. These are especially useful for saving repeated calculations or defining standard metrics and calculations for your Analytics workspace.

The SQL syntax you use for the queries depends on the data source type.

Also note that you can only use custom tables and columns in visual mode queries. This is because the custom table or column is inserted as a nested SQL statement into the query, which isn’t as straightforward in SQL mode queries.

Read more about how to:

• カスタム テーブルと列を作成する

• カスタム テーブルとカスタム列を編集する

• カスタム テーブルとカスタム列を使用する