How do I load Facebook Ads data into my warehouse?
The Facebook Ads source exposes objects like campaigns, ad_sets, and facebook_insights. ingestr lands them in your warehouse with one command. Bruin does this in one platform: ingestion, SQL and Python pipelines, quality checks, lineage, and an AI data analyst that answers in Slack, Microsoft Teams, Google Chat, WhatsApp, Discord, Telegram, email and the browser.
Command
ingestr ingestDefined in
CLI
Works with
Facebook Ads to any ingestr destination
What you get
Facebook Marketing API sourcecampaigns and insights tablesmulti-account tables
How it works in code
$ ingestr ingest \
--source-uri 'facebookads://?access_token=easdyh&account_id=1234' \
--source-table 'campaigns' \
--dest-uri $SNOWFLAKE_URI --dest-table 'facebook_ads.campaigns'Run ingestr ingest and ingestr loads the Facebook Ads data into your warehouse.
Related use cases
Load a specific source
Replicate a Postgres database into Snowflake
How do I replicate a Postgres database into Snowflake?
Load a specific sourceReplicate a database incrementally
How do I keep a database table in sync without full reloads (CDC-style)?
Load a specific sourceLoad Google Sheets into your warehouse
How do I load a Google Sheet into my warehouse?
Move data with one command
Bruin CLI and ingestr are on GitHub.
A demo walks through your own data.