Overview
The OpenAI connector syncs your organization's API usage and billing data into analytics-ready tables in your data warehouse. Pull usage and cost records from OpenAI's Usage and Costs API, with Ingest handling auth, pagination, and retries so the tables stay current. This is a distinct, Admin-key-gated reporting surface — separate from the completions/chat API most developers use.
What you can sync
Ingest syncs the following OpenAI (Usage & Costs API) data into your data warehouse, each as its own table refreshed on your schedule:
- Usage
- Costs
Authentication
Admin API key (Bearer token)
An Organization Owner creates an Admin API key at platform.openai.com/settings/organization/admin-keys; regular project API keys can't call these endpoints.
You enter credentials in a secure form, never in chat. Ingest stores and rotates them for you.
Resources
Don't see the endpoint you need? Tell us and we will add it.