- Source
- Engineering Analytics
- Alpha
Move OpenAI data anywhere it matters.
Sync OpenAI users, conversation messages and invites to any warehouse or AI app.
Source
OpenAI

Snowflake
BigQuery
Postgres
Databricks
Claude
- Streams
- 7
- Incremental streams
- 3
- Destinations
- 50+
- Standard support
- 0.0.4
Overview
What is the Airbyte OpenAI connector?
The Airbyte OpenAI connector extracts data from OpenAI and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes 7 streams you can select per connection.
- 01
Sync to your warehouse
Land 7 OpenAI 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 OpenAI once and Airbyte keeps every scheduled sync running on it.
- 04
Cloud or self-hosted
Run the OpenAI connector on Cloud, OSS, Hybrid.
7 streams
Every table you can sync from OpenAI
users Primary key id Pagination DefaultPaginator Sync modes FullIncr. conversation_messagesIncremental Primary key id Pagination DefaultPaginator Sync modes FullIncr. conversation_messages_logIncremental Primary key event_id.snapshot_date Pagination No pagination Sync modes FullIncr. invites Primary key id Pagination DefaultPaginator Sync modes FullIncr. completionsIncremental Primary key snapshot_date.project_id.user_id.model Pagination DefaultPaginator Sync modes FullIncr. current_users Primary key id Pagination DefaultPaginator Sync modes FullIncr.
Setup
Live in three steps
Get your OpenAI 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
| Field | Type | Description |
|---|---|---|
| openai_organization* | string | The organization (organization_id) associated with the request |
| openai_token* | string | The API key token used for authorizing API requests |
| start_time* | string | The start time for querying the API in YYYY-MM-DD |
| end_time | string | The end time for querying the API in YYYY-MM-DD (defaults to today if omitted). The end date is exclusive at midnight UTC, so the current calendar day is not included until the next sync after that day ends. |
| openai_compliance_token | string | API token for ChatGPT compliance and workspace management endpoints. Required for compliance streams (conversation_messages, conversation_messages_log, current_users, historical_users). The connection check only reads the users stream, so an invalid compliance token is reported when those streams sync, not during setup test. |
| workspace_id | string | ChatGPT workspace ID. Required for compliance streams (conversation_messages, conversation_messages_log, current_users, historical_users). The connection check does not validate this field. |
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
Airbyte control plane
FAQ
OpenAI connector questions
What data can I sync from OpenAI with Airbyte?
7 streams: users, conversation messages, conversation messages log, invites, completions, current users, historical users.
Does the OpenAI connector support incremental sync?
Yes. conversation messages, conversation messages log, completions support incremental sync, and every documented stream supports full refresh.
Where can I run the OpenAI connector?
Run the OpenAI 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
Start syncing OpenAI in minutes.
Free 14-day trial. No credit card needed.