Clean and combine data (silver)

What you'll accomplish: Create a silver dataset: a curated version of one or more bronze tables.

Before you start

• At least one bronze table in your catalog

When you need silver

• Join two bronze tables (for example customers + orders)
• Drop ID columns or rename fields before modeling
• Filter rows with conditions

If a single bronze file is already clean, you can skip silver and publish gold directly.

Steps

Simple promote (one bronze table)

1. Open a bronze table in Data.
2. Choose Create silver dataset. The same dialog is Create silver from… on a bronze table.
3. Optionally drop or rename columns.
4. Save with a clear silver name.

Build with a recipe (joins)

1. From Data Warehouse → Lake, start Create silver dataset.
2. Add bronze sources and define join keys.
3. Use Preview to check rows (limited sample).
4. Save the silver dataset.

UI paths

Action	Where
Simple promote	Bronze detail → Promote to silver
Join recipe	Add data → Create silver dataset

Next steps

• Publish data for modeling
• Lab. Python alternative for profiling and charts
• User journeys

Common questions

Silver vs gold?
Silver is internal curation. Gold is validated for ML/Forecast (row counts, target, time series).

Can I skip silver?
Yes: one clean bronze CSV can go straight to gold publish.