Set up Fivetran

Fivetran Platform Connector

Who can do this?

You need your Fivetran Account Administrator (who can create, view, edit, and delete destinations and connectors) to complete the steps below - you may not have access yourself. Note: You also need Fivetran Enterprise (or above) to use this integration. If you're not on such a plan yet, Atlan may be able to help you access a trial period from Fivetran. Just reach out to your Atlan contact!

Create a destination

The Fivetran Platform Connector delivers your logs and account or destination metadata to a schema in your destination. Fivetran automatically adds this connector to every new destination you create. You need to set up at least one destination to receive the log events.

Atlan currently supports the following destinations, refer to Fivetran documentation linked below to configure them in Fivetran:

• Amazon Redshift
• Databricks
• Google BigQuery
• PostgreSQL
• Snowflake

If you have already configured a destination in Fivetran, skip to the next step.

Configure Fivetran Platform Connector

Once you have set up a supported destination, follow the steps in this setup guide from Fivetran to set up your Fivetran Platform Connector account-wide.

• You must configure the Fivetran Platform Connector on an account level.

• Atlan recommends not excluding any columns, as this can impact the successful execution of the Fivetran enrichment package.

• The warehouse credentials or role configured in Atlan must have the necessary permissions to query tables in <Fivetran_destination_database>.<FPC_schema_name>. Refer to the Fivetran documentation for available FPC_schema_name values.

  The role must have the required permissions to access these tables. Refer to the relevant guide below for setting up permissions:

  • Set up Snowflake
  • Set up Google BigQuery
  • Set up Databricks
  • Set up Amazon Redshift
  • Set up PostgreSQL

This enables you to sync all the metadata and logs for all the connectors in your account to a single destination.