Supermetrics for data warehouses and cloud storage: Overview

Supermetrics' data warehouse (DWH) and cloud storage solutions help you move your marketing data from different data sources into a destination like Snowflake or Amazon S3. We're always working on adding new destinations.

Our DWH and cloud storage solutions cover several Supermetrics products that work similarly to each other. This means that they're compatible with the same Supermetrics tools.

Please note that you need access to the destinations you want to move data to. Supermetrics doesn't provide this access, and it needs read/write access to a destination before it can transfer data to it.

With these products, you can:

  • Unify a high volume of data from multiple sources into one location

  • Take ownership of all your historical data

  • Analyze large datasets using cloud computing resources

Getting started

To get started:

  1. Create a destination in your data warehouse or cloud storage platform.

  2. Create a transfer to get data from a data source to the destination, and schedule the transfer to be automatically run daily, weekly or monthly. Note that maximum processing time for a single transfer run is 6 hours.

  3. Run a backfill to import a batch of historic data to the destination. Note that there are limitations on the time range for the backfill based on the data source or license that you have.

Once you have completed the initial setup, you can monitor the status of your transfers and get automatic email alerts of any possible failures.

There are standard denormalized schemas for the data sources that you can utilize. Optionally, you can also define the queries to be used by modifying the schema with Supermetrics Query Manager. For a list of the available tables for different sources, see the Standard Data Warehouse Schema sections under each data source in DATA SOURCES.

Destinations

AlloyDB »

Amazon S3 Bucket »

Azure SQL Database »

Azure Storage Container »

Azure Synapse »

BigQuery »

Google Cloud Storage Bucket »

Redshift »

SFTP »

Snowflake Data Warehouse »