Pick a schema / namespace
How schemas and storage folders organize tables - and when to use each.
A table's FQN is
catalog.schema.table, so the schema is your primary namespace. Storage
folders are a separate, physical way to organize where tables sit in the
bucket. Use both deliberately.
Schemas - the logical namespace
The schema segment groups tables logically within the eddytor catalog -
sales, raw, curated, reference. It's what shows up in the FQN and the
sidebar tree. Pick schemas that mirror how your teams think about the data
(domain or pipeline stage), not storage mechanics.
Folders - the physical layout
A folder is a prefix in the object store
(eddytor create folder). Tables created under a path live beneath that prefix.
Folders are handy to keep a bucket tidy (e.g. master-data/, archive/) without
changing the logical schema.
Which to use
| Want to… | Use |
|---|---|
| Group tables by domain/team/stage in the FQN and nav | Schema |
| Keep the bucket's object layout organized | Folder (storage path) |
| Separate dev vs prod | A different storage connection (move with move_table) |
Good to know