CathPCI 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/cath_raw_data/2026-01-15/raw

Source rows5,796,031

Source units55

Bronze tables55

Columns in upload pack1,964

Validation targets55

Split file units17

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.cathpci_cathlabprocvisit_raw_csv`	Bronze landing table	44,864	65	cathlabprocvisit_raw.csv
`WORK.CLINDSA.cathpci_demographics_raw_csv`	Bronze landing table	40,100	13	demographics_raw.csv
`WORK.CLINDSA.cathpci_devices_raw_csv`	Bronze landing table	157,794	28	devices_raw.csv
`WORK.CLINDSA.cathpci_discharge_raw_csv`	Bronze landing table	41,611	56	discharge_raw.csv
`WORK.CLINDSA.cathpci_dischargemeds_raw_csv_part0001_csv`	Bronze landing table	263,275	27	dischargemeds_raw.csv.part0001
`WORK.CLINDSA.cathpci_dischargemeds_raw_csv_part0002_csv`	Bronze landing table	261,273	27	dischargemeds_raw.csv.part0002
`WORK.CLINDSA.cathpci_dischargemeds_raw_csv_part0003_csv`	Bronze landing table	183,238	27	dischargemeds_raw.csv.part0003
`WORK.CLINDSA.cathpci_episode_raw_csv`	Bronze landing table	41,611	36	episode_raw.csv
`WORK.CLINDSA.cathpci_graftlesion_raw_csv`	Bronze landing table	6,036	32	graftlesion_raw.csv
`WORK.CLINDSA.cathpci_historyandrisk_raw_csv`	Bronze landing table	41,611	52	historyandrisk_raw.csv
`WORK.CLINDSA.cathpci_intrapostprocedureevents_raw_csv`	Bronze landing table	44,864	29	intrapostprocedureevents_raw.csv
`WORK.CLINDSA.cathpci_labs_raw_csv`	Bronze landing table	44,864	43	labs_raw.csv
`WORK.CLINDSA.cathpci_lesion_raw_csv`	Bronze landing table	51,048	88	lesion_raw.csv
`WORK.CLINDSA.cathpci_lesionsegmentnumber_raw_csv`	Bronze landing table	121,594	30	lesionsegmentnumber_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_artclose_raw_csv`	Bronze landing table	43,915	24	ncdr_cathpci_ARTCLOSE_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_attphy_raw_csv`	Bronze landing table	7,073	24	ncdr_cathpci_ATTPHY_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_cathlabprocvisit_raw_csv`	Bronze landing table	44,864	64	ncdr_cathpci_CATHLABPROCVISIT_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_coronaryanatomy_raw_csv`	Bronze landing table	44,864	25	ncdr_cathpci_CORONARYANATOMY_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_demographics_raw_csv`	Bronze landing table	40,100	13	ncdr_cathpci_DEMOGRAPHICS_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_devices_raw_csv`	Bronze landing table	157,794	27	ncdr_cathpci_DEVICES_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_dischargemeds_raw_csv_part0001_csv`	Bronze landing table	276,140	26	ncdr_cathpci_DISCHARGEMEDS_raw.csv.part0001
`WORK.CLINDSA.cathpci_ncdr_cathpci_dischargemeds_raw_csv_part0002_csv`	Bronze landing table	277,741	26	ncdr_cathpci_DISCHARGEMEDS_raw.csv.part0002
`WORK.CLINDSA.cathpci_ncdr_cathpci_dischargemeds_raw_csv_part0003_csv`	Bronze landing table	153,905	26	ncdr_cathpci_DISCHARGEMEDS_raw.csv.part0003
`WORK.CLINDSA.cathpci_ncdr_cathpci_discharge_raw_csv`	Bronze landing table	41,611	55	ncdr_cathpci_DISCHARGE_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_episode_raw_csv`	Bronze landing table	41,611	35	ncdr_cathpci_EPISODE_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_export_criteria_raw_csv`	Bronze landing table	845	15	ncdr_cathpci_EXPORT_CRITERIA_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_graftlesion_raw_csv`	Bronze landing table	6,036	31	ncdr_cathpci_GRAFTLESION_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_historyandrisk_raw_csv`	Bronze landing table	41,611	51	ncdr_cathpci_HISTORYANDRISK_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_intrapostprocedureevents_raw_csv`	Bronze landing table	44,864	28	ncdr_cathpci_INTRAPOSTPROCEDUREEVENTS_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_labs_raw_csv`	Bronze landing table	44,864	42	ncdr_cathpci_LABS_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_lesionsegmentnumber_raw_csv`	Bronze landing table	121,594	29	ncdr_cathpci_LESIONSEGMENTNUMBER_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_lesion_raw_csv`	Bronze landing table	51,048	87	ncdr_cathpci_LESION_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_pcimeds_raw_csv_part0001_csv`	Bronze landing table	285,156	24	ncdr_cathpci_PCIMEDS_raw.csv.part0001
`WORK.CLINDSA.cathpci_ncdr_cathpci_pcimeds_raw_csv_part0002_csv`	Bronze landing table	287,464	24	ncdr_cathpci_PCIMEDS_raw.csv.part0002
`WORK.CLINDSA.cathpci_ncdr_cathpci_pcimeds_raw_csv_part0003_csv`	Bronze landing table	83,896	24	ncdr_cathpci_PCIMEDS_raw.csv.part0003
`WORK.CLINDSA.cathpci_ncdr_cathpci_pciprocedure_raw_csv`	Bronze landing table	44,864	46	ncdr_cathpci_PCIPROCEDURE_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_ppevents_raw_csv_part0001_csv`	Bronze landing table	258,903	25	ncdr_cathpci_PPEVENTS_raw.csv.part0001
`WORK.CLINDSA.cathpci_ncdr_cathpci_ppevents_raw_csv_part0002_csv`	Bronze landing table	259,896	25	ncdr_cathpci_PPEVENTS_raw.csv.part0002
`WORK.CLINDSA.cathpci_ncdr_cathpci_ppevents_raw_csv_part0003_csv`	Bronze landing table	198,884	25	ncdr_cathpci_PPEVENTS_raw.csv.part0003
`WORK.CLINDSA.cathpci_ncdr_cathpci_preprocinformation_raw_csv`	Bronze landing table	44,864	72	ncdr_cathpci_PREPROCINFORMATION_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_preprodmed_raw_csv_part0001_csv`	Bronze landing table	269,783	24	ncdr_cathpci_PREPRODMED_raw.csv.part0001
`WORK.CLINDSA.cathpci_ncdr_cathpci_preprodmed_raw_csv_part0002_csv`	Bronze landing table	268,117	24	ncdr_cathpci_PREPRODMED_raw.csv.part0002
`WORK.CLINDSA.cathpci_ncdr_cathpci_procinfo_raw_csv`	Bronze landing table	44,864	62	ncdr_cathpci_PROCINFO_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_researchstudyinfo_raw_csv`	Bronze landing table	3	22	ncdr_cathpci_RESEARCHSTUDYINFO_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_rosedyspneascale_raw_csv`	Bronze landing table	44,864	22	ncdr_cathpci_ROSEDYSPNEASCALE_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_saq_raw_csv`	Bronze landing table	44,864	29	ncdr_cathpci_SAQ_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_stresstest_raw_csv`	Bronze landing table	20,355	26	ncdr_cathpci_STRESSTEST_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_valveregurg_raw_csv`	Bronze landing table	1,586	24	ncdr_cathpci_VALVEREGURG_raw.csv
`WORK.CLINDSA.cathpci_ncdr_cathpci_valvsten_raw_csv`	Bronze landing table	1,130	24	ncdr_cathpci_VALVSTEN_raw.csv
`WORK.CLINDSA.cathpci_pciprocedure_raw_csv`	Bronze landing table	44,864	47	pciprocedure_raw.csv
`WORK.CLINDSA.cathpci_ppevents_raw_csv_part0001_csv`	Bronze landing table	247,231	26	ppevents_raw.csv.part0001
`WORK.CLINDSA.cathpci_ppevents_raw_csv_part0002_csv`	Bronze landing table	245,327	26	ppevents_raw.csv.part0002
`WORK.CLINDSA.cathpci_ppevents_raw_csv_part0003_csv`	Bronze landing table	225,125	26	ppevents_raw.csv.part0003
`WORK.CLINDSA.cathpci_preprocinformation_raw_csv`	Bronze landing table	44,864	73	preprocinformation_raw.csv
`WORK.CLINDSA.cathpci_procinfo_raw_csv`	Bronze landing table	44,864	63	procinfo_raw.csv
`STAGE.CLINDSA.CATHPCI_VALIDATION_INPUT_TABLE`	Validation object	Generated by `create_validation_objects.sql`
`STAGE.CLINDSA.CATHPCI_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/cathpci/20260528T174320Z/raw_manifest.json

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

Load SQL

/mnt/c/Users/jna31a/advent-repos/jna31a_ait/registry-runtime/runs/cathpci/20260528T174320Z/snowflake_load_plan/cathpci_load.sql

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

Metadata reference

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