• 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 keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • conversation_messagesIncremental
    Primary keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • conversation_messages_logIncremental
    Primary keyevent_id.snapshot_date
    PaginationNo pagination
    Sync modesFullIncr.
  • invites
    Primary keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • completionsIncremental
    Primary keysnapshot_date.project_id.user_id.model
    PaginationDefaultPaginator
    Sync modesFullIncr.
  • current_users
    Primary keyid
    PaginationDefaultPaginator
    Sync modesFullIncr.

Setup

Live in three steps

  1. Get your OpenAI credentials from the vendor dashboard or developer settings.

  2. Configure the source in Airbyte with the required connection fields.

  3. Pick a destination, choose streams, set full refresh or incremental, and schedule syncs.

Configuration fields

OpenAI configuration fields
FieldTypeDescription
openai_organization*stringThe organization (organization_id) associated with the request
openai_token*stringThe API key token used for authorizing API requests
start_time*stringThe start time for querying the API in YYYY-MM-DD
end_timestringThe 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_tokenstringAPI 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_idstringChatGPT 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

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

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.