Fivetran

This documentation for the Fivetran integration describes the technical capabilities of this integration, including authorization, scopes/permissions, and utilized endpoints. For more information on how to integrate Fivetran, visit our connection instructions.

Version

This integration utilizes the Fivetran REST API v1.

Base URL

The base URL used for all Fivetran API endpoints:

https://api.fivetran.com/v1

Endpoints Utilized

DataGrail uses the following endpoints to authorize and test the connection:

Method	Endpoint	Purpose	Docs
GET	/groups	Validate credentials

---

Authentication & Authorization

The DataGrail Fivetran integration connects using API Key authentication which requires an API Key and API Secret.

Sensitive Credentials

Publicly exposing your API credentials can allow unauthorized access to Fivetran API endpoints by a third party. DataGrail stores your API credentials encrypted and protected.

---

Limits

Limits in Fivetran are calculated using the leaky bucket algorithm. All requests that are made after rate limits have been exceeded are throttled and an HTTP 429 Too Many Requests error is returned. Requests succeed again after enough requests have emptied out of the bucket.

• DataGrail supports requests throttling to stay within 70-80% of specified service rate limits.
• DataGrail processes API responses with HTTP 429 status to interrupt requests, waiting and retrying (using an exponential backoff strategy).

---

Capabilities

System Detection

DataGrail provides continuous system detection, delivering a real-time inventory of your data assets.

Data Interactions

DataGrail's System Detection process runs once daily and performs the following actions:

1. Retrieve a list of all groups.
2. Retrieve a list all connections within a group.
3. Retrieve user details.

Endpoints Utilized

Method	Endpoint	Purpose	Docs
GET	/groups	Retrieve a list of all groups
GET	/groups/group_id/connectors	Retrieve a list all connections within a group
GET	/users/user_id	Retrieve user details

---