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 click OK.
- Fill in the details in the transfer configuration view.
- Select the destination to which the data will be sent.
- Set the refresh schedule.
- Select which email address to send alerts in case the transfer fails.
- Select which schema or table group to use.
- Select a connection to use for the data source from which you want to pull data. If you don't have a connection set up for the data source, click Add new connection.
Depending on the data source, enter your credentials and click Start, or click Start directly and then log in to the data source. See our connection guides for the details and permissions each data source requires. - 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.
- In the General settings section, set up the options specific to that particular data source.
- When you're ready, click Create 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