Schema Info
Schema Name: sfdl_dev_redshift.analytics_mart_traffic
- created: 2018-03-26 18:34:21
- disabled: False
- format: raw
- id: 698
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_redshift", "table": "analytics_mart_traffic" } - type: redshift
Schema Versions: 3
-
Version 4708854
- created: 2024-08-14 14:29:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_traffic`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_traffic`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `site_type` varchar(32) , `inbound_call` int , `delivered_call` int , `handled_call` int , `call_result` varchar(10) , `device_type` varchar(10) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_type` varchar(16) , `statement_batch_key` int , `incontact_skill_no` int , `nvm_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_name` varchar(45) , `landing_page_facility_key` int , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_client_name` varchar(255) , `landing_page_facility_is_directory` int , `landing_page_site_content_key` int , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_site_content_template_key` int , `landing_page_site_content_template_name` varchar(64) , `landing_page_site_content_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type` varchar(128) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(10,2) , `sparefoot_charge` decimal(10,2) , `billable_instances_current_tenants` int , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_traffic" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440
- id: 4708854
- processed: 1
- raw_data:
{ "_origin": "48", "annotations": "47", "audit_id": "0", "billable_instances_current_tenants": "46", "call_day": "7", "call_result": "16", "calls": "42", "day": "2", "day_key": "1", "delivered_call": "14", "device_type": "17", "handled_call": "15", "hold_day": "3", "inbound_call": "13", "incontact_skill_name": "26", "incontact_skill_no": "24", "landing_page_client_key": "30", "landing_page_client_name": "31", "landing_page_facility_is_directory": "32", "landing_page_facility_key": "28", "landing_page_facility_name": "29", "landing_page_page_type": "40", "landing_page_page_type_key": "39", "landing_page_site_content_key": "33", "landing_page_site_content_template_key": "36", "landing_page_site_content_template_name": "37", "landing_page_site_content_template_type": "38", "landing_page_site_content_title": "34", "landing_page_site_content_uri": "35", "move_in_day": "4", "npv": "44", "nvm_skill_name": "27", "nvm_skill_no": "25", "reservation_auto_state": "21", "reservation_pricing_model": "18", "reservation_state": "20", "reservation_touchpoint": "19", "reservation_type": "22", "reservations": "43", "site": "9", "site_key": "8", "site_type": "12", "sparefoot_charge": "45", "statement_batch_close_day": "6", "statement_batch_key": "23", "statement_batch_move_in_start_day": "5", "traffic_source": "11", "traffic_source_key": "10", "visitors": "41" } - schema_attributes:
{ "_origin": "string", "annotations": "varchar(2048)", "audit_id": "bigint", "billable_instances_current_tenants": "int", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "device_type": "varchar(10)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "landing_page_client_key": "bigint", "landing_page_client_name": "varchar(255)", "landing_page_facility_is_directory": "int", "landing_page_facility_key": "int", "landing_page_facility_name": "varchar(255)", "landing_page_page_type": "varchar(128)", "landing_page_page_type_key": "int", "landing_page_site_content_key": "int", "landing_page_site_content_template_key": "int", "landing_page_site_content_template_name": "varchar(64)", "landing_page_site_content_template_type": "varchar(64)", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "move_in_day": "date", "npv": "decimal(10,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(16)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "site_type": "varchar(32)", "sparefoot_charge": "decimal(10,2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "traffic_source": "varchar(128)", "traffic_source_key": "int", "visitors": "int" } - schema_name_id: 698
- schema_scan_id: 6565883
- updated: 2024-08-14 14:29:46
-
Version 4705958
- created: 2024-05-14 08:26:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_traffic`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_traffic`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `site_type` varchar(32) , `inbound_call` int , `delivered_call` int , `handled_call` int , `call_result` varchar(10) , `device_type` varchar(10) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_type` varchar(16) , `statement_batch_key` int , `incontact_skill_no` int , `nvm_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_name` varchar(45) , `landing_page_facility_key` int , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_client_name` varchar(255) , `landing_page_facility_is_directory` int , `landing_page_site_content_key` int , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_site_content_template_key` int , `landing_page_site_content_template_name` varchar(64) , `landing_page_site_content_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type` varchar(128) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(10,2) , `sparefoot_charge` decimal(10,2) , `billable_instances_current_tenants` int , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_traffic" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095
- id: 4705958
- processed: 1
- raw_data:
{ "_origin": "48", "annotations": "47", "audit_id": "0", "billable_instances_current_tenants": "46", "call_day": "7", "call_result": "16", "calls": "42", "day": "2", "day_key": "1", "delivered_call": "14", "device_type": "17", "handled_call": "15", "hold_day": "3", "inbound_call": "13", "incontact_skill_name": "26", "incontact_skill_no": "24", "landing_page_client_key": "30", "landing_page_client_name": "31", "landing_page_facility_is_directory": "32", "landing_page_facility_key": "28", "landing_page_facility_name": "29", "landing_page_page_type": "40", "landing_page_page_type_key": "39", "landing_page_site_content_key": "33", "landing_page_site_content_template_key": "36", "landing_page_site_content_template_name": "37", "landing_page_site_content_template_type": "38", "landing_page_site_content_title": "34", "landing_page_site_content_uri": "35", "move_in_day": "4", "npv": "44", "nvm_skill_name": "27", "nvm_skill_no": "25", "reservation_auto_state": "21", "reservation_pricing_model": "18", "reservation_state": "20", "reservation_touchpoint": "19", "reservation_type": "22", "reservations": "43", "site": "9", "site_key": "8", "site_type": "12", "sparefoot_charge": "45", "statement_batch_close_day": "6", "statement_batch_key": "23", "statement_batch_move_in_start_day": "5", "traffic_source": "11", "traffic_source_key": "10", "visitors": "41" } - schema_attributes:
{ "_origin": "string", "annotations": "varchar(2048)", "audit_id": "bigint", "billable_instances_current_tenants": "int", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "device_type": "varchar(10)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "landing_page_client_key": "bigint", "landing_page_client_name": "varchar(255)", "landing_page_facility_is_directory": "int", "landing_page_facility_key": "int", "landing_page_facility_name": "varchar(255)", "landing_page_page_type": "varchar(128)", "landing_page_page_type_key": "int", "landing_page_site_content_key": "int", "landing_page_site_content_template_key": "int", "landing_page_site_content_template_name": "varchar(64)", "landing_page_site_content_template_type": "varchar(64)", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "move_in_day": "date", "npv": "decimal(10,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(16)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "site_type": "varchar(32)", "sparefoot_charge": "decimal(10,2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "traffic_source": "varchar(128)", "traffic_source_key": "int", "visitors": "int" } - schema_name_id: 698
- schema_scan_id: 6490662
- updated: 2024-05-14 08:26:39
-
Version 4704312
- created: 2024-03-01 05:17:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_traffic`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_traffic`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `site_type` varchar(32) , `inbound_call` int , `delivered_call` int , `handled_call` int , `call_result` varchar(10) , `device_type` varchar(10) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_type` varchar(16) , `statement_batch_key` int , `incontact_skill_no` int , `nvm_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_name` varchar(45) , `landing_page_facility_key` int , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_client_name` varchar(255) , `landing_page_facility_is_directory` int , `landing_page_site_content_key` int , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_site_content_template_key` int , `landing_page_site_content_template_name` varchar(64) , `landing_page_site_content_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type` varchar(128) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(10,2) , `sparefoot_charge` decimal(10,2) , `billable_instances_current_tenants` int , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-03-01/1709291663'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_traffic" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-03-01/1709291663
- id: 4704312
- processed: 1
- raw_data:
{ "_origin": "48", "annotations": "47", "audit_id": "0", "billable_instances_current_tenants": "46", "call_day": "7", "call_result": "16", "calls": "42", "day": "2", "day_key": "1", "delivered_call": "14", "device_type": "17", "handled_call": "15", "hold_day": "3", "inbound_call": "13", "incontact_skill_name": "26", "incontact_skill_no": "24", "landing_page_client_key": "30", "landing_page_client_name": "31", "landing_page_facility_is_directory": "32", "landing_page_facility_key": "28", "landing_page_facility_name": "29", "landing_page_page_type": "40", "landing_page_page_type_key": "39", "landing_page_site_content_key": "33", "landing_page_site_content_template_key": "36", "landing_page_site_content_template_name": "37", "landing_page_site_content_template_type": "38", "landing_page_site_content_title": "34", "landing_page_site_content_uri": "35", "move_in_day": "4", "npv": "44", "nvm_skill_name": "27", "nvm_skill_no": "25", "reservation_auto_state": "21", "reservation_pricing_model": "18", "reservation_state": "20", "reservation_touchpoint": "19", "reservation_type": "22", "reservations": "43", "site": "9", "site_key": "8", "site_type": "12", "sparefoot_charge": "45", "statement_batch_close_day": "6", "statement_batch_key": "23", "statement_batch_move_in_start_day": "5", "traffic_source": "11", "traffic_source_key": "10", "visitors": "41" } - schema_attributes:
{ "_origin": "string", "annotations": "varchar(2048)", "audit_id": "bigint", "billable_instances_current_tenants": "int", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "device_type": "varchar(10)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "landing_page_client_key": "bigint", "landing_page_client_name": "varchar(255)", "landing_page_facility_is_directory": "int", "landing_page_facility_key": "int", "landing_page_facility_name": "varchar(255)", "landing_page_page_type": "varchar(128)", "landing_page_page_type_key": "int", "landing_page_site_content_key": "int", "landing_page_site_content_template_key": "int", "landing_page_site_content_template_name": "varchar(64)", "landing_page_site_content_template_type": "varchar(64)", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "move_in_day": "date", "npv": "decimal(10,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(16)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "site_type": "varchar(32)", "sparefoot_charge": "decimal(10,2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "traffic_source": "varchar(128)", "traffic_source_key": "int", "visitors": "int" } - schema_name_id: 698
- schema_scan_id: 6441701
- updated: 2024-03-01 05:17:26
Schema Scans: 3
Last at 2024-08-14 14:29:25
-
Scan 6565883
- duration: 0:00:35.710322
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 361, "partitions_applied": false, "success": true } - id: 6565883
- payload:
{ "datatype_dict": { "annotations": "varchar(2048)", "audit_id": "bigint", "billable_instances_current_tenants": "int", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "device_type": "varchar(10)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "landing_page_client_key": "bigint", "landing_page_client_name": "varchar(255)", "landing_page_facility_is_directory": "int", "landing_page_facility_key": "int", "landing_page_facility_name": "varchar(255)", "landing_page_page_type": "varchar(128)", "landing_page_page_type_key": "int", "landing_page_site_content_key": "int", "landing_page_site_content_template_key": "int", "landing_page_site_content_template_name": "varchar(64)", "landing_page_site_content_template_type": "varchar(64)", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "move_in_day": "date", "npv": "decimal(10,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "origin_key": "varchar", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(16)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "site_type": "varchar(32)", "sparefoot_charge": "decimal(10,2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "traffic_source": "varchar(128)", "traffic_source_key": "int", "visitors": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/mart_traffic/2024-08-14/1723663440/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-14", "name": "dt", "type": "string", "value": "2024-08-14" }, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440", "key": "separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-14/0000_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_mart_traffic", "type": "redshift" }, "trace_context": { "parent_id": 5028368925256651035, "service_name": "redshift_unloads", "span_id": 3774562771830695422, "trace_id": 2930228892288168916 } } - running: False
- schema_name_id: 698
- start_time: 2024-08-14 14:29:25
- success: True
- trace_id: 2930228892288168916
-
Scan 6490662
- duration: 0:00:34.355869
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 361, "partitions_applied": false, "success": true } - id: 6490662
- payload:
{ "datatype_dict": { "annotations": "varchar(2048)", "audit_id": "bigint", "billable_instances_current_tenants": "int", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "device_type": "varchar(10)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "landing_page_client_key": "bigint", "landing_page_client_name": "varchar(255)", "landing_page_facility_is_directory": "int", "landing_page_facility_key": "int", "landing_page_facility_name": "varchar(255)", "landing_page_page_type": "varchar(128)", "landing_page_page_type_key": "int", "landing_page_site_content_key": "int", "landing_page_site_content_template_key": "int", "landing_page_site_content_template_name": "varchar(64)", "landing_page_site_content_template_type": "varchar(64)", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "move_in_day": "date", "npv": "decimal(10,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "origin_key": "varchar", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(16)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "site_type": "varchar(32)", "sparefoot_charge": "decimal(10,2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "traffic_source": "varchar(128)", "traffic_source_key": "int", "visitors": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/mart_traffic/2024-05-14/1715693095/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-14", "name": "dt", "type": "string", "value": "2024-05-14" }, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095", "key": "separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-14/0007_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_mart_traffic", "type": "redshift" }, "trace_context": { "parent_id": 963569654353651050, "service_name": "redshift_unloads", "span_id": 16722651961974956803, "trace_id": 17228013139977157025 } } - running: False
- schema_name_id: 698
- start_time: 2024-05-14 08:26:18
- success: True
- trace_id: 17228013139977157025
-
Scan 6441701
- duration: 0:00:31.727176
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 393, "partitions_applied": false, "success": true } - id: 6441701
- payload:
{ "datatype_dict": { "annotations": "varchar(2048)", "audit_id": "bigint", "billable_instances_current_tenants": "int", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "device_type": "varchar(10)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "landing_page_client_key": "bigint", "landing_page_client_name": "varchar(255)", "landing_page_facility_is_directory": "int", "landing_page_facility_key": "int", "landing_page_facility_name": "varchar(255)", "landing_page_page_type": "varchar(128)", "landing_page_page_type_key": "int", "landing_page_site_content_key": "int", "landing_page_site_content_template_key": "int", "landing_page_site_content_template_name": "varchar(64)", "landing_page_site_content_template_type": "varchar(64)", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "move_in_day": "date", "npv": "decimal(10,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "origin_key": "varchar", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(16)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "site_type": "varchar(32)", "sparefoot_charge": "decimal(10,2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "traffic_source": "varchar(128)", "traffic_source_key": "int", "visitors": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/mart_traffic/2024-03-01/1709291663/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-03-01/1709291663/dt=2024-03-01", "name": "dt", "type": "string", "value": "2024-03-01" }, "s3": { "bucket": "sfdl-redshift-analytics-dev", "hive_path": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-03-01/1709291663", "key": "separated_dt/mart_traffic/2024-03-01/1709291663/dt=2024-03-01/0004_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_mart_traffic", "type": "redshift" }, "trace_context": { "parent_id": 14893536417647399358, "service_name": "redshift_unloads", "span_id": 2250784617882431148, "trace_id": 8180428733360831728 } } - running: False
- schema_name_id: 698
- start_time: 2024-03-01 05:17:03
- success: True
- trace_id: 8180428733360831728
- count: 167
- ddl:
[ "ALTER TABLE\n `sfdl_dev_redshift.analytics_mart_traffic`\nADD\n\n\n PARTITION (dt='2024-03-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-03-01/1709291663/dt=2024-03-01/'\n PARTITION (dt='2024-03-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-02/'\n PARTITION (dt='2024-03-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-03/'\n PARTITION (dt='2024-03-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-04/'\n PARTITION (dt='2024-03-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-05/'\n PARTITION (dt='2024-03-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-06/'\n PARTITION (dt='2024-03-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-07/'\n PARTITION (dt='2024-03-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-08/'\n PARTITION (dt='2024-03-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-09/'\n PARTITION (dt='2024-03-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-10/'\n PARTITION (dt='2024-03-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-11/'\n PARTITION (dt='2024-03-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-12/'\n PARTITION (dt='2024-03-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-13/'\n PARTITION (dt='2024-03-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-14/'\n PARTITION (dt='2024-03-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-15/'\n PARTITION (dt='2024-03-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-16/'\n PARTITION (dt='2024-03-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-17/'\n PARTITION (dt='2024-03-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-18/'\n PARTITION (dt='2024-03-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-19/'\n PARTITION (dt='2024-03-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-20/'\n PARTITION (dt='2024-03-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-21/'\n PARTITION (dt='2024-03-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-22/'\n PARTITION (dt='2024-03-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-23/'\n PARTITION (dt='2024-03-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-24/'\n PARTITION (dt='2024-03-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-25/'\n PARTITION (dt='2024-03-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-26/'\n PARTITION (dt='2024-03-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-27/'\n PARTITION (dt='2024-03-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-28/'\n PARTITION (dt='2024-03-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-29/'\n PARTITION (dt='2024-03-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-30/'\n PARTITION (dt='2024-03-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-31/'\n PARTITION (dt='2024-04-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-01/'\n PARTITION (dt='2024-04-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-02/'\n PARTITION (dt='2024-04-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-03/'\n PARTITION (dt='2024-04-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-04/'\n PARTITION (dt='2024-04-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-05/'\n PARTITION (dt='2024-04-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-06/'\n PARTITION (dt='2024-04-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-07/'\n PARTITION (dt='2024-04-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-08/'\n PARTITION (dt='2024-04-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-09/'\n PARTITION (dt='2024-04-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-10/'\n PARTITION (dt='2024-04-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-11/'\n PARTITION (dt='2024-04-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-12/'\n PARTITION (dt='2024-04-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-13/'\n PARTITION (dt='2024-04-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-14/'\n PARTITION (dt='2024-04-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-15/'\n PARTITION (dt='2024-04-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-16/'\n PARTITION (dt='2024-04-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-17/'\n PARTITION (dt='2024-04-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-18/'\n PARTITION (dt='2024-04-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-19/'\n PARTITION (dt='2024-04-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-20/'\n PARTITION (dt='2024-04-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-21/'\n PARTITION (dt='2024-04-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-22/'\n PARTITION (dt='2024-04-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-23/'\n PARTITION (dt='2024-04-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-24/'\n PARTITION (dt='2024-04-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-25/'\n PARTITION (dt='2024-04-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-26/'\n PARTITION (dt='2024-04-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-27/'\n PARTITION (dt='2024-04-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-28/'\n PARTITION (dt='2024-04-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-29/'\n PARTITION (dt='2024-04-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-30/'\n PARTITION (dt='2024-05-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-01/'\n PARTITION (dt='2024-05-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-02/'\n PARTITION (dt='2024-05-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-03/'\n PARTITION (dt='2024-05-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-04/'\n PARTITION (dt='2024-05-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-05/'\n PARTITION (dt='2024-05-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-06/'\n PARTITION (dt='2024-05-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-07/'\n PARTITION (dt='2024-05-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-08/'\n PARTITION (dt='2024-05-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-09/'\n PARTITION (dt='2024-05-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-10/'\n PARTITION (dt='2024-05-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-11/'\n PARTITION (dt='2024-05-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-12/'\n PARTITION (dt='2024-05-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-13/'\n PARTITION (dt='2024-05-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-14/'\n PARTITION (dt='2024-05-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-15/'\n PARTITION (dt='2024-05-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-16/'\n PARTITION (dt='2024-05-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-17/'\n PARTITION (dt='2024-05-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-18/'\n PARTITION (dt='2024-05-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-19/'\n PARTITION (dt='2024-05-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-20/'\n PARTITION (dt='2024-05-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-21/'\n PARTITION (dt='2024-05-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-22/'\n PARTITION (dt='2024-05-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-23/'\n PARTITION (dt='2024-05-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-24/'\n PARTITION (dt='2024-05-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-25/'\n PARTITION (dt='2024-05-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-26/'\n PARTITION (dt='2024-05-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-27/'\n PARTITION (dt='2024-05-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-28/'\n PARTITION (dt='2024-05-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-29/'\n PARTITION (dt='2024-05-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-30/'\n PARTITION (dt='2024-05-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-31/'\n PARTITION (dt='2024-06-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-01/'\n PARTITION (dt='2024-06-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-02/'\n PARTITION (dt='2024-06-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-03/'\n PARTITION (dt='2024-06-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-04/'\n PARTITION (dt='2024-06-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-05/'\n PARTITION (dt='2024-06-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-06/'\n PARTITION (dt='2024-06-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-07/'\n PARTITION (dt='2024-06-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-08/'\n PARTITION (dt='2024-06-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-09/'\n PARTITION (dt='2024-06-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-10/'\n PARTITION (dt='2024-06-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-11/'\n PARTITION (dt='2024-06-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-12/'\n PARTITION (dt='2024-06-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-13/'\n PARTITION (dt='2024-06-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-14/'\n PARTITION (dt='2024-06-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-15/'\n PARTITION (dt='2024-06-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-16/'\n PARTITION (dt='2024-06-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-17/'\n PARTITION (dt='2024-06-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-18/'\n PARTITION (dt='2024-06-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-19/'\n PARTITION (dt='2024-06-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-20/'\n PARTITION (dt='2024-06-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-21/'\n PARTITION (dt='2024-06-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-22/'\n PARTITION (dt='2024-06-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-23/'\n PARTITION (dt='2024-06-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-24/'\n PARTITION (dt='2024-06-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-25/'\n PARTITION (dt='2024-06-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-26/'\n PARTITION (dt='2024-06-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-27/'\n PARTITION (dt='2024-06-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-28/'\n PARTITION (dt='2024-06-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-29/'\n PARTITION (dt='2024-06-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-30/'\n PARTITION (dt='2024-07-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-01/'\n PARTITION (dt='2024-07-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-02/'\n PARTITION (dt='2024-07-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-03/'\n PARTITION (dt='2024-07-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-04/'\n PARTITION (dt='2024-07-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-05/'\n PARTITION (dt='2024-07-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-06/'\n PARTITION (dt='2024-07-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-07/'\n PARTITION (dt='2024-07-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-08/'\n PARTITION (dt='2024-07-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-09/'\n PARTITION (dt='2024-07-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-10/'\n PARTITION (dt='2024-07-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-11/'\n PARTITION (dt='2024-07-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-12/'\n PARTITION (dt='2024-07-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-13/'\n PARTITION (dt='2024-07-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-14/'\n PARTITION (dt='2024-07-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-15/'\n PARTITION (dt='2024-07-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-16/'\n PARTITION (dt='2024-07-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-17/'\n PARTITION (dt='2024-07-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-18/'\n PARTITION (dt='2024-07-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-19/'\n PARTITION (dt='2024-07-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-20/'\n PARTITION (dt='2024-07-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-21/'\n PARTITION (dt='2024-07-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-22/'\n PARTITION (dt='2024-07-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-23/'\n PARTITION (dt='2024-07-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-24/'\n PARTITION (dt='2024-07-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-25/'\n PARTITION (dt='2024-07-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-26/'\n PARTITION (dt='2024-07-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-27/'\n PARTITION (dt='2024-07-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-28/'\n PARTITION (dt='2024-07-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-29/'\n PARTITION (dt='2024-07-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-30/'\n PARTITION (dt='2024-07-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-31/'\n PARTITION (dt='2024-08-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-01/'\n PARTITION (dt='2024-08-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-02/'\n PARTITION (dt='2024-08-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-03/'\n PARTITION (dt='2024-08-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-04/'\n PARTITION (dt='2024-08-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-05/'\n PARTITION (dt='2024-08-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-06/'\n PARTITION (dt='2024-08-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-07/'\n PARTITION (dt='2024-08-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-08/'\n PARTITION (dt='2024-08-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-09/'\n PARTITION (dt='2024-08-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-10/'\n PARTITION (dt='2024-08-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-11/'\n PARTITION (dt='2024-08-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-12/'\n PARTITION (dt='2024-08-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-13/'\n PARTITION (dt='2024-08-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-14/'\n;" ] - name: dt
- state:
[ { "info": { "id": 249679, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-03-01/1709291663/dt=2024-03-01/", "name": "dt", "value": "2024-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-03-01 05:17:05", "last_data": "2024-03-01 05:17:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254246, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-02/", "name": "dt", "value": "2024-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:52", "last_data": "2024-05-14 08:26:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254196, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-03/", "name": "dt", "value": "2024-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:45", "last_data": "2024-05-14 08:26:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254181, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-04/", "name": "dt", "value": "2024-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:42", "last_data": "2024-05-14 08:26:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254241, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-05/", "name": "dt", "value": "2024-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:51", "last_data": "2024-05-14 08:26:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254225, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-06/", "name": "dt", "value": "2024-03-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:49", "last_data": "2024-05-14 08:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254226, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-07/", "name": "dt", "value": "2024-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:49", "last_data": "2024-05-14 08:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254188, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-08/", "name": "dt", "value": "2024-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:43", "last_data": "2024-05-14 08:26:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254207, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-09/", "name": "dt", "value": "2024-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:47", "last_data": "2024-05-14 08:26:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254210, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-10/", "name": "dt", "value": "2024-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:47", "last_data": "2024-05-14 08:26:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254239, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-11/", "name": "dt", "value": "2024-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:51", "last_data": "2024-05-14 08:26:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254178, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-12/", "name": "dt", "value": "2024-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:42", "last_data": "2024-05-14 08:26:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254244, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-13/", "name": "dt", "value": "2024-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:52", "last_data": "2024-05-14 08:26:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254186, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-14/", "name": "dt", "value": "2024-03-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:43", "last_data": "2024-05-14 08:26:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254179, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-15/", "name": "dt", "value": "2024-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:42", "last_data": "2024-05-14 08:26:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254235, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-16/", "name": "dt", "value": "2024-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254249, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-17/", "name": "dt", "value": "2024-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:53", "last_data": "2024-05-14 08:26:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254180, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-18/", "name": "dt", "value": "2024-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:42", "last_data": "2024-05-14 08:26:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254187, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-19/", "name": "dt", "value": "2024-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:43", "last_data": "2024-05-14 08:26:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254245, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-20/", "name": "dt", "value": "2024-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:52", "last_data": "2024-05-14 08:26:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254211, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-21/", "name": "dt", "value": "2024-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:47", "last_data": "2024-05-14 08:26:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254205, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-22/", "name": "dt", "value": "2024-03-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:46", "last_data": "2024-05-14 08:26:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254189, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-23/", "name": "dt", "value": "2024-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:44", "last_data": "2024-05-14 08:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254195, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-24/", "name": "dt", "value": "2024-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:44", "last_data": "2024-05-14 08:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254229, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-25/", "name": "dt", "value": "2024-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254230, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-26/", "name": "dt", "value": "2024-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254216, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-27/", "name": "dt", "value": "2024-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:48", "last_data": "2024-05-14 08:26:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254224, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-28/", "name": "dt", "value": "2024-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:49", "last_data": "2024-05-14 08:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254198, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-29/", "name": "dt", "value": "2024-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:45", "last_data": "2024-05-14 08:26:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254238, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-30/", "name": "dt", "value": "2024-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:51", "last_data": "2024-05-14 08:26:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254218, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-31/", "name": "dt", "value": "2024-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:48", "last_data": "2024-05-14 08:26:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254191, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-01/", "name": "dt", "value": "2024-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:44", "last_data": "2024-05-14 08:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254237, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-02/", "name": "dt", "value": "2024-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254203, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-03/", "name": "dt", "value": "2024-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:46", "last_data": "2024-05-14 08:26:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254192, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-04/", "name": "dt", "value": "2024-04-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:44", "last_data": "2024-05-14 08:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254232, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-05/", "name": "dt", "value": "2024-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254209, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-06/", "name": "dt", "value": "2024-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:47", "last_data": "2024-05-14 08:26:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254212, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-07/", "name": "dt", "value": "2024-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:47", "last_data": "2024-05-14 08:26:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254228, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-08/", "name": "dt", "value": "2024-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:49", "last_data": "2024-05-14 08:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254202, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-09/", "name": "dt", "value": "2024-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:46", "last_data": "2024-05-14 08:26:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254199, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-10/", "name": "dt", "value": "2024-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:45", "last_data": "2024-05-14 08:26:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254208, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-11/", "name": "dt", "value": "2024-04-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:47", "last_data": "2024-05-14 08:26:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254200, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-12/", "name": "dt", "value": "2024-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:45", "last_data": "2024-05-14 08:26:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254206, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-13/", "name": "dt", "value": "2024-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:46", "last_data": "2024-05-14 08:26:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254220, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-14/", "name": "dt", "value": "2024-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:48", "last_data": "2024-05-14 08:26:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254217, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-15/", "name": "dt", "value": "2024-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:48", "last_data": "2024-05-14 08:26:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254250, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-16/", "name": "dt", "value": "2024-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:53", "last_data": "2024-05-14 08:26:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254204, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-17/", "name": "dt", "value": "2024-04-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:46", "last_data": "2024-05-14 08:26:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254227, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-18/", "name": "dt", "value": "2024-04-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:49", "last_data": "2024-05-14 08:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254215, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-19/", "name": "dt", "value": "2024-04-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:48", "last_data": "2024-05-14 08:26:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254213, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-20/", "name": "dt", "value": "2024-04-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:47", "last_data": "2024-05-14 08:26:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254223, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-21/", "name": "dt", "value": "2024-04-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:49", "last_data": "2024-05-14 08:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254214, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-22/", "name": "dt", "value": "2024-04-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:48", "last_data": "2024-05-14 08:26:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254182, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-23/", "name": "dt", "value": "2024-04-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:42", "last_data": "2024-05-14 08:26:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254247, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-24/", "name": "dt", "value": "2024-04-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:52", "last_data": "2024-05-14 08:26:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254197, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-25/", "name": "dt", "value": "2024-04-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:45", "last_data": "2024-05-14 08:26:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254184, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-26/", "name": "dt", "value": "2024-04-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:43", "last_data": "2024-05-14 08:26:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254221, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-27/", "name": "dt", "value": "2024-04-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:48", "last_data": "2024-05-14 08:26:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254236, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-28/", "name": "dt", "value": "2024-04-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254201, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-29/", "name": "dt", "value": "2024-04-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:46", "last_data": "2024-05-14 08:26:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254193, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-30/", "name": "dt", "value": "2024-04-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:44", "last_data": "2024-05-14 08:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254233, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-01/", "name": "dt", "value": "2024-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254219, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-02/", "name": "dt", "value": "2024-05-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:48", "last_data": "2024-05-14 08:26:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254242, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-03/", "name": "dt", "value": "2024-05-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:52", "last_data": "2024-05-14 08:26:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254185, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-04/", "name": "dt", "value": "2024-05-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:43", "last_data": "2024-05-14 08:26:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254190, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-05/", "name": "dt", "value": "2024-05-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:44", "last_data": "2024-05-14 08:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254234, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-06/", "name": "dt", "value": "2024-05-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254194, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-07/", "name": "dt", "value": "2024-05-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:44", "last_data": "2024-05-14 08:26:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254243, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-08/", "name": "dt", "value": "2024-05-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:52", "last_data": "2024-05-14 08:26:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254183, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-09/", "name": "dt", "value": "2024-05-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:42", "last_data": "2024-05-14 08:26:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254231, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-10/", "name": "dt", "value": "2024-05-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:50", "last_data": "2024-05-14 08:26:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254240, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-11/", "name": "dt", "value": "2024-05-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:51", "last_data": "2024-05-14 08:26:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254222, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-12/", "name": "dt", "value": "2024-05-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:49", "last_data": "2024-05-14 08:26:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254248, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-13/", "name": "dt", "value": "2024-05-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:52", "last_data": "2024-05-14 08:26:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254103, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-14/", "name": "dt", "value": "2024-05-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:26:20", "last_data": "2024-05-14 08:26:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259867, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-15/", "name": "dt", "value": "2024-05-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259860, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-16/", "name": "dt", "value": "2024-05-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259841, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-17/", "name": "dt", "value": "2024-05-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:53", "last_data": "2024-08-14 14:29:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259855, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-18/", "name": "dt", "value": "2024-05-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:55", "last_data": "2024-08-14 14:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259897, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-19/", "name": "dt", "value": "2024-05-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:00", "last_data": "2024-08-14 14:30:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259889, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-20/", "name": "dt", "value": "2024-05-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:59", "last_data": "2024-08-14 14:29:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259853, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-21/", "name": "dt", "value": "2024-05-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:55", "last_data": "2024-08-14 14:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259815, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-22/", "name": "dt", "value": "2024-05-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:49", "last_data": "2024-08-14 14:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259869, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-23/", "name": "dt", "value": "2024-05-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:57", "last_data": "2024-08-14 14:29:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259893, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-24/", "name": "dt", "value": "2024-05-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:00", "last_data": "2024-08-14 14:30:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259857, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-25/", "name": "dt", "value": "2024-05-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:55", "last_data": "2024-08-14 14:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259865, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-26/", "name": "dt", "value": "2024-05-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259880, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-27/", "name": "dt", "value": "2024-05-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:58", "last_data": "2024-08-14 14:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259866, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-28/", "name": "dt", "value": "2024-05-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259838, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-29/", "name": "dt", "value": "2024-05-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:52", "last_data": "2024-08-14 14:29:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259863, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-30/", "name": "dt", "value": "2024-05-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259894, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-31/", "name": "dt", "value": "2024-05-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:00", "last_data": "2024-08-14 14:30:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259831, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-01/", "name": "dt", "value": "2024-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:51", "last_data": "2024-08-14 14:29:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259852, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-02/", "name": "dt", "value": "2024-06-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:54", "last_data": "2024-08-14 14:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259877, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-03/", "name": "dt", "value": "2024-06-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:58", "last_data": "2024-08-14 14:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259895, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-04/", "name": "dt", "value": "2024-06-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:00", "last_data": "2024-08-14 14:30:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259882, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-05/", "name": "dt", "value": "2024-06-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:58", "last_data": "2024-08-14 14:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259844, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-06/", "name": "dt", "value": "2024-06-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:53", "last_data": "2024-08-14 14:29:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259821, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-07/", "name": "dt", "value": "2024-06-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:50", "last_data": "2024-08-14 14:29:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259879, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-08/", "name": "dt", "value": "2024-06-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:58", "last_data": "2024-08-14 14:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259881, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-09/", "name": "dt", "value": "2024-06-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:58", "last_data": "2024-08-14 14:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259826, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-10/", "name": "dt", "value": "2024-06-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:50", "last_data": "2024-08-14 14:29:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259896, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-11/", "name": "dt", "value": "2024-06-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:00", "last_data": "2024-08-14 14:30:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259843, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-12/", "name": "dt", "value": "2024-06-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:53", "last_data": "2024-08-14 14:29:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259873, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-13/", "name": "dt", "value": "2024-06-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:57", "last_data": "2024-08-14 14:29:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259899, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-14/", "name": "dt", "value": "2024-06-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:01", "last_data": "2024-08-14 14:30:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259856, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-15/", "name": "dt", "value": "2024-06-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:55", "last_data": "2024-08-14 14:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259819, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-16/", "name": "dt", "value": "2024-06-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:50", "last_data": "2024-08-14 14:29:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259849, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-17/", "name": "dt", "value": "2024-06-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:54", "last_data": "2024-08-14 14:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259874, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-18/", "name": "dt", "value": "2024-06-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:57", "last_data": "2024-08-14 14:29:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259842, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-19/", "name": "dt", "value": "2024-06-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:53", "last_data": "2024-08-14 14:29:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259811, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-20/", "name": "dt", "value": "2024-06-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:49", "last_data": "2024-08-14 14:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259825, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-21/", "name": "dt", "value": "2024-06-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:50", "last_data": "2024-08-14 14:29:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259861, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-22/", "name": "dt", "value": "2024-06-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259875, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-23/", "name": "dt", "value": "2024-06-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:57", "last_data": "2024-08-14 14:29:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259891, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-24/", "name": "dt", "value": "2024-06-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:59", "last_data": "2024-08-14 14:29:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259813, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-25/", "name": "dt", "value": "2024-06-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:49", "last_data": "2024-08-14 14:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259878, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-26/", "name": "dt", "value": "2024-06-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:58", "last_data": "2024-08-14 14:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259835, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-27/", "name": "dt", "value": "2024-06-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:52", "last_data": "2024-08-14 14:29:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259864, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-28/", "name": "dt", "value": "2024-06-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259859, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-29/", "name": "dt", "value": "2024-06-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:55", "last_data": "2024-08-14 14:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259887, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-30/", "name": "dt", "value": "2024-06-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:59", "last_data": "2024-08-14 14:29:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259814, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-01/", "name": "dt", "value": "2024-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:49", "last_data": "2024-08-14 14:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259830, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-02/", "name": "dt", "value": "2024-07-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:51", "last_data": "2024-08-14 14:29:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259816, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-03/", "name": "dt", "value": "2024-07-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:49", "last_data": "2024-08-14 14:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259876, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-04/", "name": "dt", "value": "2024-07-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:57", "last_data": "2024-08-14 14:29:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259871, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-05/", "name": "dt", "value": "2024-07-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:57", "last_data": "2024-08-14 14:29:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259898, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-06/", "name": "dt", "value": "2024-07-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:00", "last_data": "2024-08-14 14:30:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259812, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-07/", "name": "dt", "value": "2024-07-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:49", "last_data": "2024-08-14 14:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259854, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-08/", "name": "dt", "value": "2024-07-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:55", "last_data": "2024-08-14 14:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259868, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-09/", "name": "dt", "value": "2024-07-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259885, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-10/", "name": "dt", "value": "2024-07-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:59", "last_data": "2024-08-14 14:29:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259829, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-11/", "name": "dt", "value": "2024-07-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:51", "last_data": "2024-08-14 14:29:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259827, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-12/", "name": "dt", "value": "2024-07-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:51", "last_data": "2024-08-14 14:29:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259822, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-13/", "name": "dt", "value": "2024-07-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:50", "last_data": "2024-08-14 14:29:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259848, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-14/", "name": "dt", "value": "2024-07-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:54", "last_data": "2024-08-14 14:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259818, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-15/", "name": "dt", "value": "2024-07-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:49", "last_data": "2024-08-14 14:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259892, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-16/", "name": "dt", "value": "2024-07-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:59", "last_data": "2024-08-14 14:29:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259862, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-17/", "name": "dt", "value": "2024-07-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:56", "last_data": "2024-08-14 14:29:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259836, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-18/", "name": "dt", "value": "2024-07-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:52", "last_data": "2024-08-14 14:29:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259828, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-19/", "name": "dt", "value": "2024-07-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:51", "last_data": "2024-08-14 14:29:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259837, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-20/", "name": "dt", "value": "2024-07-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:52", "last_data": "2024-08-14 14:29:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259840, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-21/", "name": "dt", "value": "2024-07-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:53", "last_data": "2024-08-14 14:29:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259845, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-22/", "name": "dt", "value": "2024-07-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:54", "last_data": "2024-08-14 14:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259872, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-23/", "name": "dt", "value": "2024-07-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:57", "last_data": "2024-08-14 14:29:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259839, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-24/", "name": "dt", "value": "2024-07-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:53", "last_data": "2024-08-14 14:29:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259823, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-25/", "name": "dt", "value": "2024-07-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:50", "last_data": "2024-08-14 14:29:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259888, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-26/", "name": "dt", "value": "2024-07-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:59", "last_data": "2024-08-14 14:29:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259846, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-27/", "name": "dt", "value": "2024-07-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:54", "last_data": "2024-08-14 14:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259817, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-28/", "name": "dt", "value": "2024-07-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:49", "last_data": "2024-08-14 14:29:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259858, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-29/", "name": "dt", "value": "2024-07-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:55", "last_data": "2024-08-14 14:29:55" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259850, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-30/", "name": "dt", "value": "2024-07-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:54", "last_data": "2024-08-14 14:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259832, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-31/", "name": "dt", "value": "2024-07-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:51", "last_data": "2024-08-14 14:29:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259886, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-01/", "name": "dt", "value": "2024-08-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:59", "last_data": "2024-08-14 14:29:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259820, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-02/", "name": "dt", "value": "2024-08-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:50", "last_data": "2024-08-14 14:29:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259847, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-03/", "name": "dt", "value": "2024-08-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:54", "last_data": "2024-08-14 14:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259851, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-04/", "name": "dt", "value": "2024-08-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:54", "last_data": "2024-08-14 14:29:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259834, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-05/", "name": "dt", "value": "2024-08-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:52", "last_data": "2024-08-14 14:29:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259890, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-06/", "name": "dt", "value": "2024-08-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:59", "last_data": "2024-08-14 14:29:59" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259870, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-07/", "name": "dt", "value": "2024-08-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:57", "last_data": "2024-08-14 14:29:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259833, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-08/", "name": "dt", "value": "2024-08-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:52", "last_data": "2024-08-14 14:29:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259901, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-09/", "name": "dt", "value": "2024-08-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:01", "last_data": "2024-08-14 14:30:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259824, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-10/", "name": "dt", "value": "2024-08-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:50", "last_data": "2024-08-14 14:29:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259883, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-11/", "name": "dt", "value": "2024-08-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:58", "last_data": "2024-08-14 14:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259900, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-12/", "name": "dt", "value": "2024-08-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:30:01", "last_data": "2024-08-14 14:30:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259884, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-13/", "name": "dt", "value": "2024-08-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:58", "last_data": "2024-08-14 14:29:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259810, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-14/", "name": "dt", "value": "2024-08-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:29:27", "last_data": "2024-08-14 14:29:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "annotations": "varchar(2048)", "audit_id": "bigint", "billable_instances_current_tenants": "int", "call_day": "date", "call_result": "varchar(10)", "calls": "int", "day": "date", "day_key": "int", "delivered_call": "int", "device_type": "varchar(10)", "handled_call": "int", "hold_day": "date", "inbound_call": "int", "incontact_skill_name": "varchar(45)", "incontact_skill_no": "int", "landing_page_client_key": "bigint", "landing_page_client_name": "varchar(255)", "landing_page_facility_is_directory": "int", "landing_page_facility_key": "int", "landing_page_facility_name": "varchar(255)", "landing_page_page_type": "varchar(128)", "landing_page_page_type_key": "int", "landing_page_site_content_key": "int", "landing_page_site_content_template_key": "int", "landing_page_site_content_template_name": "varchar(64)", "landing_page_site_content_template_type": "varchar(64)", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "move_in_day": "date", "npv": "decimal(10,2)", "nvm_skill_name": "varchar(45)", "nvm_skill_no": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(16)", "reservations": "int", "site": "varchar(255)", "site_key": "int", "site_type": "varchar(32)", "sparefoot_charge": "decimal(10,2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "traffic_source": "varchar(128)", "traffic_source_key": "int", "visitors": "int" } - created: 2024-08-14 14:29:27
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_traffic`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `site_type` varchar(32) , `inbound_call` int , `delivered_call` int , `handled_call` int , `call_result` varchar(10) , `device_type` varchar(10) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_type` varchar(16) , `statement_batch_key` int , `incontact_skill_no` int , `nvm_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_name` varchar(45) , `landing_page_facility_key` int , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_client_name` varchar(255) , `landing_page_facility_is_directory` int , `landing_page_site_content_key` int , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_site_content_template_key` int , `landing_page_site_content_template_name` varchar(64) , `landing_page_site_content_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type` varchar(128) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(10,2) , `sparefoot_charge` decimal(10,2) , `billable_instances_current_tenants` int , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_traffic`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_traffic" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2018-03-26 18:34:21",
"disabled": false,
"format": "raw",
"id": 698,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_redshift",
"table": "analytics_mart_traffic"
},
"type": "redshift"
},
"partition": {
"count": 167,
"ddl": [
"ALTER TABLE\n `sfdl_dev_redshift.analytics_mart_traffic`\nADD\n\n\n PARTITION (dt='2024-03-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-03-01/1709291663/dt=2024-03-01/'\n PARTITION (dt='2024-03-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-02/'\n PARTITION (dt='2024-03-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-03/'\n PARTITION (dt='2024-03-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-04/'\n PARTITION (dt='2024-03-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-05/'\n PARTITION (dt='2024-03-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-06/'\n PARTITION (dt='2024-03-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-07/'\n PARTITION (dt='2024-03-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-08/'\n PARTITION (dt='2024-03-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-09/'\n PARTITION (dt='2024-03-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-10/'\n PARTITION (dt='2024-03-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-11/'\n PARTITION (dt='2024-03-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-12/'\n PARTITION (dt='2024-03-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-13/'\n PARTITION (dt='2024-03-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-14/'\n PARTITION (dt='2024-03-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-15/'\n PARTITION (dt='2024-03-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-16/'\n PARTITION (dt='2024-03-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-17/'\n PARTITION (dt='2024-03-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-18/'\n PARTITION (dt='2024-03-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-19/'\n PARTITION (dt='2024-03-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-20/'\n PARTITION (dt='2024-03-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-21/'\n PARTITION (dt='2024-03-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-22/'\n PARTITION (dt='2024-03-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-23/'\n PARTITION (dt='2024-03-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-24/'\n PARTITION (dt='2024-03-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-25/'\n PARTITION (dt='2024-03-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-26/'\n PARTITION (dt='2024-03-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-27/'\n PARTITION (dt='2024-03-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-28/'\n PARTITION (dt='2024-03-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-29/'\n PARTITION (dt='2024-03-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-30/'\n PARTITION (dt='2024-03-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-31/'\n PARTITION (dt='2024-04-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-01/'\n PARTITION (dt='2024-04-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-02/'\n PARTITION (dt='2024-04-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-03/'\n PARTITION (dt='2024-04-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-04/'\n PARTITION (dt='2024-04-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-05/'\n PARTITION (dt='2024-04-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-06/'\n PARTITION (dt='2024-04-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-07/'\n PARTITION (dt='2024-04-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-08/'\n PARTITION (dt='2024-04-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-09/'\n PARTITION (dt='2024-04-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-10/'\n PARTITION (dt='2024-04-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-11/'\n PARTITION (dt='2024-04-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-12/'\n PARTITION (dt='2024-04-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-13/'\n PARTITION (dt='2024-04-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-14/'\n PARTITION (dt='2024-04-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-15/'\n PARTITION (dt='2024-04-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-16/'\n PARTITION (dt='2024-04-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-17/'\n PARTITION (dt='2024-04-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-18/'\n PARTITION (dt='2024-04-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-19/'\n PARTITION (dt='2024-04-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-20/'\n PARTITION (dt='2024-04-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-21/'\n PARTITION (dt='2024-04-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-22/'\n PARTITION (dt='2024-04-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-23/'\n PARTITION (dt='2024-04-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-24/'\n PARTITION (dt='2024-04-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-25/'\n PARTITION (dt='2024-04-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-26/'\n PARTITION (dt='2024-04-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-27/'\n PARTITION (dt='2024-04-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-28/'\n PARTITION (dt='2024-04-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-29/'\n PARTITION (dt='2024-04-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-30/'\n PARTITION (dt='2024-05-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-01/'\n PARTITION (dt='2024-05-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-02/'\n PARTITION (dt='2024-05-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-03/'\n PARTITION (dt='2024-05-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-04/'\n PARTITION (dt='2024-05-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-05/'\n PARTITION (dt='2024-05-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-06/'\n PARTITION (dt='2024-05-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-07/'\n PARTITION (dt='2024-05-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-08/'\n PARTITION (dt='2024-05-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-09/'\n PARTITION (dt='2024-05-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-10/'\n PARTITION (dt='2024-05-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-11/'\n PARTITION (dt='2024-05-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-12/'\n PARTITION (dt='2024-05-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-13/'\n PARTITION (dt='2024-05-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-14/'\n PARTITION (dt='2024-05-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-15/'\n PARTITION (dt='2024-05-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-16/'\n PARTITION (dt='2024-05-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-17/'\n PARTITION (dt='2024-05-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-18/'\n PARTITION (dt='2024-05-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-19/'\n PARTITION (dt='2024-05-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-20/'\n PARTITION (dt='2024-05-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-21/'\n PARTITION (dt='2024-05-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-22/'\n PARTITION (dt='2024-05-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-23/'\n PARTITION (dt='2024-05-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-24/'\n PARTITION (dt='2024-05-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-25/'\n PARTITION (dt='2024-05-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-26/'\n PARTITION (dt='2024-05-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-27/'\n PARTITION (dt='2024-05-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-28/'\n PARTITION (dt='2024-05-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-29/'\n PARTITION (dt='2024-05-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-30/'\n PARTITION (dt='2024-05-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-31/'\n PARTITION (dt='2024-06-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-01/'\n PARTITION (dt='2024-06-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-02/'\n PARTITION (dt='2024-06-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-03/'\n PARTITION (dt='2024-06-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-04/'\n PARTITION (dt='2024-06-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-05/'\n PARTITION (dt='2024-06-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-06/'\n PARTITION (dt='2024-06-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-07/'\n PARTITION (dt='2024-06-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-08/'\n PARTITION (dt='2024-06-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-09/'\n PARTITION (dt='2024-06-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-10/'\n PARTITION (dt='2024-06-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-11/'\n PARTITION (dt='2024-06-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-12/'\n PARTITION (dt='2024-06-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-13/'\n PARTITION (dt='2024-06-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-14/'\n PARTITION (dt='2024-06-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-15/'\n PARTITION (dt='2024-06-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-16/'\n PARTITION (dt='2024-06-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-17/'\n PARTITION (dt='2024-06-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-18/'\n PARTITION (dt='2024-06-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-19/'\n PARTITION (dt='2024-06-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-20/'\n PARTITION (dt='2024-06-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-21/'\n PARTITION (dt='2024-06-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-22/'\n PARTITION (dt='2024-06-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-23/'\n PARTITION (dt='2024-06-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-24/'\n PARTITION (dt='2024-06-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-25/'\n PARTITION (dt='2024-06-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-26/'\n PARTITION (dt='2024-06-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-27/'\n PARTITION (dt='2024-06-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-28/'\n PARTITION (dt='2024-06-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-29/'\n PARTITION (dt='2024-06-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-30/'\n PARTITION (dt='2024-07-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-01/'\n PARTITION (dt='2024-07-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-02/'\n PARTITION (dt='2024-07-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-03/'\n PARTITION (dt='2024-07-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-04/'\n PARTITION (dt='2024-07-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-05/'\n PARTITION (dt='2024-07-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-06/'\n PARTITION (dt='2024-07-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-07/'\n PARTITION (dt='2024-07-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-08/'\n PARTITION (dt='2024-07-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-09/'\n PARTITION (dt='2024-07-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-10/'\n PARTITION (dt='2024-07-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-11/'\n PARTITION (dt='2024-07-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-12/'\n PARTITION (dt='2024-07-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-13/'\n PARTITION (dt='2024-07-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-14/'\n PARTITION (dt='2024-07-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-15/'\n PARTITION (dt='2024-07-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-16/'\n PARTITION (dt='2024-07-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-17/'\n PARTITION (dt='2024-07-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-18/'\n PARTITION (dt='2024-07-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-19/'\n PARTITION (dt='2024-07-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-20/'\n PARTITION (dt='2024-07-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-21/'\n PARTITION (dt='2024-07-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-22/'\n PARTITION (dt='2024-07-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-23/'\n PARTITION (dt='2024-07-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-24/'\n PARTITION (dt='2024-07-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-25/'\n PARTITION (dt='2024-07-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-26/'\n PARTITION (dt='2024-07-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-27/'\n PARTITION (dt='2024-07-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-28/'\n PARTITION (dt='2024-07-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-29/'\n PARTITION (dt='2024-07-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-30/'\n PARTITION (dt='2024-07-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-31/'\n PARTITION (dt='2024-08-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-01/'\n PARTITION (dt='2024-08-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-02/'\n PARTITION (dt='2024-08-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-03/'\n PARTITION (dt='2024-08-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-04/'\n PARTITION (dt='2024-08-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-05/'\n PARTITION (dt='2024-08-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-06/'\n PARTITION (dt='2024-08-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-07/'\n PARTITION (dt='2024-08-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-08/'\n PARTITION (dt='2024-08-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-09/'\n PARTITION (dt='2024-08-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-10/'\n PARTITION (dt='2024-08-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-11/'\n PARTITION (dt='2024-08-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-12/'\n PARTITION (dt='2024-08-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-13/'\n PARTITION (dt='2024-08-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-14/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 249679,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-03-01/1709291663/dt=2024-03-01/",
"name": "dt",
"value": "2024-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-03-01 05:17:05",
"last_data": "2024-03-01 05:17:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254246,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-02/",
"name": "dt",
"value": "2024-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:52",
"last_data": "2024-05-14 08:26:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254196,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-03/",
"name": "dt",
"value": "2024-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:45",
"last_data": "2024-05-14 08:26:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254181,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-04/",
"name": "dt",
"value": "2024-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:42",
"last_data": "2024-05-14 08:26:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254241,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-05/",
"name": "dt",
"value": "2024-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:51",
"last_data": "2024-05-14 08:26:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254225,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-06/",
"name": "dt",
"value": "2024-03-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:49",
"last_data": "2024-05-14 08:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254226,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-07/",
"name": "dt",
"value": "2024-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:49",
"last_data": "2024-05-14 08:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254188,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-08/",
"name": "dt",
"value": "2024-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:43",
"last_data": "2024-05-14 08:26:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254207,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-09/",
"name": "dt",
"value": "2024-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:47",
"last_data": "2024-05-14 08:26:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254210,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-10/",
"name": "dt",
"value": "2024-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:47",
"last_data": "2024-05-14 08:26:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254239,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-11/",
"name": "dt",
"value": "2024-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:51",
"last_data": "2024-05-14 08:26:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254178,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-12/",
"name": "dt",
"value": "2024-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:42",
"last_data": "2024-05-14 08:26:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254244,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-13/",
"name": "dt",
"value": "2024-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:52",
"last_data": "2024-05-14 08:26:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254186,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-14/",
"name": "dt",
"value": "2024-03-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:43",
"last_data": "2024-05-14 08:26:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254179,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-15/",
"name": "dt",
"value": "2024-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:42",
"last_data": "2024-05-14 08:26:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254235,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-16/",
"name": "dt",
"value": "2024-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254249,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-17/",
"name": "dt",
"value": "2024-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:53",
"last_data": "2024-05-14 08:26:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254180,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-18/",
"name": "dt",
"value": "2024-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:42",
"last_data": "2024-05-14 08:26:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254187,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-19/",
"name": "dt",
"value": "2024-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:43",
"last_data": "2024-05-14 08:26:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254245,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-20/",
"name": "dt",
"value": "2024-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:52",
"last_data": "2024-05-14 08:26:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254211,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-21/",
"name": "dt",
"value": "2024-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:47",
"last_data": "2024-05-14 08:26:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254205,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-22/",
"name": "dt",
"value": "2024-03-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:46",
"last_data": "2024-05-14 08:26:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254189,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-23/",
"name": "dt",
"value": "2024-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:44",
"last_data": "2024-05-14 08:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254195,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-24/",
"name": "dt",
"value": "2024-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:44",
"last_data": "2024-05-14 08:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254229,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-25/",
"name": "dt",
"value": "2024-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254230,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-26/",
"name": "dt",
"value": "2024-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254216,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-27/",
"name": "dt",
"value": "2024-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:48",
"last_data": "2024-05-14 08:26:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254224,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-28/",
"name": "dt",
"value": "2024-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:49",
"last_data": "2024-05-14 08:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254198,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-29/",
"name": "dt",
"value": "2024-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:45",
"last_data": "2024-05-14 08:26:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254238,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-30/",
"name": "dt",
"value": "2024-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:51",
"last_data": "2024-05-14 08:26:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254218,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-03-31/",
"name": "dt",
"value": "2024-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:48",
"last_data": "2024-05-14 08:26:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254191,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-01/",
"name": "dt",
"value": "2024-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:44",
"last_data": "2024-05-14 08:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254237,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-02/",
"name": "dt",
"value": "2024-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254203,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-03/",
"name": "dt",
"value": "2024-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:46",
"last_data": "2024-05-14 08:26:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254192,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-04/",
"name": "dt",
"value": "2024-04-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:44",
"last_data": "2024-05-14 08:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254232,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-05/",
"name": "dt",
"value": "2024-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254209,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-06/",
"name": "dt",
"value": "2024-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:47",
"last_data": "2024-05-14 08:26:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254212,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-07/",
"name": "dt",
"value": "2024-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:47",
"last_data": "2024-05-14 08:26:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254228,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-08/",
"name": "dt",
"value": "2024-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:49",
"last_data": "2024-05-14 08:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254202,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-09/",
"name": "dt",
"value": "2024-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:46",
"last_data": "2024-05-14 08:26:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254199,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-10/",
"name": "dt",
"value": "2024-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:45",
"last_data": "2024-05-14 08:26:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254208,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-11/",
"name": "dt",
"value": "2024-04-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:47",
"last_data": "2024-05-14 08:26:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254200,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-12/",
"name": "dt",
"value": "2024-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:45",
"last_data": "2024-05-14 08:26:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254206,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-13/",
"name": "dt",
"value": "2024-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:46",
"last_data": "2024-05-14 08:26:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254220,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-14/",
"name": "dt",
"value": "2024-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:48",
"last_data": "2024-05-14 08:26:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254217,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-15/",
"name": "dt",
"value": "2024-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:48",
"last_data": "2024-05-14 08:26:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254250,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-16/",
"name": "dt",
"value": "2024-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:53",
"last_data": "2024-05-14 08:26:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254204,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-17/",
"name": "dt",
"value": "2024-04-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:46",
"last_data": "2024-05-14 08:26:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254227,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-18/",
"name": "dt",
"value": "2024-04-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:49",
"last_data": "2024-05-14 08:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254215,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-19/",
"name": "dt",
"value": "2024-04-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:48",
"last_data": "2024-05-14 08:26:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254213,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-20/",
"name": "dt",
"value": "2024-04-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:47",
"last_data": "2024-05-14 08:26:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254223,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-21/",
"name": "dt",
"value": "2024-04-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:49",
"last_data": "2024-05-14 08:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254214,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-22/",
"name": "dt",
"value": "2024-04-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:48",
"last_data": "2024-05-14 08:26:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254182,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-23/",
"name": "dt",
"value": "2024-04-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:42",
"last_data": "2024-05-14 08:26:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254247,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-24/",
"name": "dt",
"value": "2024-04-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:52",
"last_data": "2024-05-14 08:26:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254197,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-25/",
"name": "dt",
"value": "2024-04-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:45",
"last_data": "2024-05-14 08:26:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254184,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-26/",
"name": "dt",
"value": "2024-04-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:43",
"last_data": "2024-05-14 08:26:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254221,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-27/",
"name": "dt",
"value": "2024-04-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:48",
"last_data": "2024-05-14 08:26:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254236,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-28/",
"name": "dt",
"value": "2024-04-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254201,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-29/",
"name": "dt",
"value": "2024-04-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:46",
"last_data": "2024-05-14 08:26:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254193,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-04-30/",
"name": "dt",
"value": "2024-04-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:44",
"last_data": "2024-05-14 08:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254233,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-01/",
"name": "dt",
"value": "2024-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254219,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-02/",
"name": "dt",
"value": "2024-05-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:48",
"last_data": "2024-05-14 08:26:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254242,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-03/",
"name": "dt",
"value": "2024-05-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:52",
"last_data": "2024-05-14 08:26:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254185,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-04/",
"name": "dt",
"value": "2024-05-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:43",
"last_data": "2024-05-14 08:26:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254190,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-05/",
"name": "dt",
"value": "2024-05-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:44",
"last_data": "2024-05-14 08:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254234,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-06/",
"name": "dt",
"value": "2024-05-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254194,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-07/",
"name": "dt",
"value": "2024-05-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:44",
"last_data": "2024-05-14 08:26:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254243,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-08/",
"name": "dt",
"value": "2024-05-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:52",
"last_data": "2024-05-14 08:26:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254183,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-09/",
"name": "dt",
"value": "2024-05-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:42",
"last_data": "2024-05-14 08:26:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254231,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-10/",
"name": "dt",
"value": "2024-05-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:50",
"last_data": "2024-05-14 08:26:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254240,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-11/",
"name": "dt",
"value": "2024-05-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:51",
"last_data": "2024-05-14 08:26:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254222,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-12/",
"name": "dt",
"value": "2024-05-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:49",
"last_data": "2024-05-14 08:26:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254248,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-13/",
"name": "dt",
"value": "2024-05-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:52",
"last_data": "2024-05-14 08:26:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254103,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-05-14/1715693095/dt=2024-05-14/",
"name": "dt",
"value": "2024-05-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:26:20",
"last_data": "2024-05-14 08:26:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259867,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-15/",
"name": "dt",
"value": "2024-05-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259860,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-16/",
"name": "dt",
"value": "2024-05-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259841,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-17/",
"name": "dt",
"value": "2024-05-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:53",
"last_data": "2024-08-14 14:29:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259855,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-18/",
"name": "dt",
"value": "2024-05-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:55",
"last_data": "2024-08-14 14:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259897,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-19/",
"name": "dt",
"value": "2024-05-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:00",
"last_data": "2024-08-14 14:30:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259889,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-20/",
"name": "dt",
"value": "2024-05-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:59",
"last_data": "2024-08-14 14:29:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259853,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-21/",
"name": "dt",
"value": "2024-05-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:55",
"last_data": "2024-08-14 14:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259815,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-22/",
"name": "dt",
"value": "2024-05-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:49",
"last_data": "2024-08-14 14:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259869,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-23/",
"name": "dt",
"value": "2024-05-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:57",
"last_data": "2024-08-14 14:29:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259893,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-24/",
"name": "dt",
"value": "2024-05-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:00",
"last_data": "2024-08-14 14:30:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259857,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-25/",
"name": "dt",
"value": "2024-05-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:55",
"last_data": "2024-08-14 14:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259865,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-26/",
"name": "dt",
"value": "2024-05-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259880,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-27/",
"name": "dt",
"value": "2024-05-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:58",
"last_data": "2024-08-14 14:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259866,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-28/",
"name": "dt",
"value": "2024-05-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259838,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-29/",
"name": "dt",
"value": "2024-05-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:52",
"last_data": "2024-08-14 14:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259863,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-30/",
"name": "dt",
"value": "2024-05-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259894,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-05-31/",
"name": "dt",
"value": "2024-05-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:00",
"last_data": "2024-08-14 14:30:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259831,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-01/",
"name": "dt",
"value": "2024-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:51",
"last_data": "2024-08-14 14:29:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259852,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-02/",
"name": "dt",
"value": "2024-06-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:54",
"last_data": "2024-08-14 14:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259877,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-03/",
"name": "dt",
"value": "2024-06-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:58",
"last_data": "2024-08-14 14:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259895,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-04/",
"name": "dt",
"value": "2024-06-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:00",
"last_data": "2024-08-14 14:30:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259882,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-05/",
"name": "dt",
"value": "2024-06-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:58",
"last_data": "2024-08-14 14:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259844,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-06/",
"name": "dt",
"value": "2024-06-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:53",
"last_data": "2024-08-14 14:29:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259821,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-07/",
"name": "dt",
"value": "2024-06-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:50",
"last_data": "2024-08-14 14:29:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259879,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-08/",
"name": "dt",
"value": "2024-06-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:58",
"last_data": "2024-08-14 14:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259881,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-09/",
"name": "dt",
"value": "2024-06-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:58",
"last_data": "2024-08-14 14:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259826,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-10/",
"name": "dt",
"value": "2024-06-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:50",
"last_data": "2024-08-14 14:29:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259896,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-11/",
"name": "dt",
"value": "2024-06-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:00",
"last_data": "2024-08-14 14:30:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259843,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-12/",
"name": "dt",
"value": "2024-06-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:53",
"last_data": "2024-08-14 14:29:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259873,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-13/",
"name": "dt",
"value": "2024-06-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:57",
"last_data": "2024-08-14 14:29:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259899,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-14/",
"name": "dt",
"value": "2024-06-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:01",
"last_data": "2024-08-14 14:30:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259856,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-15/",
"name": "dt",
"value": "2024-06-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:55",
"last_data": "2024-08-14 14:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259819,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-16/",
"name": "dt",
"value": "2024-06-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:50",
"last_data": "2024-08-14 14:29:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259849,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-17/",
"name": "dt",
"value": "2024-06-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:54",
"last_data": "2024-08-14 14:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259874,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-18/",
"name": "dt",
"value": "2024-06-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:57",
"last_data": "2024-08-14 14:29:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259842,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-19/",
"name": "dt",
"value": "2024-06-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:53",
"last_data": "2024-08-14 14:29:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259811,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-20/",
"name": "dt",
"value": "2024-06-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:49",
"last_data": "2024-08-14 14:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259825,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-21/",
"name": "dt",
"value": "2024-06-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:50",
"last_data": "2024-08-14 14:29:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259861,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-22/",
"name": "dt",
"value": "2024-06-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259875,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-23/",
"name": "dt",
"value": "2024-06-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:57",
"last_data": "2024-08-14 14:29:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259891,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-24/",
"name": "dt",
"value": "2024-06-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:59",
"last_data": "2024-08-14 14:29:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259813,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-25/",
"name": "dt",
"value": "2024-06-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:49",
"last_data": "2024-08-14 14:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259878,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-26/",
"name": "dt",
"value": "2024-06-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:58",
"last_data": "2024-08-14 14:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259835,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-27/",
"name": "dt",
"value": "2024-06-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:52",
"last_data": "2024-08-14 14:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259864,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-28/",
"name": "dt",
"value": "2024-06-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259859,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-29/",
"name": "dt",
"value": "2024-06-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:55",
"last_data": "2024-08-14 14:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259887,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-06-30/",
"name": "dt",
"value": "2024-06-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:59",
"last_data": "2024-08-14 14:29:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259814,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-01/",
"name": "dt",
"value": "2024-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:49",
"last_data": "2024-08-14 14:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259830,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-02/",
"name": "dt",
"value": "2024-07-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:51",
"last_data": "2024-08-14 14:29:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259816,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-03/",
"name": "dt",
"value": "2024-07-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:49",
"last_data": "2024-08-14 14:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259876,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-04/",
"name": "dt",
"value": "2024-07-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:57",
"last_data": "2024-08-14 14:29:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259871,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-05/",
"name": "dt",
"value": "2024-07-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:57",
"last_data": "2024-08-14 14:29:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259898,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-06/",
"name": "dt",
"value": "2024-07-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:00",
"last_data": "2024-08-14 14:30:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259812,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-07/",
"name": "dt",
"value": "2024-07-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:49",
"last_data": "2024-08-14 14:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259854,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-08/",
"name": "dt",
"value": "2024-07-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:55",
"last_data": "2024-08-14 14:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259868,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-09/",
"name": "dt",
"value": "2024-07-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259885,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-10/",
"name": "dt",
"value": "2024-07-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:59",
"last_data": "2024-08-14 14:29:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259829,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-11/",
"name": "dt",
"value": "2024-07-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:51",
"last_data": "2024-08-14 14:29:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259827,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-12/",
"name": "dt",
"value": "2024-07-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:51",
"last_data": "2024-08-14 14:29:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259822,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-13/",
"name": "dt",
"value": "2024-07-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:50",
"last_data": "2024-08-14 14:29:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259848,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-14/",
"name": "dt",
"value": "2024-07-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:54",
"last_data": "2024-08-14 14:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259818,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-15/",
"name": "dt",
"value": "2024-07-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:49",
"last_data": "2024-08-14 14:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259892,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-16/",
"name": "dt",
"value": "2024-07-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:59",
"last_data": "2024-08-14 14:29:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259862,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-17/",
"name": "dt",
"value": "2024-07-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:56",
"last_data": "2024-08-14 14:29:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259836,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-18/",
"name": "dt",
"value": "2024-07-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:52",
"last_data": "2024-08-14 14:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259828,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-19/",
"name": "dt",
"value": "2024-07-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:51",
"last_data": "2024-08-14 14:29:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259837,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-20/",
"name": "dt",
"value": "2024-07-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:52",
"last_data": "2024-08-14 14:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259840,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-21/",
"name": "dt",
"value": "2024-07-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:53",
"last_data": "2024-08-14 14:29:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259845,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-22/",
"name": "dt",
"value": "2024-07-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:54",
"last_data": "2024-08-14 14:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259872,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-23/",
"name": "dt",
"value": "2024-07-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:57",
"last_data": "2024-08-14 14:29:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259839,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-24/",
"name": "dt",
"value": "2024-07-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:53",
"last_data": "2024-08-14 14:29:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259823,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-25/",
"name": "dt",
"value": "2024-07-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:50",
"last_data": "2024-08-14 14:29:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259888,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-26/",
"name": "dt",
"value": "2024-07-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:59",
"last_data": "2024-08-14 14:29:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259846,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-27/",
"name": "dt",
"value": "2024-07-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:54",
"last_data": "2024-08-14 14:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259817,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-28/",
"name": "dt",
"value": "2024-07-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:49",
"last_data": "2024-08-14 14:29:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259858,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-29/",
"name": "dt",
"value": "2024-07-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:55",
"last_data": "2024-08-14 14:29:55"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259850,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-30/",
"name": "dt",
"value": "2024-07-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:54",
"last_data": "2024-08-14 14:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259832,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-07-31/",
"name": "dt",
"value": "2024-07-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:51",
"last_data": "2024-08-14 14:29:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259886,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-01/",
"name": "dt",
"value": "2024-08-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:59",
"last_data": "2024-08-14 14:29:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259820,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-02/",
"name": "dt",
"value": "2024-08-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:50",
"last_data": "2024-08-14 14:29:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259847,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-03/",
"name": "dt",
"value": "2024-08-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:54",
"last_data": "2024-08-14 14:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259851,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-04/",
"name": "dt",
"value": "2024-08-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:54",
"last_data": "2024-08-14 14:29:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259834,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-05/",
"name": "dt",
"value": "2024-08-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:52",
"last_data": "2024-08-14 14:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259890,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-06/",
"name": "dt",
"value": "2024-08-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:59",
"last_data": "2024-08-14 14:29:59"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259870,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-07/",
"name": "dt",
"value": "2024-08-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:57",
"last_data": "2024-08-14 14:29:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259833,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-08/",
"name": "dt",
"value": "2024-08-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:52",
"last_data": "2024-08-14 14:29:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259901,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-09/",
"name": "dt",
"value": "2024-08-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:01",
"last_data": "2024-08-14 14:30:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259824,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-10/",
"name": "dt",
"value": "2024-08-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:50",
"last_data": "2024-08-14 14:29:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259883,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-11/",
"name": "dt",
"value": "2024-08-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:58",
"last_data": "2024-08-14 14:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259900,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-12/",
"name": "dt",
"value": "2024-08-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:30:01",
"last_data": "2024-08-14 14:30:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259884,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-13/",
"name": "dt",
"value": "2024-08-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:58",
"last_data": "2024-08-14 14:29:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259810,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440/dt=2024-08-14/",
"name": "dt",
"value": "2024-08-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:29:27",
"last_data": "2024-08-14 14:29:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"annotations": "varchar(2048)",
"audit_id": "bigint",
"billable_instances_current_tenants": "int",
"call_day": "date",
"call_result": "varchar(10)",
"calls": "int",
"day": "date",
"day_key": "int",
"delivered_call": "int",
"device_type": "varchar(10)",
"handled_call": "int",
"hold_day": "date",
"inbound_call": "int",
"incontact_skill_name": "varchar(45)",
"incontact_skill_no": "int",
"landing_page_client_key": "bigint",
"landing_page_client_name": "varchar(255)",
"landing_page_facility_is_directory": "int",
"landing_page_facility_key": "int",
"landing_page_facility_name": "varchar(255)",
"landing_page_page_type": "varchar(128)",
"landing_page_page_type_key": "int",
"landing_page_site_content_key": "int",
"landing_page_site_content_template_key": "int",
"landing_page_site_content_template_name": "varchar(64)",
"landing_page_site_content_template_type": "varchar(64)",
"landing_page_site_content_title": "varchar(255)",
"landing_page_site_content_uri": "varchar(128)",
"move_in_day": "date",
"npv": "decimal(10,2)",
"nvm_skill_name": "varchar(45)",
"nvm_skill_no": "int",
"reservation_auto_state": "varchar(20)",
"reservation_pricing_model": "varchar(12)",
"reservation_state": "varchar(20)",
"reservation_touchpoint": "varchar(19)",
"reservation_type": "varchar(16)",
"reservations": "int",
"site": "varchar(255)",
"site_key": "int",
"site_type": "varchar(32)",
"sparefoot_charge": "decimal(10,2)",
"statement_batch_close_day": "date",
"statement_batch_key": "int",
"statement_batch_move_in_start_day": "date",
"traffic_source": "varchar(128)",
"traffic_source_key": "int",
"visitors": "int"
},
"created": "2024-08-14 14:29:27",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_traffic`\n(\n `audit_id` bigint , `day_key` int , `day` date , `hold_day` date , `move_in_day` date , `statement_batch_move_in_start_day` date , `statement_batch_close_day` date , `call_day` date , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `site_type` varchar(32) , `inbound_call` int , `delivered_call` int , `handled_call` int , `call_result` varchar(10) , `device_type` varchar(10) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_type` varchar(16) , `statement_batch_key` int , `incontact_skill_no` int , `nvm_skill_no` int , `incontact_skill_name` varchar(45) , `nvm_skill_name` varchar(45) , `landing_page_facility_key` int , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_client_name` varchar(255) , `landing_page_facility_is_directory` int , `landing_page_site_content_key` int , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_site_content_template_key` int , `landing_page_site_content_template_name` varchar(64) , `landing_page_site_content_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type` varchar(128) , `visitors` int , `calls` int , `reservations` int , `npv` decimal(10,2) , `sparefoot_charge` decimal(10,2) , `billable_instances_current_tenants` int , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_traffic/2024-08-14/1723663440'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_traffic`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_traffic"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}