Lesson 02 of 7 · OneLake and the lakehouse
Files in. Tables out.
Every lakehouse has two rooms. One takes anything; the other only takes tidy tables.
Where does the workbook go?
You create a for the kit. It has two areas: Files and Tables. You upload source.xlsx.
Where does the workbook land, and can a report use it straight away?
Inside a lakehouse
Tap each part.
Tap a part
Five parts
Two areas you use every day, and three things that come with them.
What's inside a Delta table?
A isn't one file. Open the folder behind gold_supply:
Tap a file
Tables/gold_supply/
Parquet files for the data, and a log that says which files count.
A nightly load fails halfway through writing new files. What does a report reading the table see?
Files or Tables?
source.xlsx, exactly as delivered
The cleaned, typed Supply table
A PDF of the data dictionary
The Commodity dimension
Three things to keep
- 1A has Files for anything and Tables for Delta tables. Models read Tables.
- 2A is Parquet files plus a log. The log is why readers never see half a load.
- 3The workbook lands in Files as bronze. Turning it into tables is the next lesson.