Snowflake

Overview

Use this connector to extract metadata from Snowflake warehouses.

Create User & Grant Permissions

Run the following SQL commands to create a dedicated user and grant the required read-only permissions:

• CREATE ROLE connetra_role;
• GRANT IMPORTED PRIVILEGES ON DATABASE SNOWFLAKE TO ROLE connetra_role;
• CREATE USER connetra PASSWORD='<password>' DEFAULT_ROLE='connetra_role' TYPE='LEGACY_SERVICE';
• GRANT ROLE connetra_role TO USER connetra;
• GRANT USAGE ON WAREHOUSE <warehouse_name> TO ROLE connetra_role;
• GRANT USAGE ON DATABASE <database_name> TO ROLE connetra_role;
• GRANT USAGE ON ALL SCHEMAS IN DATABASE <database_name> TO ROLE connetra_role;
• GRANT SELECT ON ALL TABLES IN DATABASE <database_name> TO ROLE connetra_role;
• GRANT SELECT ON ALL VIEWS IN DATABASE <database_name> TO ROLE connetra_role;
• GRANT USAGE ON FUTURE SCHEMAS IN DATABASE <database_name> TO ROLE connetra_role;
• GRANT SELECT ON FUTURE TABLES IN DATABASE <database_name> TO ROLE connetra_role;
• GRANT SELECT ON FUTURE VIEWS IN DATABASE <database_name> TO ROLE connetra_role;

Connection Setup in Connetra

When adding a data connector in Connetra, provide the following details:

• Configuration name: A user-friendly label for this connection. It helps team members identify and select the connector within Connetra
• Host/server: The network address or domain name of the database server where your data is stored.
• Port: The communication port used to connect to the database
• User: The database account Connetra will use to connect and retrieve metadata. This user should have read-only permissions.
• Password: The password associated with the user account above, used to authenticate the connection.

Before you can save the data connector you must first test the connection.