Fivetran (beta)

Follow these steps to connect your Fivetran instance to Select Star.

Before you start

To connect Fivetran to Select Star, you will need...

• Admin access to your Destination/Data Warehouse instance. (to configure the permissions)

• Admin access to your Fivetran account. i.e., user account with Account Administrator role. (to configure the Fivetran Platform Connector)

• Fivetran Enterprise plan and above.

Select Star uses Fivetran Platform Connector to fetch metadata and lineage information of your Fivetran instance.

Select Star currently does not catalog the metadata of the Fivetran connectors, and only generates lineage information for the assets synced by Fivetran.

Complete all the following steps to see lineage from Fivetran in Select Star.

1. Configure Fivetran Platform Connector

2. Connect Fivetran to Select Star

1. Configure Fivetran Platform Connector

1. Select Star currently supports the following destinations to connect with Fivetran:

   • Snowflake

   • Google BigQuery

   • PostgreSQL

   • If you are using a different destination, please reach out to us, and our dedicated support team will help you with the integration.

2. Skip this step if you have already set up the account-wide Fivetran Platform Connector.

3. Follow Fivetran's step-by-step setup guide to manually set up your Fivetran Platform connection account-wide.

2. Connect Fivetran to Select Star

Go to the Select Star Settings. Click Data in the sidebar, then + Add to create a new Data Source.

Choose Fivetran in the Source Type dropdown and provide the following information:

• Display Name - The name you want to give to your new data source.

Click Save to proceed.

Configure Destination Type

Select the destination type.

• Destination Type - The destination type where Fivetran is syncing the data.

Please follow the instructions below and fill in the required details based on the destination type you selected.

• Snowflake

• Google BigQuery

• PostgreSQL

IMPORTANT! Please ensure that the user configured in the destination for Select Star has the SELECT permissions on all the tables in the schema used by Fivetran Platform Connector.

These tables contain the metadata and lineage information that Select Star uses to generate the lineage. For more information, refer to the Fivetran Platform Connector documentation.

Click Save to proceed.

Select Star currently matches schema names in the destination with those in Fivetran to identify the correct database and generate lineage.

If you believe the lineage is not being generated correctly, please reach out to our support team.

Your metadata should start loading automatically. Please allow 24-48 hours to completely generate the lineage.