2024-11-27 10:01:33.995946 (MainThread): 10:01:33 Began running node model.hmi_dbt_lib.commercial 2024-11-27 10:01:33.996753 (MainThread): 10:01:33 23 of 30 START sql microbatch model inscape.commercial ......................... [RUN] 2024-11-27 10:01:33.997413 (MainThread): 10:01:33 Re-using an available connection from the pool (formerly master, now model.hmi_dbt_lib.commercial) 2024-11-27 10:01:33.997893 (MainThread): 10:01:33 Began compiling node model.hmi_dbt_lib.commercial 2024-11-27 10:01:34.000765 (MainThread): 10:01:34 Writing injected SQL for node "model.hmi_dbt_lib.commercial" 2024-11-27 10:01:34.001498 (MainThread): 10:01:34 Began executing node model.hmi_dbt_lib.commercial 2024-11-27 10:01:34.003027 (MainThread): 10:01:34 Finished running node model.hmi_dbt_lib.commercial 2024-11-27 10:01:34.004380 (MainThread): 10:01:34 > is being run sequentially 2024-11-27 10:01:34.004914 (MainThread): 10:01:34 Began running node model.hmi_dbt_lib.commercial 2024-11-27 10:01:34.005551 (MainThread): 10:01:34 1 of 2 START batch 2024-11-26 of inscape.commercial ............................ [RUN] 2024-11-27 10:01:34.006235 (MainThread): 10:01:34 Began compiling node model.hmi_dbt_lib.commercial 2024-11-27 10:01:34.008780 (MainThread): 10:01:34 Writing injected SQL for node "model.hmi_dbt_lib.commercial" 2024-11-27 10:01:34.009499 (MainThread): 10:01:34 Began executing node model.hmi_dbt_lib.commercial 2024-11-27 10:01:34.014047 (MainThread): 10:01:34 Writing injected SQL for node "model.hmi_dbt_lib.commercial" 2024-11-27 10:01:34.028194 (MainThread): 10:01:34 Using snowflake connection "model.hmi_dbt_lib.commercial" 2024-11-27 10:01:34.028855 (MainThread): 10:01:34 On model.hmi_dbt_lib.commercial: /* {"app": "dbt", "dbt_version": "2024.11.25+e9c6e22", "profile_name": "user", "target_name": "prod", "node_id": "model.hmi_dbt_lib.commercial"} */ create or replace temporary table HMI_CURATED.inscape.commercial__dbt_tmp as ( with source as ( select * from (select * from HMI_CURATED.inscape.vw_commercial where landed_timestamp >= '2024-11-26 00:00:00+00:00' and landed_timestamp < '2024-11-27 00:00:00+00:00') ) select hmi_uuid ,hashed_unique_tv_id ,zip_code ,dma ,commercial_id ,commercial_start_media_time ,commercial_recognition_start_timestamp ,commercial_recognition_end_timestamp ,previous_content_tms_id as previous_content_id ,previous_content_title ,previous_content_start_timestamp ,previous_content_end_timestamp ,previous_station_callsign ,previous_network ,next_content_tms_id as next_content_id ,next_content_title ,next_content_start_timestamp ,next_content_end_timestamp ,next_station_callsign ,next_network ,live as is_live ,sha2(HMI_CURATED.common.regexp_replace2(ip_address, '(\\b0+)(?!\\b)', ''), 256) as ip_address_hash ,input_category ,input_device ,app_service ,landed_timestamp ,created_timestamp ,modified_timestamp ,partition_date from source ); 2024-11-27 10:01:34.029456 (MainThread): 10:01:34 Opening a new connection, currently in state closed 2024-11-27 10:01:36.139103 (Thread-9 (worker)): 10:01:36 SQL status: SUCCESS 1 in 55.582 seconds 2024-11-27 10:01:36.144963 (Thread-9 (worker)): 10:01:36 On test.hmi_dbt_lib.dbt_utils_unique_combination_of_columns_vw_content_hmi_uuid.4a97f30e7d: Close 2024-11-27 10:01:36.197924 (Thread-9 (worker)): 10:01:36 10 of 30 PASS dbt_utils_unique_combination_of_columns_vw_content_hmi_uuid ...... [[32mPASS[0m in 55.66s] 2024-11-27 10:01:36.198778 (Thread-9 (worker)): 10:01:36 Finished running node test.hmi_dbt_lib.dbt_utils_unique_combination_of_columns_vw_content_hmi_uuid.4a97f30e7d 2024-11-27 10:02:26.716411 (MainThread): 10:02:26 SQL status: SUCCESS 1 in 52.687 seconds 2024-11-27 10:02:26.720468 (MainThread): 10:02:26 Using snowflake connection "model.hmi_dbt_lib.commercial" 2024-11-27 10:02:26.721292 (MainThread): 10:02:26 On model.hmi_dbt_lib.commercial: /* {"app": "dbt", "dbt_version": "2024.11.25+e9c6e22", "profile_name": "user", "target_name": "prod", "node_id": "model.hmi_dbt_lib.commercial"} */ describe table HMI_CURATED.inscape.commercial__dbt_tmp 2024-11-27 10:02:26.793835 (MainThread): 10:02:26 SQL status: SUCCESS 29 in 0.072 seconds 2024-11-27 10:02:26.797385 (MainThread): 10:02:26 Using snowflake connection "model.hmi_dbt_lib.commercial" 2024-11-27 10:02:26.798181 (MainThread): 10:02:26 On model.hmi_dbt_lib.commercial: /* {"app": "dbt", "dbt_version": "2024.11.25+e9c6e22", "profile_name": "user", "target_name": "prod", "node_id": "model.hmi_dbt_lib.commercial"} */ describe table HMI_CURATED.inscape.commercial 2024-11-27 10:02:26.862052 (MainThread): 10:02:26 SQL status: SUCCESS 29 in 0.063 seconds 2024-11-27 10:02:26.865742 (MainThread): 10:02:26 Using snowflake connection "model.hmi_dbt_lib.commercial" 2024-11-27 10:02:26.866409 (MainThread): 10:02:26 On model.hmi_dbt_lib.commercial: /* {"app": "dbt", "dbt_version": "2024.11.25+e9c6e22", "profile_name": "user", "target_name": "prod", "node_id": "model.hmi_dbt_lib.commercial"} */ describe table HMI_CURATED.inscape.commercial__dbt_tmp 2024-11-27 10:02:26.927446 (MainThread): 10:02:26 SQL status: SUCCESS 29 in 0.060 seconds 2024-11-27 10:02:26.931155 (MainThread): 10:02:26 Using snowflake connection "model.hmi_dbt_lib.commercial" 2024-11-27 10:02:26.931788 (MainThread): 10:02:26 On model.hmi_dbt_lib.commercial: /* {"app": "dbt", "dbt_version": "2024.11.25+e9c6e22", "profile_name": "user", "target_name": "prod", "node_id": "model.hmi_dbt_lib.commercial"} */ describe table "HMI_CURATED"."INSCAPE"."COMMERCIAL" 2024-11-27 10:02:27.111521 (MainThread): 10:02:27 SQL status: SUCCESS 29 in 0.179 seconds 2024-11-27 10:02:27.116402 (MainThread): 10:02:27 In "HMI_CURATED"."INSCAPE"."COMMERCIAL": Schema changed: False Source columns not in target: [] Target columns not in source: [] New column types: [] 2024-11-27 10:02:27.124355 (MainThread): 10:02:27 Writing runtime sql for node "model.hmi_dbt_lib.commercial" 2024-11-27 10:02:27.125723 (MainThread): 10:02:27 Using snowflake connection "model.hmi_dbt_lib.commercial" 2024-11-27 10:02:27.126337 (MainThread): 10:02:27 On model.hmi_dbt_lib.commercial: /* {"app": "dbt", "dbt_version": "2024.11.25+e9c6e22", "profile_name": "user", "target_name": "prod", "node_id": "model.hmi_dbt_lib.commercial"} */ delete from HMI_CURATED.inscape.commercial DBT_INTERNAL_TARGET using HMI_CURATED.inscape.commercial__dbt_tmp where ( DBT_INTERNAL_TARGET.landed_timestamp >= TIMESTAMP '2024-11-26 00:00:00+00:00' and DBT_INTERNAL_TARGET.landed_timestamp < TIMESTAMP '2024-11-27 00:00:00+00:00' ); 2024-11-27 10:02:27.490873 (MainThread): 10:02:27 SQL status: SUCCESS 0 in 0.364 seconds 2024-11-27 10:02:27.491692 (MainThread): 10:02:27 Using snowflake connection "model.hmi_dbt_lib.commercial" 2024-11-27 10:02:27.492295 (MainThread): 10:02:27 On model.hmi_dbt_lib.commercial: /* {"app": "dbt", "dbt_version": "2024.11.25+e9c6e22", "profile_name": "user", "target_name": "prod", "node_id": "model.hmi_dbt_lib.commercial"} */ insert into HMI_CURATED.inscape.commercial ("HMI_UUID", "HASHED_UNIQUE_TV_ID", "ZIP_CODE", "DMA", "COMMERCIAL_ID", "COMMERCIAL_START_MEDIA_TIME", "COMMERCIAL_RECOGNITION_START_TIMESTAMP", "COMMERCIAL_RECOGNITION_END_TIMESTAMP", "PREVIOUS_CONTENT_ID", "PREVIOUS_CONTENT_TITLE", "PREVIOUS_CONTENT_START_TIMESTAMP", "PREVIOUS_CONTENT_END_TIMESTAMP", "PREVIOUS_STATION_CALLSIGN", "PREVIOUS_NETWORK", "NEXT_CONTENT_ID", "NEXT_CONTENT_TITLE", "NEXT_CONTENT_START_TIMESTAMP", "NEXT_CONTENT_END_TIMESTAMP", "NEXT_STATION_CALLSIGN", "NEXT_NETWORK", "IS_LIVE", "IP_ADDRESS_HASH", "INPUT_CATEGORY", "INPUT_DEVICE", "APP_SERVICE", "LANDED_TIMESTAMP", "CREATED_TIMESTAMP", "MODIFIED_TIMESTAMP", "PARTITION_DATE") ( select "HMI_UUID", "HASHED_UNIQUE_TV_ID", "ZIP_CODE", "DMA", "COMMERCIAL_ID", "COMMERCIAL_START_MEDIA_TIME", "COMMERCIAL_RECOGNITION_START_TIMESTAMP", "COMMERCIAL_RECOGNITION_END_TIMESTAMP", "PREVIOUS_CONTENT_ID", "PREVIOUS_CONTENT_TITLE", "PREVIOUS_CONTENT_START_TIMESTAMP", "PREVIOUS_CONTENT_END_TIMESTAMP", "PREVIOUS_STATION_CALLSIGN", "PREVIOUS_NETWORK", "NEXT_CONTENT_ID", "NEXT_CONTENT_TITLE", "NEXT_CONTENT_START_TIMESTAMP", "NEXT_CONTENT_END_TIMESTAMP", "NEXT_STATION_CALLSIGN", "NEXT_NETWORK", "IS_LIVE", "IP_ADDRESS_HASH", "INPUT_CATEGORY", "INPUT_DEVICE", "APP_SERVICE", "LANDED_TIMESTAMP", "CREATED_TIMESTAMP", "MODIFIED_TIMESTAMP", "PARTITION_DATE" from HMI_CURATED.inscape.commercial__dbt_tmp ) 2024-11-27 10:03:12.266032 (MainThread): 10:03:12 SQL status: SUCCESS 216774089 in 44.773 seconds 2024-11-27 10:03:12.268726 (MainThread): 10:03:12 Applying DROP to: HMI_CURATED.inscape.commercial__dbt_tmp 2024-11-27 10:03:12.271981 (MainThread): 10:03:12 Using snowflake connection "model.hmi_dbt_lib.commercial" 2024-11-27 10:03:12.272649 (MainThread): 10:03:12 On model.hmi_dbt_lib.commercial: /* {"app": "dbt", "dbt_version": "2024.11.25+e9c6e22", "profile_name": "user", "target_name": "prod", "node_id": "model.hmi_dbt_lib.commercial"} */ drop table if exists HMI_CURATED.inscape.commercial__dbt_tmp cascade 2024-11-27 10:03:12.395436 (MainThread): 10:03:12 SQL status: SUCCESS 1 in 0.122 seconds