Skip to main content

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 Promote to silver (or equivalent action in the UI).
  3. Optionally drop or rename columns.
  4. Save with a clear silver name.

Build with a recipe (joins)

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

UI paths

ActionWhere
Simple promoteBronze detail → Promote to silver
Join recipeAdd dataCreate silver dataset (or Build silver from catalog actions)

Next steps

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.