STS Adult Cardiac Registry Objects

Run summary

Generated artifact inventory for run 20260528T174320Z. Use this page to review proposed Snowflake objects, upload artifacts, and validation objects before architecture review.

Source root

/mnt/c/Users/jna31a/repos/sts_raw_data

Source rows72,326

Source units139

Bronze tables1

Columns in upload pack1,530

Validation targets1

Split file units0

Schemas

Generated object groups

Bronze landing tables are generated under WORK.CLINDSA. Validation support objects are generated under STAGE.CLINDSA. Silver and gold are represented here as governed contracts that consume bronze metadata; their concrete table count is currently modeled as one canonical silver publication and one flat gold publication per registry until architecture review expands the contract. UDFs and stored procedures are not emitted in this slice.

Generated objects

Tables and validation objects

Object	Layer	Rows	Columns	Source
`WORK.CLINDSA.sts_sts_main_data_v4_20_raw_csv`	Bronze landing table	23,789	1,530	sts_main_data_v4_20_raw.csv
`STAGE.CLINDSA.STS_VALIDATION_INPUT_TABLE`	Validation object	Generated by `create_validation_objects.sql`
`STAGE.CLINDSA.STS_VALIDATION_RESULTS`	Validation object	Generated by `create_validation_objects.sql`

Review artifacts

Generated files

Raw manifest/mnt/c/Users/jna31a/advent-repos/jna31a_ait/registry-runtime/runs/sts/20260528T174320Z/raw_manifest.json

Upload manifest/mnt/c/Users/jna31a/advent-repos/jna31a_ait/registry-runtime/runs/sts/20260528T174320Z/upload_pack_manifest.json

Load SQL/mnt/c/Users/jna31a/advent-repos/jna31a_ait/registry-runtime/runs/sts/20260528T174320Z/snowflake_load_plan/sts_load.sql

Validation SQL/mnt/c/Users/jna31a/advent-repos/jna31a_ait/registry-runtime/runs/sts/20260528T174320Z/validation/run_validation.sql

Metadata reference

/mnt/c/Users/jna31a/advent-repos/jna31a_ait/registry-runtime/runs/sts/20260528T174320Z/metadata_repo_reference/sts_metadata_reference.json