Define a small model
Start with one physical table whose columns and grain you have already checked. For example, adapt this model to your own warehouse.RAW.CRM.ACCOUNTS and its
columns are illustrative, not built-in Deepline tables.
main_id: true dimension across the model; use its actual
identity column. Here ID is illustrative, and unique: true declares the
expected identity rather than checking warehouse rows.
This query selects the named active_accounts filter explicitly. A table-level
base_filter applies automatically; relationships can supply joins when a query
references another logical table. Inspect the rendered SQL before relying on either.
Validate and save
Save the model assemantic-layer.yml. Bind a test workspace
with access to the intended warehouse. Inspect the connector contract, then
validate without changing the stored layer:
yaml so you can restore the
previous model. Save the proposed model in the test workspace:
Compare with direct SQL
Run a small semantic query against your connected warehouse:sql and rows. Compare the count and grouping with known
direct SQL for the same population. Check physical column names, null handling,
what each row represents, filters, and timezones. Promote the same reviewed YAML
to the intended workspace only after the comparison passes. Save that workspace’s
previous model before replacing it.