Snowflake DDL Execution Order


Step ID	Script	Description
1	Step1_canonical_source_snowflake.sql	Canonical source tables
2	Step2_raw_ddl_snowflake.sql	Raw layer DDL
3	Step3_ldz_ddl_snowflake.sql	LDZ tables
4	Step4_rdv_ddl_snowflake.sql	RDV tables
5	Step5_bdv_ddls_snowflake.sql	BDV tables
6	Step6_ddl_360_snowflake.sql	360 tables
7	Step6b_cdm_ingest_ddl_snowflake.sql	CDM ingest DDL
8	Step7_date_control_snowflake.sql	ETL control tables
9	Step8_reference_data_snowflake.sql	Reference data
10	Step9_bdv_camp_views_snowflake.sql	BDV Camp View
11	Step10_campaign_raw_views_snowflake.sql	RawCamp View
12	Step10a_dimensional_views_snowflake.sql	Dimensional View
13	Step10b_fact_party_device_relationship_snowflake.sql	Fact Table
14	Step10c_updated_dim_account_snowflake.sql	Dim Table
15	Step10d_updated_dim_party_snowflake.sql	Dim Table
16	Step10e_fact_relationship_views_snowflake.sql	Fact Table
17	Step10f_multi_active_dimensional_and_bridge_views_snowflake.sql	Multi Active Dimensional View
18	Step10g_transaction_facts_snowflake.sql	Transaction Fact Table
19	Step11a_cdm_publish_views_snowflake.sql	Im_cdp_db View
20	Step11b_360_views_snowflake.sql	360 View

Warning: Post-deployment: A DBA must run post-grant scripts after DDL completes. Refer (DDL Execution) for the trigger procedure, then contact your HCL representative for the post-grant script package.