Start transferring data into your data warehouse, cloud storage, data lake, or Supermetrics Storage by configuring a transfer in the Supermetrics Hub.
This guide applies to all data warehouse destinations except BigQuery (marketplace). See our separate guide on creating a BigQuery (marketplace) transfer. You can also use the Supermetrics API to connect your data to various destinations.
Before you begin
Before you create a data transfer, you need to create a destination for your data. See our destination setup guide for instructions.
Instructions
- Log in to the Hub.
- In the sidebar, go to Storage → Transfers.
- Click New transfer.
- Select the data source and the destination, and click Next.
- Fill in the details in the transfer configuration view.
- Select the data source accounts to use. Depending on the data source, this selection can have different titles, such as advertiser, property, or view. We list the data source account names in this support article.
- Select which table group to use.
- Set the refresh schedule.
- Select which email address to send alerts in case the transfer fails.
- Select additional options for the transfer.
- Click Next.
- Enter a name for the transfer, click Save Transfer.
Table and partition expiration
When you're setting up your transfer, make sure to set the table and partition expiration time to "never" or to as many days as possible. Setting the table and partition expiration times as long as possible will make sure that you won't accidentally lose data when running a backfill.
See Google's documentation for:
- Updating default partition expiration times
- Updating a table's expiration time
- Setting partition expiration