Fivetran

This page will guide you through the setup of Fivetran in K using the direct connect method

Integration details

Scope	Included	Comments

Scope	Included	Comments
Metadata	YES
Lineage	YES
Usage	NO	Usage currently not captured for Fivetran pipelines
Sensitive Data Scanner	N/A

Known limitations

Not all sources and destinations are included in the metadata extraction. Improvements are planned to provide wider coverage.

Log into your Fivetran account and go to Settings. Go to the API Config section to find the API Key and Secret
Copy the API Key and Secret for the next step

Select Direct Connect and add your Fivetran details and click Next
Fill in the Source Settings and click Save & Next
- Name: Give the Fivetran source a name in K
- Host: Can be any unique value. For example add fivetran.com/[fivetran account name]
- Update the Host / Database mapping - see https://kadaai.atlassian.net/wiki/spaces/KSL/pages/1899528193. This step can be completed after the initial load via the guided workflow.
Add your Key (client ID) and Secret (client Secret) copied from Step 1 and click Save
Test your connection and click Save
Click Finish Setup

Select Platform Settings in the side bar
In the pop-out side panel, under Integrations click on Sources
Locate your new Fivetran source and click on the Schedule Settings (clock) icon to set the schedule

Note that scheduling a source can take up to 15 minutes to propagate the change.

Next to your new Source, click on the Run manual load icon
Confirm how your want the source to be loaded
After the source load is triggered, a pop up bar will appear taking you to the Monitor tab in the Batch Manager page. This is the usual page you visit to view the progress of source loads

A manual source load will also require a manual run of

To load all metrics and indexes with the manually loaded metadata. These can be found in the Batch Manager page