Custom table groups, formerly called custom schemas, allow you to pick the exact fields you're interested in transferring to your data warehouse or data lake.
Custom table groups are data source-specific. A table group created for one data source won't be displayed when creating transfers for other data sources.
The saved tables can also be used as queries in other Supermetrics destinations. Note that when using the tables as API queries in the Supermetrics API product, the accounts, filters, and options that were selected when saving the table affect the query results.
Instructions
- Log in to the Supermetrics Hub.
- In the sidebar, click Storage → Table Manager.
- Click Change data source to select the data source you want to create the table group for.
- In the table list view, click New Table Group to create a new table group. Note that Table groups were formerly called Schemas.
- Give a name for your table group to easily identify it, and click Create table group.
- Once the table group is created, click Add table to create a new table for the table group. Tables define a set of fields you want to write to your data warehouse. Note that Tables were formerly called Queries.
- Select the relevant fields to include in the tables (formerly queries). You can choose from premade tables or create custom tables.
- To preview the data, you can select filters, options, date ranges, and accounts. However, these settings won't affect your data warehouse transfers - only the dimensions and metrics will be used.
The same table groups can be used in multiple transfers as long as they don't use the same destination data set. If they use the same data set, they will overwrite data because of the matching table names.
- Click Save to add the table to the table group.
To add more tables to the group, repeat steps 6-9.
When creating a data transfer, you can select the custom table group you want to transfer to your data warehouse. This allows you to easily manage and transfer the precise sets of data that you require.