Move OpenFDA data anywhere it matters.

Sync OpenFDA food adverse events and drug adverse events to any warehouse or AI app.

Sync OpenFDA free Read the docs

Source

OpenFDA

Snowflake
BigQuery
Postgres
Databricks
Claude

Streams: 9
Destinations: 50+
Standard support: 0.0.69

Overview

What is the Airbyte OpenFDA connector?

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

01
Sync to your warehouse
Land 9 OpenFDA tables in 50+ destinations on a schedule you control.
02
One authorization
Authenticate OpenFDA once and Airbyte keeps every scheduled sync running on it.
03
Cloud or self-hosted
Run the OpenFDA connector on Cloud, OSS, Hybrid.

9 streams

Every table you can sync from OpenFDA

Animal and Veterinary Adverse Events
Primary key unique_aer_id_number
Pagination DefaultPaginator
Sync modes FullIncr.
Tobacco Problem Reports
Primary key report_id
Pagination DefaultPaginator
Sync modes FullIncr.
Food Adverse Events
Primary key report_number
Pagination DefaultPaginator
Sync modes FullIncr.
Food Enforcement Reports
Primary key recall_number
Pagination DefaultPaginator
Sync modes FullIncr.
Drug Adverse Events
Pagination DefaultPaginator
Sync modes FullIncr.
Drug Product Labelling
Pagination DefaultPaginator
Sync modes FullIncr.

Animal and Veterinary Adverse Events
Primary key	unique_aer_id_number
Pagination	DefaultPaginator
Sync modes	FullIncr.

Tobacco Problem Reports
Primary key	report_id
Pagination	DefaultPaginator
Sync modes	FullIncr.

Food Adverse Events
Primary key	report_number
Pagination	DefaultPaginator
Sync modes	FullIncr.

Food Enforcement Reports
Primary key	recall_number
Pagination	DefaultPaginator
Sync modes	FullIncr.

Drug Adverse Events
Pagination	DefaultPaginator
Sync modes	FullIncr.

Drug Product Labelling
Pagination	DefaultPaginator
Sync modes	FullIncr.

Setup

Live in three steps

Get your OpenFDA 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

OpenFDA configuration fields
Field	Type	Description
api_key	string	Optional openFDA API key. Without a key openFDA allows 240 requests per minute and 1,000 requests per day per IP address; with a key the daily quota is 120,000 requests. Get a key at https://open.fda.gov/apis/authentication/.

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

OpenFDA connector questions

What data can I sync from OpenFDA with Airbyte?

9 streams: Animal and Veterinary Adverse Events, Tobacco Problem Reports, Food Adverse Events, Food Enforcement Reports, Drug Adverse Events, Drug Product Labelling, Drug NDC Library, Drug recall Enforcement Reports, Drugs.

Does the OpenFDA connector support incremental sync?

The OpenFDA connector supports full refresh sync. Check the stream list on this page for incremental support per table.

Where can I run the OpenFDA connector?

Run the OpenFDA 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