Learn Odara ETL by building pipelines.
A guided route from your first CSV to a scheduled, documented, production-shaped pipeline, with the files included and a certificate at the end. Short videos and walkthroughs for one feature at a time. Live cohorts for teams.
Videos 4
Short clips of Odara in motion.
Walkthroughs 15
Step by step with screenshots, at your own pace. Exercise files included where it says so.
10 minMagic File + Iterate — one pipeline for a folder of mixed formats
List a folder with FileList, loop per file with Iterate, auto-detect CSV/Excel/JSON with Magic File, and append everything into one tagged CSV. Files included.
14 minDocumentation — auto-generate, export, and publish your project docs
Odara reads your whole project and turns it into living docs — diagrams, node configs, and connections. Browse it, export a print-ready PDF, or publish an access-controlled shareable site.
12 minThe API — build, run, and orchestrate pipelines without the UI
Everything the UI does, over REST: create a pipeline as JSON, let the AI build one from a sentence, stream a headless run, infer schemas, and orchestrate with Maestro. Real curl, copy-pasteable.
12 minAI Assistant (SQL) — describe a pipeline, get a working SQL transform
Type one sentence and the AI Assistant plans and builds the whole pipeline — source, a SQL Transform with a window function, and a target — that you run as-is. Files included.
12 minAI Assistant (Python) — describe a pipeline, get a pandas transform
Describe an enrichment and the AI builds a CSV → pandas transform (quartiles, z-score outliers, labels) → Excel pipeline. Files included.
7 minMonitor — see what your pipelines are doing
A step-by-step tour of Monitor — the page where every run shows up. Filter, search, re-run, and read execution details.
7 minSchedule — run your pipelines automatically
Set up daily, hourly, or custom cron schedules; configure SMTP-based email alerts; pause, run-now, or delete.
8 minAdmin — manage users, roles, and permissions
Add users, change role assignments inline, deactivate vs delete, browse system roles, build custom roles from the permission catalog.
10 minSQL Join — combine two CSVs and load into Postgres
Wire two CSV sources into one SQL Transform, JOIN on a key, write the joined rows into a Postgres table. Files included.
10 minPython external + Email — call a script, mail the result
Read sales.csv, call an external transform.py with pandas, write the summary, and send it as an email attachment. Files + script included.
15 minStar Schema → Snowflake — load with Maestro
Model a star schema (3 dims + 1 fact), build a Maestro from scratch to load all four into Snowflake in parallel, then JOIN the star at query time.
10 minEnvironment per run and per schedule — DEV, STG, PROD without touching Admin
Run one pipeline Local in DEV, in Docker in STG, on AWS in PROD and on Google Cloud in QA from the editor’s top bar or the API, see it in the Monitor, and pin a schedule to an environment.
15 minIsolated runs on Docker — one container per run on your server
Get the odara-runner image (ECR Public, Artifact Registry or a download), let Odara use Docker, set an environment to Isolated (Docker) with CPU, memory and time limits, and run in it.
25 minIsolated runs on AWS ECS Fargate — one cloud machine per run
A budget, one CloudFormation stack from the console, the server’s access key, then PROD set to Fargate: each run gets its own task, followed in Odara, ECS and CloudWatch. Delete it all in one click.
25 minIsolated runs on Google Cloud Run — one job execution per run
A budget alert, setup.sh in Cloud Shell (job, service accounts, bucket, key), then an environment set to Cloud Run: each run is one job execution, followed in Odara, Cloud Run and Logging.