Add your first table
Time to complete: ~5 minutes
What you'll accomplish: Upload a CSV or Excel file into Lake as a bronze table.
Before you start
- Signed in at heimdallapp.org
- File format:
.csvor.xlsx - File size under 100 MB
- Distinct table name (you'll use it in Lab
lake()calls and gold publish)
Steps
- Sidebar → Data Warehouse → Lake (
/data). - Click Add data (top right, green button).
- In the dialog, choose Structured — "Upload CSV or Excel."
- Drag or select your file; enter a table name.
- Click upload and wait for success toast.
- Left catalog → Bronze tab → click your table to preview rows and column types.
Database connector?
Add data → Database is labeled Coming soon. Export from your database to CSV for bronze ingest today.
Tips
- Headers matter — First row should be column names ML/Forecast can target later.
- One file = one bronze table — Join multiple files in silver or Lab.
- Unstructured zip? Choose Unstructured instead — see zip ingest.
Common mistakes
| Issue | Fix |
|---|---|
| Upload fails silently | Check file size (100 MB max) and format |
| Table name not found in Lab | Names are case-insensitive but must match catalog — run list_tables() |
| Ready to train immediately | Bronze alone is not enough — publish gold first |
Next steps
- Data already clean? → Publish for modeling
- Need joins or filters? → Clean and combine (silver)
- Messy data? → Lab profiling path
- User journeys — full Path A