ingestr recipes/Load a specific sourceData Engineer

How do I load Notion data into my warehouse?

Notion exposes the rows and properties of a database (identified by its database ID) through its integration API. ingestr lands that table 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.

Get ingestr on GitHub How ingestr works

Command

ingestr ingest

Defined in

CLI

Works with

Notion to any ingestr destination

What you get

Notion API sourceno connector codedatabase ID as table

How it works in code

$ ingestr ingest \
  --source-uri 'notion://?api_key=secret_12345' \
  --source-table 'bfeaafc0c25f40a9asdasd672a9456f3' \
  --dest-uri $SNOWFLAKE_URI --dest-table 'analytics.notion_database'

Run ingestr ingest and ingestr loads the Notion data into your warehouse.