At One Model, we think it's critical that your data goes to where you need it most. If Snowflake is your platform of choice, you can use our Snowflake Data Destination to send data from One Model to Snowflake.

The following settings will need to be configured for a Snowflake Data Destination:

Example configuration is below:

For further details on how to configure a Data Destination, refer to our Configure a Data Destination guide.

Permissions required in Snowflake

The following permissions are the minimum level of access required for a Snowflake User to be used in the Snowflake Data Destination:

• The Role of the user needs access to the Warehouse configured in One Model
• The Role of the user needs access to the Database configured in One Model
• The Role of the user needs access to create an integration in the account
  • This is required as the Integration is then given access to just the data that is needed for a Data Destination run, so this can’t be maintained manually.
• The Role of the User needs access to Show Grants
• The Role of the user needs to have access to either: 
  • create a schema, or 
  • Usage, Create Stage, Create File Format, and Create Table of a Schema with the same name as the one configured in One Model

This can be done using the following statements:

GRANT USAGE

  ON WAREHOUSE <warenhouse_name>

  TO ROLE <role_name>;

GRANT USAGE

  ON DATABASE <database_name>

  TO ROLE <role_name>;

GRANT CREATE INTEGRATION 

ON ACCOUNT TO ROLE <role_name>;

USE DATABASE <database_name>;

SHOW GRANTS TO ROLE <role_name>;

Access to create a schema can be given by:

GRANT CREATE SCHEMA 

    on DATABASE <database_name> 

    TO ROLE <role_name>;

Access to use a schema can be given by:

GRANT USAGE, CREATE STAGE, CREATE FILE FORMAT, CREATE TABLE

    on SCHEMA <schema_name> 

    TO ROLE <role_name>;