Supermetrics for DWH and Cloud Storage - Overview
Supermetrics Data Warehouse and Cloud Storage solutions contain several Supermetrics products that work in a very similar way and can be used with the same Supermetrics tools. These products help you to move your marketing data from different data sources to a data warehouse or cloud storage destination, like Snowflake or Amazon S3 – we are constantly working on new destination types that will be available later.
Please note that Supermetrics does not provide these destinations, but instead you need to have access to the destination itself beforehand. In order for Supermetrics to be able to handle the transfers, read/write access to the destination is required.
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
On a high level, the needed steps to get started are:
Create a destination to the data warehouse or cloud storage you want to use
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.
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 Data Warehouse Tables sections under each data source in Integrations.