Fivetran set up

This integration works via Snowflake, read our documentation to set up a connector

This integration is only accessible for Snowflake Enterprise clients currently

Fivetran Platform Connector

Activate the Fivetran Platform Connector (Free Beta Feature)

1. + Set up Connector

2. Make sure the Destination is Snowflake

3. Destination schema: by default fivetran_log, you can customize it This schema will be created into the Snowflake Database you connected to Fivetran.

4. Activate Account Level connector if you wish to synchronize all your connectors to Catalog. Deactivate it if you want to select some connectors.

Make sure you click on the Enable beta button if you can this banner:

Snowflake grants

Make sure you have already created the Catalog user (and the METADATA_VIEWER_ROLE)

Run the following command to grant reading access to Fivetran metadata:

GRANT USAGE ON DATABASE <database_name> TO METADATA_VIEWER_ROLE;
GRANT USAGE ON SCHEMA <schema_name> TO METADATA_VIEWER_ROLE;
GRANT SELECT ON ALL TABLES IN SCHEMA <schema_name> TO METADATA_VIEWER_ROLE;
GRANT SELECT ON FUTURE TABLES IN SCHEMA <schema_name> TO METADATA_VIEWER_ROLE;

database_name: the name of the Snowflake Database you connected to Fivetran schema_name: the name of the Snowflake schema you created above (default: fivetran_log)

Add an integration

In Catalog, add a new integration of type Generic Warehouse:

1. Select Catalog managed

2. Choose a name (suggested: Fivetran_Sources)

3. Paste credentials with the following format

{
    "account": "account_name",
    "user": "username",
    "password": "password", /* or */ "private_key": "privateKey",
    "database": "database_name",
    "schema": "schema_name"
}

• If you are connected via Key pair auth, replace "password" with "private_key"

• account_name, username and password (or private_key) should be the same than for your Snowflake integration

• database_name and schema_name are the same as mentioned in Snowflake grants