How to create a custom table group (formerly custom schema)

1. Log in to the Supermetrics Hub.
2. In the sidebar, click Storage → Table Manager.
3. Click Change data source to select the data source you want to create the table group for.
4. In the table list view, click New Table Group to create a new table group. Note that Table groups were formerly called Schemas.
5. Give a name for your table group to easily identify it, and click Create table group.
6. 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.
7. Select the relevant fields to include in the tables (formerly queries). You can choose from premade tables or create custom tables.
8. 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.

9. 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.

You can also use Query Manager to create Custom table groups. The Query Manager still uses the old terminology — Queries for Tables, and Schemas for Table groups.

1. Log in to the Supermetrics Hub.
2. In the sidebar, click API.
3. Select Data Warehousing from the dropdown menu on the top right.
4. Select the data source you want to create the schema for.
5. Open the Query tab.
   • Select the metrics and dimensions to use for your query.
   • You can use queries from pre-built schemas as a template. In the Schemas tab, click a query under any default schema — this will take you back to the Query tab and fill the selected query into the configuration, where you can continue to modify it.
   • Set Select dates as a 1-day range, preferably yesterday. A single account should be sufficient for your data preview.
   • Include the Date dimension in your query to load your data incrementally, day by day. If the date isn't included, we'll snapshot all available history, overwriting each day.
6. Click Run to validate the query.
7. Click Save as to save the query and add it to a schema. 
8. Give a name for the query. 
9. Give a name for your new schema (or if you have already created schemas, select a schema from the dropdown menu).
10. 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.

11. Click OK. 

You can add multiple queries to one schema by repeating steps 5-9. Each query corresponds to one table or file type in your data destination.

When you're ready with your custom schema, you can use it in your data transfers to BigQuery and other data warehouse and cloud storage destinations. To repurpose the saved query setup in the Query Manager, access it in the Schemas tab.