Move Insightful data anywhere it matters.

Load Insightful employee, team and shared-settings into the warehouse or AI app you already run.

Sync Insightful free Read the docs

Source

Insightful

Snowflake
BigQuery
Postgres
Databricks
Claude

Streams: 8
Incremental streams: 6
Destinations: 50+
Standard support: 0.0.54

Overview

What is the Airbyte Insightful connector?

The Airbyte Insightful connector extracts data from Insightful and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 8 streams you can select per connection.

01
Sync to your warehouse
Land 8 Insightful tables in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate Insightful once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the Insightful connector on Cloud, OSS, Hybrid.

8 streams

Every table you can sync from Insightful

employeeIncremental
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.
team
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.
shared-settingsIncremental
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.
projectsIncremental
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.
tagsIncremental
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.
app-category
Primary key id
Pagination DefaultPaginator
Sync modes FullIncr.

employeeIncremental
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

team
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

shared-settingsIncremental
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

projectsIncremental
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

tagsIncremental
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

app-category
Primary key	id
Pagination	DefaultPaginator
Sync modes	FullIncr.

Setup

Live in three steps

Get your Insightful credentials from the vendor dashboard or developer settings.
Configure the source in Airbyte with the required connection fields.
Pick a destination, choose streams, set full refresh or incremental, and schedule syncs.

Configuration fields

Insightful configuration fields
Field	Type	Description
api_token*	string	Your API token for accessing the Insightful API. Generate it by logging in as an Admin to your organization's account, navigating to the API page, and creating a new token. Note that this token will only be shown once, so store it securely.
start_date*	string	Not documented.

Hybrid deployment

Sovereign by architecture, not by policy.

The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Insightful connector questions

What data can I sync from Insightful with Airbyte?

8 streams: employee, team, shared-settings, projects, tags, app-category, directory, scheduled-shift-settings.

Does the Insightful connector support incremental sync?

Yes. employee, shared-settings, projects, tags and others support incremental sync, and every documented stream supports full refresh.

Where can I run the Insightful connector?

Run the Insightful connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales