https://api.fivetran.com/v1), using an API key and secret from the Fivetran dashboard. Configview sends only GET requests. It never creates, changes, pauses or deletes anything in Fivetran.
You will end up with 2 required secrets (FIVETRAN_API_KEY and FIVETRAN_API_SECRET) in Configview when setup is complete.
Scope of this integration today. Configview answers “who can build and run pipelines, which systems feed the warehouse, and which pipelines are broken, stale or owned by someone who left”: users and service accounts with their roles, teams and memberships, groups and who can reach them, every connection (source type, schema name, paused or running, setup and sync state, schedule, last success and failure, creator), destinations, webhooks by host, and API key metadata. It does not read connection configuration, credentials, synced data, sync logs, schemas or transformation code. Fivetran does not expose usage (monthly active rows) or an audit log through its pull API, so those are not collected.
What you need
- A Fivetran account and an administrator who can generate API keys
- A system key, or a service account, with a read-only role such as Account Reviewer
Step 1: Open the Fivetran page in Configview
Open Configview in a second browser tab and leave it open:https://{companyname}.configview.com/admin/integrations/fivetran
Step 2: Create the API key
- In Fivetran open Account Settings > System Keys (or your profile menu > API Key) and generate a key
- Prefer a system key with the Account Reviewer role. Configview needs to list users, teams, roles, groups, connections, destinations and webhooks, and nothing else. A personal key inherits your own permissions, which are usually broader than needed.
- Copy the API key and the API secret (shown once)
- In the Configview tab paste them into
FIVETRAN_API_KEYandFIVETRAN_API_SECRETunder Credentials and save
Step 3: Connect and verify
- Click Connect. Configview creates its tables and schedules every collector at your default run time:
- Click Verify now. The health check reads both secrets, then calls account info and one page of groups.
- 401. The key or secret is wrong or revoked.
- 403. The key’s role cannot read that area.
Data Tables
Each table has arun_at column and keeps only the newest run.
Things worth knowing
Connection configuration is never read. The connections list returns each connection’s setupconfig (hosts, usernames and sometimes passwords) and a short-lived setup token. Configview reads named fields only. Task, warning and setup-test text is reduced to counts.
Who owns a pipeline. created_by joins to fivetran_users.user_id. A running connection whose creator is suspended or no longer in the account is listed as orphaned.
Service accounts. API-only accounts can have no email. user_type and has_api_key are Private Preview fields in Fivetran and stay empty until Fivetran support enables them for your account.
API keys. Only the last four characters of a key are kept, with its status and expiry. The key list is Private Preview; if it is not enabled for you, that collector skips.
Rate limit. Fivetran allows 20,000 REST requests per hour on paid plans (500 on a trial), and answers HTTP 429 with Retry-After. Configview paces itself at 120 requests a minute and waits as long as Fivetran asks. Group and team memberships need one request per group and per team.
Known gaps
- No usage or monthly active rows, and no audit log, through the pull API
- System keys, private links, proxy agents and transformations are not collected yet
- Organisations using Fivetran Platform Connector tables in the warehouse have richer logs there; Configview does not read them
What isn’t collected
- Connection configuration, credentials, setup tokens and external secrets manager keys
- Webhook URLs beyond the host, and signing secrets
- API key values (only the last four characters)
- User phone numbers and avatars
- Synced data, sync logs, schemas, and transformation code