Data warehouses and cloud storage

Set up Supermetrics for data warehouses and cloud storage

• How to connect to a data warehouse destination
• How to create a transfer
• About IP address allowlisting for data warehouse destinations
• About header type setting for data lake destinations
• How to use Parquet output format for data lake destinations

Prerequisites and configuration for data warehouse and data lake destinations

• AlloyDB
• Amazon S3
• Azure SQL Database
• Azure Storage
• Azure Synapse
• BigQuery
• Google Cloud Storage
• Redshift
• Snowflake
• SFTP servers
• BigQuery (marketplace)

Transfers

• How to backfill data
• How to modify fields in data warehouse transfers
• How to handle automatically paused transfers
• How to change the owner of data warehouse transfers
• How to filter data in transfers

Refresh settings

• About refresh settings in data warehouse transfers
• About lookback windows in data warehouse transfers
• About default refresh types and lookback windows

Monitoring

• How to monitor your data warehouse transfers on the Supermetrics Hub
• How to monitor your BigQuery (marketplace) data transfers

Table Manager

• About tables and table groups
• How to create a custom table group (formerly custom schema)
• About Supermetrics table group updates and refreshes

Data integrations troubleshooting

• How to refresh account list in data warehouse destinations and Query Manager (API)
• How to fix the “Confirm logout: Cannot execute query” error

Migration

• How to import transfers from BigQuery (marketplace) to Supermetrics Hub