ingestr recipes/Load a specific sourceData Engineer

How do I load data from Oracle into my warehouse?

This recipe copies a table from an Oracle database into your warehouse using ingestr. The source URI uses the oracle+cx_oracle scheme and the source table is given as a schema qualified name. 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

Oracle to any ingestr destination

What you get

Full table loadSchema qualified tablesIncremental sync

How it works in code

$ ingestr ingest \
  --source-uri 'oracle+cx_oracle://myuser:mypassword@localhost:1521/ORCL' \
  --source-table 'MY_TABLE' \
  --dest-uri $SNOWFLAKE_URI --dest-table 'public.my_table'

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