Cloud data warehouse permissions
To connect to your chosen cloud data warehouse, you will need to configure various permissions in your CDW.
To see technical requirements, see here.
Snowflake
The role used by Data Loader needs the following permissions for Snowflake:
- USAGE on default destination database and warehouse (defaults as specified via 'Manage Destinations').
- USAGE on user pipeline specified warehouse, stage database, target database.
- USAGE, CREATE TABLE, CREATE STAGE on user pipeline specified stage schema.
- USAGE, CREATE TABLE, CREATE STAGE on default schema (defaults as specified via 'Manage Destinations').
- USAGE, CREATE TABLE on user pipeline specified target schema.
The environment defaults are used to pre-stage the data in the Snowflake-managed stage used by Data Loader. These defaults are taken from your destination configuration.
The stage parameters, specified when creating a pipeline, are used to create our temporary stage table.
The target parameters, specified when creating a pipeline, are used for the target table.
For more information on Snowflake permissions, see here.
Redshift
To grant access to Redshift, all you need is a Redshift user account with access. For more information on access management, see here.
Big Query
For BigQuery, you will need a service account with access to Google Cloud Storage and BigQuery. For more information on service accounts, see here.
Delta Lake on Databricks
To grant access to Delta Lake on Databricks, you will need a Databricks user account with access. For more information on access management, see here.