Schema Info
Schema Name: sfdl_dev_redshift.analytics_mart_facility_performance
- created: 2018-03-26 18:10:15
- disabled: False
- format: raw
- id: 691
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_redshift", "table": "analytics_mart_facility_performance" } - type: redshift
Schema Versions: 3
-
Version 4708855
- created: 2024-08-14 14:32:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_facility_performance`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_facility_performance`\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 , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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_facility_performance/2024-08-14/1723663430'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_facility_performance" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430
- id: 4708855
- processed: 1
- raw_data:
{ "_origin": "50", "account_customer_segment": "17", "account_lifetime_customer_segment": "18", "account_manager": "20", "account_manager_key": "19", "account_pricing_model": "21", "annotations": "35", "audit_id": "0", "average_sort_position": "41", "bid_flat": "44", "bid_percent": "45", "city": "24", "clicks": "38", "client_key": "11", "client_name": "12", "county": "27", "day": "2", "day_key": "1", "facility_date_live": "15", "facility_is_directory": "16", "facility_key": "9", "facility_name": "10", "facility_status": "34", "hold_day": "3", "impressions": "37", "integration": "14", "integration_key": "13", "location_key": "22", "move_in_day": "4", "msa": "26", "negative_bid_change_amount": "49", "negative_bid_changes": "47", "npv": "43", "positive_bid_change_amount": "48", "positive_bid_changes": "46", "reservation_auto_state": "32", "reservation_pricing_model": "29", "reservation_state": "31", "reservation_touchpoint": "30", "reservation_type": "28", "reservations": "42", "searches": "39", "site": "8", "site_key": "7", "sparefoot_charge": "36", "state": "25", "statement_batch_close_day": "6", "statement_batch_key": "33", "statement_batch_move_in_start_day": "5", "sum_rank": "40", "zip": "23" } - schema_attributes:
{ "_origin": "string", "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" } - schema_name_id: 691
- schema_scan_id: 6565884
- updated: 2024-08-14 14:32:39
-
Version 4705955
- created: 2024-05-14 08:25:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_facility_performance`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_facility_performance`\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 , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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_facility_performance/2024-05-14/1715692442'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_facility_performance" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442
- id: 4705955
- processed: 1
- raw_data:
{ "_origin": "50", "account_customer_segment": "17", "account_lifetime_customer_segment": "18", "account_manager": "20", "account_manager_key": "19", "account_pricing_model": "21", "annotations": "35", "audit_id": "0", "average_sort_position": "41", "bid_flat": "44", "bid_percent": "45", "city": "24", "clicks": "38", "client_key": "11", "client_name": "12", "county": "27", "day": "2", "day_key": "1", "facility_date_live": "15", "facility_is_directory": "16", "facility_key": "9", "facility_name": "10", "facility_status": "34", "hold_day": "3", "impressions": "37", "integration": "14", "integration_key": "13", "location_key": "22", "move_in_day": "4", "msa": "26", "negative_bid_change_amount": "49", "negative_bid_changes": "47", "npv": "43", "positive_bid_change_amount": "48", "positive_bid_changes": "46", "reservation_auto_state": "32", "reservation_pricing_model": "29", "reservation_state": "31", "reservation_touchpoint": "30", "reservation_type": "28", "reservations": "42", "searches": "39", "site": "8", "site_key": "7", "sparefoot_charge": "36", "state": "25", "statement_batch_close_day": "6", "statement_batch_key": "33", "statement_batch_move_in_start_day": "5", "sum_rank": "40", "zip": "23" } - schema_attributes:
{ "_origin": "string", "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" } - schema_name_id: 691
- schema_scan_id: 6490658
- updated: 2024-05-14 08:25:31
-
Version 4704314
- created: 2024-03-01 05:26:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_dev_redshift`", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_facility_performance`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_facility_performance`\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 , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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_facility_performance/2024-03-01/1709291662'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_facility_performance" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-03-01/1709291662
- id: 4704314
- processed: 1
- raw_data:
{ "_origin": "50", "account_customer_segment": "17", "account_lifetime_customer_segment": "18", "account_manager": "20", "account_manager_key": "19", "account_pricing_model": "21", "annotations": "35", "audit_id": "0", "average_sort_position": "41", "bid_flat": "44", "bid_percent": "45", "city": "24", "clicks": "38", "client_key": "11", "client_name": "12", "county": "27", "day": "2", "day_key": "1", "facility_date_live": "15", "facility_is_directory": "16", "facility_key": "9", "facility_name": "10", "facility_status": "34", "hold_day": "3", "impressions": "37", "integration": "14", "integration_key": "13", "location_key": "22", "move_in_day": "4", "msa": "26", "negative_bid_change_amount": "49", "negative_bid_changes": "47", "npv": "43", "positive_bid_change_amount": "48", "positive_bid_changes": "46", "reservation_auto_state": "32", "reservation_pricing_model": "29", "reservation_state": "31", "reservation_touchpoint": "30", "reservation_type": "28", "reservations": "42", "searches": "39", "site": "8", "site_key": "7", "sparefoot_charge": "36", "state": "25", "statement_batch_close_day": "6", "statement_batch_key": "33", "statement_batch_move_in_start_day": "5", "sum_rank": "40", "zip": "23" } - schema_attributes:
{ "_origin": "string", "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" } - schema_name_id: 691
- schema_scan_id: 6441703
- updated: 2024-03-01 05:27:17
Schema Scans: 3
Last at 2024-08-14 14:32:16
-
Scan 6565884
- duration: 0:00:37.968925
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 361, "partitions_applied": false, "success": true } - id: 6565884
- payload:
{ "datatype_dict": { "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/mart_facility_performance/2024-08-14/1723663430/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/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_facility_performance/2024-08-14/1723663430", "key": "separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-14/0000_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_mart_facility_performance", "type": "redshift" }, "trace_context": { "parent_id": 14110933896997597291, "service_name": "redshift_unloads", "span_id": 4884095094921595513, "trace_id": 5800712059621721016 } } - running: False
- schema_name_id: 691
- start_time: 2024-08-14 14:32:16
- success: True
- trace_id: 5800712059621721016
-
Scan 6490658
- duration: 0:00:34.148135
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 361, "partitions_applied": false, "success": true } - id: 6490658
- payload:
{ "datatype_dict": { "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/mart_facility_performance/2024-05-14/1715692442/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/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_facility_performance/2024-05-14/1715692442", "key": "separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-14/0007_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_mart_facility_performance", "type": "redshift" }, "trace_context": { "parent_id": 12084212774373222784, "service_name": "redshift_unloads", "span_id": 7727384880627661658, "trace_id": 128825754176401993 } } - running: False
- schema_name_id: 691
- start_time: 2024-05-14 08:25:10
- success: True
- trace_id: 128825754176401993
-
Scan 6441703
- duration: 0:00:34.248100
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 393, "partitions_applied": false, "success": true } - id: 6441703
- payload:
{ "datatype_dict": { "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "origin_key": "varchar", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" }, "file_format": "dat", "file_properties": { "data_has_header_row": false, "header_s3_object": { "bucket": "sfdl-redshift-analytics-dev", "key": "meta/mart_facility_performance/2024-03-01/1709291662/header.json" }, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-03-01/1709291662/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_facility_performance/2024-03-01/1709291662", "key": "separated_dt/mart_facility_performance/2024-03-01/1709291662/dt=2024-03-01/0004_part_00.gz" }, "schema": { "name": "sfdl_dev_redshift.analytics_mart_facility_performance", "type": "redshift" }, "trace_context": { "parent_id": 11899931123507381024, "service_name": "redshift_unloads", "span_id": 6622133561103207936, "trace_id": 6178469377437142148 } } - running: False
- schema_name_id: 691
- start_time: 2024-03-01 05:26:54
- success: True
- trace_id: 6178469377437142148
- count: 167
- ddl:
[ "ALTER TABLE\n `sfdl_dev_redshift.analytics_mart_facility_performance`\nADD\n\n\n PARTITION (dt='2024-03-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-03-01/1709291662/dt=2024-03-01/'\n PARTITION (dt='2024-03-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-02/'\n PARTITION (dt='2024-03-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-03/'\n PARTITION (dt='2024-03-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-04/'\n PARTITION (dt='2024-03-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-05/'\n PARTITION (dt='2024-03-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-06/'\n PARTITION (dt='2024-03-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-07/'\n PARTITION (dt='2024-03-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-08/'\n PARTITION (dt='2024-03-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-09/'\n PARTITION (dt='2024-03-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-10/'\n PARTITION (dt='2024-03-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-11/'\n PARTITION (dt='2024-03-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-12/'\n PARTITION (dt='2024-03-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-13/'\n PARTITION (dt='2024-03-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-14/'\n PARTITION (dt='2024-03-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-15/'\n PARTITION (dt='2024-03-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-16/'\n PARTITION (dt='2024-03-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-17/'\n PARTITION (dt='2024-03-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-18/'\n PARTITION (dt='2024-03-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-19/'\n PARTITION (dt='2024-03-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-20/'\n PARTITION (dt='2024-03-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-21/'\n PARTITION (dt='2024-03-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-22/'\n PARTITION (dt='2024-03-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-23/'\n PARTITION (dt='2024-03-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-24/'\n PARTITION (dt='2024-03-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-25/'\n PARTITION (dt='2024-03-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-26/'\n PARTITION (dt='2024-03-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-27/'\n PARTITION (dt='2024-03-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-28/'\n PARTITION (dt='2024-03-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-29/'\n PARTITION (dt='2024-03-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-30/'\n PARTITION (dt='2024-03-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-31/'\n PARTITION (dt='2024-04-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-01/'\n PARTITION (dt='2024-04-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-02/'\n PARTITION (dt='2024-04-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-03/'\n PARTITION (dt='2024-04-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-04/'\n PARTITION (dt='2024-04-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-05/'\n PARTITION (dt='2024-04-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-06/'\n PARTITION (dt='2024-04-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-07/'\n PARTITION (dt='2024-04-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-08/'\n PARTITION (dt='2024-04-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-09/'\n PARTITION (dt='2024-04-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-10/'\n PARTITION (dt='2024-04-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-11/'\n PARTITION (dt='2024-04-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-12/'\n PARTITION (dt='2024-04-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-13/'\n PARTITION (dt='2024-04-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-14/'\n PARTITION (dt='2024-04-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-15/'\n PARTITION (dt='2024-04-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-16/'\n PARTITION (dt='2024-04-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-17/'\n PARTITION (dt='2024-04-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-18/'\n PARTITION (dt='2024-04-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-19/'\n PARTITION (dt='2024-04-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-20/'\n PARTITION (dt='2024-04-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-21/'\n PARTITION (dt='2024-04-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-22/'\n PARTITION (dt='2024-04-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-23/'\n PARTITION (dt='2024-04-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-24/'\n PARTITION (dt='2024-04-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-25/'\n PARTITION (dt='2024-04-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-26/'\n PARTITION (dt='2024-04-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-27/'\n PARTITION (dt='2024-04-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-28/'\n PARTITION (dt='2024-04-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-29/'\n PARTITION (dt='2024-04-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-30/'\n PARTITION (dt='2024-05-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-01/'\n PARTITION (dt='2024-05-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-02/'\n PARTITION (dt='2024-05-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-03/'\n PARTITION (dt='2024-05-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-04/'\n PARTITION (dt='2024-05-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-05/'\n PARTITION (dt='2024-05-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-06/'\n PARTITION (dt='2024-05-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-07/'\n PARTITION (dt='2024-05-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-08/'\n PARTITION (dt='2024-05-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-09/'\n PARTITION (dt='2024-05-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-10/'\n PARTITION (dt='2024-05-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-11/'\n PARTITION (dt='2024-05-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-12/'\n PARTITION (dt='2024-05-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-13/'\n PARTITION (dt='2024-05-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-14/'\n PARTITION (dt='2024-05-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-15/'\n PARTITION (dt='2024-05-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-16/'\n PARTITION (dt='2024-05-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-17/'\n PARTITION (dt='2024-05-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-18/'\n PARTITION (dt='2024-05-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-19/'\n PARTITION (dt='2024-05-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-20/'\n PARTITION (dt='2024-05-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-21/'\n PARTITION (dt='2024-05-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-22/'\n PARTITION (dt='2024-05-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-23/'\n PARTITION (dt='2024-05-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-24/'\n PARTITION (dt='2024-05-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-25/'\n PARTITION (dt='2024-05-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-26/'\n PARTITION (dt='2024-05-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-27/'\n PARTITION (dt='2024-05-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-28/'\n PARTITION (dt='2024-05-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-29/'\n PARTITION (dt='2024-05-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-30/'\n PARTITION (dt='2024-05-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-31/'\n PARTITION (dt='2024-06-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-01/'\n PARTITION (dt='2024-06-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-02/'\n PARTITION (dt='2024-06-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-03/'\n PARTITION (dt='2024-06-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-04/'\n PARTITION (dt='2024-06-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-05/'\n PARTITION (dt='2024-06-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-06/'\n PARTITION (dt='2024-06-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-07/'\n PARTITION (dt='2024-06-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-08/'\n PARTITION (dt='2024-06-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-09/'\n PARTITION (dt='2024-06-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-10/'\n PARTITION (dt='2024-06-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-11/'\n PARTITION (dt='2024-06-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-12/'\n PARTITION (dt='2024-06-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-13/'\n PARTITION (dt='2024-06-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-14/'\n PARTITION (dt='2024-06-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-15/'\n PARTITION (dt='2024-06-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-16/'\n PARTITION (dt='2024-06-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-17/'\n PARTITION (dt='2024-06-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-18/'\n PARTITION (dt='2024-06-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-19/'\n PARTITION (dt='2024-06-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-20/'\n PARTITION (dt='2024-06-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-21/'\n PARTITION (dt='2024-06-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-22/'\n PARTITION (dt='2024-06-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-23/'\n PARTITION (dt='2024-06-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-24/'\n PARTITION (dt='2024-06-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-25/'\n PARTITION (dt='2024-06-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-26/'\n PARTITION (dt='2024-06-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-27/'\n PARTITION (dt='2024-06-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-28/'\n PARTITION (dt='2024-06-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-29/'\n PARTITION (dt='2024-06-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-30/'\n PARTITION (dt='2024-07-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-01/'\n PARTITION (dt='2024-07-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-02/'\n PARTITION (dt='2024-07-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-03/'\n PARTITION (dt='2024-07-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-04/'\n PARTITION (dt='2024-07-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-05/'\n PARTITION (dt='2024-07-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-06/'\n PARTITION (dt='2024-07-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-07/'\n PARTITION (dt='2024-07-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-08/'\n PARTITION (dt='2024-07-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-09/'\n PARTITION (dt='2024-07-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-10/'\n PARTITION (dt='2024-07-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-11/'\n PARTITION (dt='2024-07-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-12/'\n PARTITION (dt='2024-07-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-13/'\n PARTITION (dt='2024-07-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-14/'\n PARTITION (dt='2024-07-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-15/'\n PARTITION (dt='2024-07-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-16/'\n PARTITION (dt='2024-07-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-17/'\n PARTITION (dt='2024-07-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-18/'\n PARTITION (dt='2024-07-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-19/'\n PARTITION (dt='2024-07-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-20/'\n PARTITION (dt='2024-07-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-21/'\n PARTITION (dt='2024-07-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-22/'\n PARTITION (dt='2024-07-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-23/'\n PARTITION (dt='2024-07-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-24/'\n PARTITION (dt='2024-07-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-25/'\n PARTITION (dt='2024-07-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-26/'\n PARTITION (dt='2024-07-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-27/'\n PARTITION (dt='2024-07-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-28/'\n PARTITION (dt='2024-07-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-29/'\n PARTITION (dt='2024-07-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-30/'\n PARTITION (dt='2024-07-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-31/'\n PARTITION (dt='2024-08-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-01/'\n PARTITION (dt='2024-08-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-02/'\n PARTITION (dt='2024-08-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-03/'\n PARTITION (dt='2024-08-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-04/'\n PARTITION (dt='2024-08-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-05/'\n PARTITION (dt='2024-08-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-06/'\n PARTITION (dt='2024-08-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-07/'\n PARTITION (dt='2024-08-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-08/'\n PARTITION (dt='2024-08-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-09/'\n PARTITION (dt='2024-08-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-10/'\n PARTITION (dt='2024-08-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-11/'\n PARTITION (dt='2024-08-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-12/'\n PARTITION (dt='2024-08-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-13/'\n PARTITION (dt='2024-08-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-14/'\n;" ] - name: dt
- state:
[ { "info": { "id": 249681, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-03-01/1709291662/dt=2024-03-01/", "name": "dt", "value": "2024-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-03-01 05:26:56", "last_data": "2024-03-01 05:26:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254071, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-02/", "name": "dt", "value": "2024-03-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:41", "last_data": "2024-05-14 08:25:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254042, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-03/", "name": "dt", "value": "2024-03-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:37", "last_data": "2024-05-14 08:25:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254057, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-04/", "name": "dt", "value": "2024-03-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:39", "last_data": "2024-05-14 08:25:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254093, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-05/", "name": "dt", "value": "2024-03-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:44", "last_data": "2024-05-14 08:25:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254068, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-06/", "name": "dt", "value": "2024-03-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:40", "last_data": "2024-05-14 08:25:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254084, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-07/", "name": "dt", "value": "2024-03-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:43", "last_data": "2024-05-14 08:25:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254064, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-08/", "name": "dt", "value": "2024-03-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:40", "last_data": "2024-05-14 08:25:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254031, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-09/", "name": "dt", "value": "2024-03-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:35", "last_data": "2024-05-14 08:25:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254029, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-10/", "name": "dt", "value": "2024-03-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:34", "last_data": "2024-05-14 08:25:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254094, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-11/", "name": "dt", "value": "2024-03-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:44", "last_data": "2024-05-14 08:25:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254027, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-12/", "name": "dt", "value": "2024-03-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:34", "last_data": "2024-05-14 08:25:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254030, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-13/", "name": "dt", "value": "2024-03-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:35", "last_data": "2024-05-14 08:25:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254033, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-14/", "name": "dt", "value": "2024-03-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:35", "last_data": "2024-05-14 08:25:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254091, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-15/", "name": "dt", "value": "2024-03-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:43", "last_data": "2024-05-14 08:25:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254067, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-16/", "name": "dt", "value": "2024-03-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:40", "last_data": "2024-05-14 08:25:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254044, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-17/", "name": "dt", "value": "2024-03-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:37", "last_data": "2024-05-14 08:25:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254026, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-18/", "name": "dt", "value": "2024-03-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:34", "last_data": "2024-05-14 08:25:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254055, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-19/", "name": "dt", "value": "2024-03-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:38", "last_data": "2024-05-14 08:25:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254078, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-20/", "name": "dt", "value": "2024-03-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:42", "last_data": "2024-05-14 08:25:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254049, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-21/", "name": "dt", "value": "2024-03-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:38", "last_data": "2024-05-14 08:25:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254074, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-22/", "name": "dt", "value": "2024-03-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:41", "last_data": "2024-05-14 08:25:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254052, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-23/", "name": "dt", "value": "2024-03-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:38", "last_data": "2024-05-14 08:25:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254034, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-24/", "name": "dt", "value": "2024-03-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:35", "last_data": "2024-05-14 08:25:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254041, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-25/", "name": "dt", "value": "2024-03-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:37", "last_data": "2024-05-14 08:25:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254060, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-26/", "name": "dt", "value": "2024-03-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:39", "last_data": "2024-05-14 08:25:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254039, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-27/", "name": "dt", "value": "2024-03-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:36", "last_data": "2024-05-14 08:25:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254035, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-28/", "name": "dt", "value": "2024-03-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:35", "last_data": "2024-05-14 08:25:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254080, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-29/", "name": "dt", "value": "2024-03-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:42", "last_data": "2024-05-14 08:25:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254082, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-30/", "name": "dt", "value": "2024-03-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:42", "last_data": "2024-05-14 08:25:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254077, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-31/", "name": "dt", "value": "2024-03-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:42", "last_data": "2024-05-14 08:25:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254092, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-01/", "name": "dt", "value": "2024-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:44", "last_data": "2024-05-14 08:25:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254087, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-02/", "name": "dt", "value": "2024-04-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:43", "last_data": "2024-05-14 08:25:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254081, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-03/", "name": "dt", "value": "2024-04-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:42", "last_data": "2024-05-14 08:25:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254047, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-04/", "name": "dt", "value": "2024-04-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:37", "last_data": "2024-05-14 08:25:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254036, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-05/", "name": "dt", "value": "2024-04-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:36", "last_data": "2024-05-14 08:25:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254032, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-06/", "name": "dt", "value": "2024-04-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:35", "last_data": "2024-05-14 08:25:35" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254065, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-07/", "name": "dt", "value": "2024-04-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:40", "last_data": "2024-05-14 08:25:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254066, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-08/", "name": "dt", "value": "2024-04-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:40", "last_data": "2024-05-14 08:25:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254063, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-09/", "name": "dt", "value": "2024-04-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:39", "last_data": "2024-05-14 08:25:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254072, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-10/", "name": "dt", "value": "2024-04-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:41", "last_data": "2024-05-14 08:25:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254089, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-11/", "name": "dt", "value": "2024-04-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:43", "last_data": "2024-05-14 08:25:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254095, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-12/", "name": "dt", "value": "2024-04-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:44", "last_data": "2024-05-14 08:25:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254053, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-13/", "name": "dt", "value": "2024-04-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:38", "last_data": "2024-05-14 08:25:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254075, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-14/", "name": "dt", "value": "2024-04-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:41", "last_data": "2024-05-14 08:25:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254070, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-15/", "name": "dt", "value": "2024-04-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:41", "last_data": "2024-05-14 08:25:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254079, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-16/", "name": "dt", "value": "2024-04-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:42", "last_data": "2024-05-14 08:25:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254073, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-17/", "name": "dt", "value": "2024-04-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:41", "last_data": "2024-05-14 08:25:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254056, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-18/", "name": "dt", "value": "2024-04-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:38", "last_data": "2024-05-14 08:25:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254050, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-19/", "name": "dt", "value": "2024-04-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:38", "last_data": "2024-05-14 08:25:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254086, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-20/", "name": "dt", "value": "2024-04-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:43", "last_data": "2024-05-14 08:25:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254096, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-21/", "name": "dt", "value": "2024-04-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:44", "last_data": "2024-05-14 08:25:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254040, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-22/", "name": "dt", "value": "2024-04-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:36", "last_data": "2024-05-14 08:25:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254028, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-23/", "name": "dt", "value": "2024-04-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:34", "last_data": "2024-05-14 08:25:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254076, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-24/", "name": "dt", "value": "2024-04-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:42", "last_data": "2024-05-14 08:25:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254062, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-25/", "name": "dt", "value": "2024-04-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:39", "last_data": "2024-05-14 08:25:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254061, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-26/", "name": "dt", "value": "2024-04-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:39", "last_data": "2024-05-14 08:25:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254088, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-27/", "name": "dt", "value": "2024-04-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:43", "last_data": "2024-05-14 08:25:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254051, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-28/", "name": "dt", "value": "2024-04-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:38", "last_data": "2024-05-14 08:25:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254048, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-29/", "name": "dt", "value": "2024-04-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:37", "last_data": "2024-05-14 08:25:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254058, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-30/", "name": "dt", "value": "2024-04-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:39", "last_data": "2024-05-14 08:25:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254037, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-01/", "name": "dt", "value": "2024-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:36", "last_data": "2024-05-14 08:25:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254083, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-02/", "name": "dt", "value": "2024-05-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:43", "last_data": "2024-05-14 08:25:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254090, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-03/", "name": "dt", "value": "2024-05-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:43", "last_data": "2024-05-14 08:25:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254069, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-04/", "name": "dt", "value": "2024-05-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:40", "last_data": "2024-05-14 08:25:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254097, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-05/", "name": "dt", "value": "2024-05-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:44", "last_data": "2024-05-14 08:25:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254099, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-06/", "name": "dt", "value": "2024-05-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:44", "last_data": "2024-05-14 08:25:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254054, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-07/", "name": "dt", "value": "2024-05-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:38", "last_data": "2024-05-14 08:25:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254045, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-08/", "name": "dt", "value": "2024-05-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:37", "last_data": "2024-05-14 08:25:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254059, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-09/", "name": "dt", "value": "2024-05-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:39", "last_data": "2024-05-14 08:25:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254098, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-10/", "name": "dt", "value": "2024-05-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:44", "last_data": "2024-05-14 08:25:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254046, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-11/", "name": "dt", "value": "2024-05-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:37", "last_data": "2024-05-14 08:25:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254043, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-12/", "name": "dt", "value": "2024-05-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:37", "last_data": "2024-05-14 08:25:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254038, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-13/", "name": "dt", "value": "2024-05-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:36", "last_data": "2024-05-14 08:25:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 254025, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-14/", "name": "dt", "value": "2024-05-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-05-14 08:25:12", "last_data": "2024-05-14 08:25:12" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259913, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-15/", "name": "dt", "value": "2024-05-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:44", "last_data": "2024-08-14 14:32:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259979, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-16/", "name": "dt", "value": "2024-05-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:52", "last_data": "2024-08-14 14:32:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259922, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-17/", "name": "dt", "value": "2024-05-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:45", "last_data": "2024-08-14 14:32:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259988, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-18/", "name": "dt", "value": "2024-05-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:53", "last_data": "2024-08-14 14:32:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259928, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-19/", "name": "dt", "value": "2024-05-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259958, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-20/", "name": "dt", "value": "2024-05-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259959, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-21/", "name": "dt", "value": "2024-05-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259943, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-22/", "name": "dt", "value": "2024-05-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:47", "last_data": "2024-08-14 14:32:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259909, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-23/", "name": "dt", "value": "2024-05-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:43", "last_data": "2024-08-14 14:32:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259924, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-24/", "name": "dt", "value": "2024-05-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:45", "last_data": "2024-08-14 14:32:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259934, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-25/", "name": "dt", "value": "2024-05-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259926, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-26/", "name": "dt", "value": "2024-05-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:45", "last_data": "2024-08-14 14:32:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259927, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-27/", "name": "dt", "value": "2024-05-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:45", "last_data": "2024-08-14 14:32:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259989, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-28/", "name": "dt", "value": "2024-05-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:53", "last_data": "2024-08-14 14:32:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259929, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-29/", "name": "dt", "value": "2024-05-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259947, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-30/", "name": "dt", "value": "2024-05-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:48", "last_data": "2024-08-14 14:32:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259992, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-31/", "name": "dt", "value": "2024-05-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:54", "last_data": "2024-08-14 14:32:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259952, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-01/", "name": "dt", "value": "2024-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259937, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-02/", "name": "dt", "value": "2024-06-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259948, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-03/", "name": "dt", "value": "2024-06-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:48", "last_data": "2024-08-14 14:32:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259904, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-04/", "name": "dt", "value": "2024-06-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:42", "last_data": "2024-08-14 14:32:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259940, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-05/", "name": "dt", "value": "2024-06-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:47", "last_data": "2024-08-14 14:32:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259994, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-06/", "name": "dt", "value": "2024-06-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:54", "last_data": "2024-08-14 14:32:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259942, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-07/", "name": "dt", "value": "2024-06-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:47", "last_data": "2024-08-14 14:32:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259930, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-08/", "name": "dt", "value": "2024-06-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259911, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-09/", "name": "dt", "value": "2024-06-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:43", "last_data": "2024-08-14 14:32:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259914, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-10/", "name": "dt", "value": "2024-06-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:44", "last_data": "2024-08-14 14:32:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259923, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-11/", "name": "dt", "value": "2024-06-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:45", "last_data": "2024-08-14 14:32:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259918, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-12/", "name": "dt", "value": "2024-06-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:44", "last_data": "2024-08-14 14:32:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259910, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-13/", "name": "dt", "value": "2024-06-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:43", "last_data": "2024-08-14 14:32:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259944, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-14/", "name": "dt", "value": "2024-06-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:47", "last_data": "2024-08-14 14:32:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259935, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-15/", "name": "dt", "value": "2024-06-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259973, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-16/", "name": "dt", "value": "2024-06-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259974, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-17/", "name": "dt", "value": "2024-06-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259949, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-18/", "name": "dt", "value": "2024-06-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:48", "last_data": "2024-08-14 14:32:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259985, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-19/", "name": "dt", "value": "2024-06-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:53", "last_data": "2024-08-14 14:32:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259907, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-20/", "name": "dt", "value": "2024-06-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:43", "last_data": "2024-08-14 14:32:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259953, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-21/", "name": "dt", "value": "2024-06-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259984, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-22/", "name": "dt", "value": "2024-06-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:53", "last_data": "2024-08-14 14:32:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259970, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-23/", "name": "dt", "value": "2024-06-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259916, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-24/", "name": "dt", "value": "2024-06-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:44", "last_data": "2024-08-14 14:32:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259964, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-25/", "name": "dt", "value": "2024-06-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:50", "last_data": "2024-08-14 14:32:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259954, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-26/", "name": "dt", "value": "2024-06-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259931, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-27/", "name": "dt", "value": "2024-06-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259905, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-28/", "name": "dt", "value": "2024-06-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:42", "last_data": "2024-08-14 14:32:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259987, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-29/", "name": "dt", "value": "2024-06-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:53", "last_data": "2024-08-14 14:32:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259936, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-30/", "name": "dt", "value": "2024-06-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259978, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-01/", "name": "dt", "value": "2024-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:52", "last_data": "2024-08-14 14:32:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259967, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-02/", "name": "dt", "value": "2024-07-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:50", "last_data": "2024-08-14 14:32:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259908, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-03/", "name": "dt", "value": "2024-07-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:43", "last_data": "2024-08-14 14:32:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259939, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-04/", "name": "dt", "value": "2024-07-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:47", "last_data": "2024-08-14 14:32:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259961, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-05/", "name": "dt", "value": "2024-07-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:50", "last_data": "2024-08-14 14:32:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259990, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-06/", "name": "dt", "value": "2024-07-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:54", "last_data": "2024-08-14 14:32:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259938, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-07/", "name": "dt", "value": "2024-07-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259993, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-08/", "name": "dt", "value": "2024-07-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:54", "last_data": "2024-08-14 14:32:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259981, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-09/", "name": "dt", "value": "2024-07-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:52", "last_data": "2024-08-14 14:32:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259991, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-10/", "name": "dt", "value": "2024-07-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:54", "last_data": "2024-08-14 14:32:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259965, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-11/", "name": "dt", "value": "2024-07-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:50", "last_data": "2024-08-14 14:32:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259951, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-12/", "name": "dt", "value": "2024-07-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:48", "last_data": "2024-08-14 14:32:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259917, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-13/", "name": "dt", "value": "2024-07-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:44", "last_data": "2024-08-14 14:32:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259960, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-14/", "name": "dt", "value": "2024-07-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259921, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-15/", "name": "dt", "value": "2024-07-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:45", "last_data": "2024-08-14 14:32:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259962, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-16/", "name": "dt", "value": "2024-07-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:50", "last_data": "2024-08-14 14:32:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259968, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-17/", "name": "dt", "value": "2024-07-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259955, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-18/", "name": "dt", "value": "2024-07-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259920, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-19/", "name": "dt", "value": "2024-07-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:44", "last_data": "2024-08-14 14:32:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259906, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-20/", "name": "dt", "value": "2024-07-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:42", "last_data": "2024-08-14 14:32:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259977, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-21/", "name": "dt", "value": "2024-07-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259945, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-22/", "name": "dt", "value": "2024-07-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:48", "last_data": "2024-08-14 14:32:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259976, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-23/", "name": "dt", "value": "2024-07-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259956, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-24/", "name": "dt", "value": "2024-07-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259971, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-25/", "name": "dt", "value": "2024-07-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259912, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-26/", "name": "dt", "value": "2024-07-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:43", "last_data": "2024-08-14 14:32:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259966, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-27/", "name": "dt", "value": "2024-07-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:50", "last_data": "2024-08-14 14:32:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259957, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-28/", "name": "dt", "value": "2024-07-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:49", "last_data": "2024-08-14 14:32:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259946, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-29/", "name": "dt", "value": "2024-07-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:48", "last_data": "2024-08-14 14:32:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259975, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-30/", "name": "dt", "value": "2024-07-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259980, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-31/", "name": "dt", "value": "2024-07-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:52", "last_data": "2024-08-14 14:32:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259986, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-01/", "name": "dt", "value": "2024-08-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:53", "last_data": "2024-08-14 14:32:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259941, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-02/", "name": "dt", "value": "2024-08-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:47", "last_data": "2024-08-14 14:32:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259932, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-03/", "name": "dt", "value": "2024-08-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259972, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-04/", "name": "dt", "value": "2024-08-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259915, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-05/", "name": "dt", "value": "2024-08-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:44", "last_data": "2024-08-14 14:32:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259919, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-06/", "name": "dt", "value": "2024-08-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:44", "last_data": "2024-08-14 14:32:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259925, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-07/", "name": "dt", "value": "2024-08-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:45", "last_data": "2024-08-14 14:32:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259983, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-08/", "name": "dt", "value": "2024-08-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:53", "last_data": "2024-08-14 14:32:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259982, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-09/", "name": "dt", "value": "2024-08-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:52", "last_data": "2024-08-14 14:32:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259963, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-10/", "name": "dt", "value": "2024-08-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:50", "last_data": "2024-08-14 14:32:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259933, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-11/", "name": "dt", "value": "2024-08-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:46", "last_data": "2024-08-14 14:32:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259969, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-12/", "name": "dt", "value": "2024-08-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:51", "last_data": "2024-08-14 14:32:51" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259950, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-13/", "name": "dt", "value": "2024-08-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:48", "last_data": "2024-08-14 14:32:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 259902, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-14/", "name": "dt", "value": "2024-08-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-14 14:32:18", "last_data": "2024-08-14 14:32:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "account_customer_segment": "varchar(30)", "account_lifetime_customer_segment": "varchar(30)", "account_manager": "varchar(24)", "account_manager_key": "int", "account_pricing_model": "varchar(10)", "annotations": "varchar(2048)", "audit_id": "bigint", "average_sort_position": "decimal(16,2)", "bid_flat": "decimal", "bid_percent": "decimal(6,2)", "city": "varchar(200)", "clicks": "int", "client_key": "int", "client_name": "varchar(200)", "county": "varchar(32)", "day": "date", "day_key": "int", "facility_date_live": "date", "facility_is_directory": "int", "facility_key": "int", "facility_name": "varchar(200)", "facility_status": "varchar(40)", "hold_day": "date", "impressions": "int", "integration": "varchar(100)", "integration_key": "int", "location_key": "int", "move_in_day": "date", "msa": "varchar(150)", "negative_bid_change_amount": "int", "negative_bid_changes": "int", "npv": "decimal(18,2)", "positive_bid_change_amount": "int", "positive_bid_changes": "int", "reservation_auto_state": "varchar(20)", "reservation_pricing_model": "varchar(12)", "reservation_state": "varchar(20)", "reservation_touchpoint": "varchar(19)", "reservation_type": "varchar(12)", "reservations": "int", "searches": "int", "site": "varchar(255)", "site_key": "int", "sparefoot_charge": "decimal(18,2)", "state": "varchar(2)", "statement_batch_close_day": "date", "statement_batch_key": "int", "statement_batch_move_in_start_day": "date", "sum_rank": "bigint", "zip": "varchar(6)" } - created: 2024-08-14 14:32:18
- 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_facility_performance`\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 , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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_facility_performance/2024-08-14/1723663430'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_facility_performance`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_facility_performance" }
- 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:10:15",
"disabled": false,
"format": "raw",
"id": 691,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_redshift",
"table": "analytics_mart_facility_performance"
},
"type": "redshift"
},
"partition": {
"count": 167,
"ddl": [
"ALTER TABLE\n `sfdl_dev_redshift.analytics_mart_facility_performance`\nADD\n\n\n PARTITION (dt='2024-03-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-03-01/1709291662/dt=2024-03-01/'\n PARTITION (dt='2024-03-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-02/'\n PARTITION (dt='2024-03-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-03/'\n PARTITION (dt='2024-03-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-04/'\n PARTITION (dt='2024-03-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-05/'\n PARTITION (dt='2024-03-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-06/'\n PARTITION (dt='2024-03-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-07/'\n PARTITION (dt='2024-03-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-08/'\n PARTITION (dt='2024-03-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-09/'\n PARTITION (dt='2024-03-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-10/'\n PARTITION (dt='2024-03-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-11/'\n PARTITION (dt='2024-03-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-12/'\n PARTITION (dt='2024-03-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-13/'\n PARTITION (dt='2024-03-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-14/'\n PARTITION (dt='2024-03-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-15/'\n PARTITION (dt='2024-03-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-16/'\n PARTITION (dt='2024-03-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-17/'\n PARTITION (dt='2024-03-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-18/'\n PARTITION (dt='2024-03-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-19/'\n PARTITION (dt='2024-03-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-20/'\n PARTITION (dt='2024-03-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-21/'\n PARTITION (dt='2024-03-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-22/'\n PARTITION (dt='2024-03-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-23/'\n PARTITION (dt='2024-03-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-24/'\n PARTITION (dt='2024-03-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-25/'\n PARTITION (dt='2024-03-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-26/'\n PARTITION (dt='2024-03-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-27/'\n PARTITION (dt='2024-03-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-28/'\n PARTITION (dt='2024-03-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-29/'\n PARTITION (dt='2024-03-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-30/'\n PARTITION (dt='2024-03-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-31/'\n PARTITION (dt='2024-04-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-01/'\n PARTITION (dt='2024-04-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-02/'\n PARTITION (dt='2024-04-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-03/'\n PARTITION (dt='2024-04-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-04/'\n PARTITION (dt='2024-04-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-05/'\n PARTITION (dt='2024-04-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-06/'\n PARTITION (dt='2024-04-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-07/'\n PARTITION (dt='2024-04-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-08/'\n PARTITION (dt='2024-04-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-09/'\n PARTITION (dt='2024-04-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-10/'\n PARTITION (dt='2024-04-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-11/'\n PARTITION (dt='2024-04-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-12/'\n PARTITION (dt='2024-04-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-13/'\n PARTITION (dt='2024-04-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-14/'\n PARTITION (dt='2024-04-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-15/'\n PARTITION (dt='2024-04-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-16/'\n PARTITION (dt='2024-04-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-17/'\n PARTITION (dt='2024-04-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-18/'\n PARTITION (dt='2024-04-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-19/'\n PARTITION (dt='2024-04-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-20/'\n PARTITION (dt='2024-04-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-21/'\n PARTITION (dt='2024-04-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-22/'\n PARTITION (dt='2024-04-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-23/'\n PARTITION (dt='2024-04-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-24/'\n PARTITION (dt='2024-04-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-25/'\n PARTITION (dt='2024-04-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-26/'\n PARTITION (dt='2024-04-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-27/'\n PARTITION (dt='2024-04-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-28/'\n PARTITION (dt='2024-04-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-29/'\n PARTITION (dt='2024-04-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-30/'\n PARTITION (dt='2024-05-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-01/'\n PARTITION (dt='2024-05-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-02/'\n PARTITION (dt='2024-05-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-03/'\n PARTITION (dt='2024-05-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-04/'\n PARTITION (dt='2024-05-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-05/'\n PARTITION (dt='2024-05-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-06/'\n PARTITION (dt='2024-05-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-07/'\n PARTITION (dt='2024-05-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-08/'\n PARTITION (dt='2024-05-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-09/'\n PARTITION (dt='2024-05-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-10/'\n PARTITION (dt='2024-05-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-11/'\n PARTITION (dt='2024-05-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-12/'\n PARTITION (dt='2024-05-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-13/'\n PARTITION (dt='2024-05-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-14/'\n PARTITION (dt='2024-05-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-15/'\n PARTITION (dt='2024-05-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-16/'\n PARTITION (dt='2024-05-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-17/'\n PARTITION (dt='2024-05-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-18/'\n PARTITION (dt='2024-05-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-19/'\n PARTITION (dt='2024-05-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-20/'\n PARTITION (dt='2024-05-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-21/'\n PARTITION (dt='2024-05-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-22/'\n PARTITION (dt='2024-05-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-23/'\n PARTITION (dt='2024-05-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-24/'\n PARTITION (dt='2024-05-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-25/'\n PARTITION (dt='2024-05-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-26/'\n PARTITION (dt='2024-05-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-27/'\n PARTITION (dt='2024-05-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-28/'\n PARTITION (dt='2024-05-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-29/'\n PARTITION (dt='2024-05-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-30/'\n PARTITION (dt='2024-05-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-31/'\n PARTITION (dt='2024-06-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-01/'\n PARTITION (dt='2024-06-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-02/'\n PARTITION (dt='2024-06-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-03/'\n PARTITION (dt='2024-06-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-04/'\n PARTITION (dt='2024-06-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-05/'\n PARTITION (dt='2024-06-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-06/'\n PARTITION (dt='2024-06-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-07/'\n PARTITION (dt='2024-06-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-08/'\n PARTITION (dt='2024-06-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-09/'\n PARTITION (dt='2024-06-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-10/'\n PARTITION (dt='2024-06-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-11/'\n PARTITION (dt='2024-06-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-12/'\n PARTITION (dt='2024-06-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-13/'\n PARTITION (dt='2024-06-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-14/'\n PARTITION (dt='2024-06-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-15/'\n PARTITION (dt='2024-06-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-16/'\n PARTITION (dt='2024-06-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-17/'\n PARTITION (dt='2024-06-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-18/'\n PARTITION (dt='2024-06-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-19/'\n PARTITION (dt='2024-06-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-20/'\n PARTITION (dt='2024-06-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-21/'\n PARTITION (dt='2024-06-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-22/'\n PARTITION (dt='2024-06-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-23/'\n PARTITION (dt='2024-06-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-24/'\n PARTITION (dt='2024-06-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-25/'\n PARTITION (dt='2024-06-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-26/'\n PARTITION (dt='2024-06-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-27/'\n PARTITION (dt='2024-06-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-28/'\n PARTITION (dt='2024-06-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-29/'\n PARTITION (dt='2024-06-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-30/'\n PARTITION (dt='2024-07-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-01/'\n PARTITION (dt='2024-07-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-02/'\n PARTITION (dt='2024-07-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-03/'\n PARTITION (dt='2024-07-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-04/'\n PARTITION (dt='2024-07-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-05/'\n PARTITION (dt='2024-07-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-06/'\n PARTITION (dt='2024-07-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-07/'\n PARTITION (dt='2024-07-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-08/'\n PARTITION (dt='2024-07-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-09/'\n PARTITION (dt='2024-07-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-10/'\n PARTITION (dt='2024-07-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-11/'\n PARTITION (dt='2024-07-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-12/'\n PARTITION (dt='2024-07-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-13/'\n PARTITION (dt='2024-07-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-14/'\n PARTITION (dt='2024-07-15') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-15/'\n PARTITION (dt='2024-07-16') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-16/'\n PARTITION (dt='2024-07-17') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-17/'\n PARTITION (dt='2024-07-18') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-18/'\n PARTITION (dt='2024-07-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-19/'\n PARTITION (dt='2024-07-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-20/'\n PARTITION (dt='2024-07-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-21/'\n PARTITION (dt='2024-07-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-22/'\n PARTITION (dt='2024-07-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-23/'\n PARTITION (dt='2024-07-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-24/'\n PARTITION (dt='2024-07-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-25/'\n PARTITION (dt='2024-07-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-26/'\n PARTITION (dt='2024-07-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-27/'\n PARTITION (dt='2024-07-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-28/'\n PARTITION (dt='2024-07-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-29/'\n PARTITION (dt='2024-07-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-30/'\n PARTITION (dt='2024-07-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-31/'\n PARTITION (dt='2024-08-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-01/'\n PARTITION (dt='2024-08-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-02/'\n PARTITION (dt='2024-08-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-03/'\n PARTITION (dt='2024-08-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-04/'\n PARTITION (dt='2024-08-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-05/'\n PARTITION (dt='2024-08-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-06/'\n PARTITION (dt='2024-08-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-07/'\n PARTITION (dt='2024-08-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-08/'\n PARTITION (dt='2024-08-09') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-09/'\n PARTITION (dt='2024-08-10') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-10/'\n PARTITION (dt='2024-08-11') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-11/'\n PARTITION (dt='2024-08-12') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-12/'\n PARTITION (dt='2024-08-13') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-13/'\n PARTITION (dt='2024-08-14') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-14/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 249681,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-03-01/1709291662/dt=2024-03-01/",
"name": "dt",
"value": "2024-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-03-01 05:26:56",
"last_data": "2024-03-01 05:26:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254071,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-02/",
"name": "dt",
"value": "2024-03-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:41",
"last_data": "2024-05-14 08:25:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254042,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-03/",
"name": "dt",
"value": "2024-03-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:37",
"last_data": "2024-05-14 08:25:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254057,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-04/",
"name": "dt",
"value": "2024-03-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:39",
"last_data": "2024-05-14 08:25:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254093,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-05/",
"name": "dt",
"value": "2024-03-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:44",
"last_data": "2024-05-14 08:25:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254068,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-06/",
"name": "dt",
"value": "2024-03-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:40",
"last_data": "2024-05-14 08:25:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254084,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-07/",
"name": "dt",
"value": "2024-03-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:43",
"last_data": "2024-05-14 08:25:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254064,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-08/",
"name": "dt",
"value": "2024-03-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:40",
"last_data": "2024-05-14 08:25:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254031,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-09/",
"name": "dt",
"value": "2024-03-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:35",
"last_data": "2024-05-14 08:25:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254029,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-10/",
"name": "dt",
"value": "2024-03-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:34",
"last_data": "2024-05-14 08:25:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254094,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-11/",
"name": "dt",
"value": "2024-03-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:44",
"last_data": "2024-05-14 08:25:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254027,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-12/",
"name": "dt",
"value": "2024-03-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:34",
"last_data": "2024-05-14 08:25:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254030,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-13/",
"name": "dt",
"value": "2024-03-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:35",
"last_data": "2024-05-14 08:25:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254033,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-14/",
"name": "dt",
"value": "2024-03-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:35",
"last_data": "2024-05-14 08:25:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254091,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-15/",
"name": "dt",
"value": "2024-03-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:43",
"last_data": "2024-05-14 08:25:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254067,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-16/",
"name": "dt",
"value": "2024-03-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:40",
"last_data": "2024-05-14 08:25:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254044,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-17/",
"name": "dt",
"value": "2024-03-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:37",
"last_data": "2024-05-14 08:25:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254026,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-18/",
"name": "dt",
"value": "2024-03-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:34",
"last_data": "2024-05-14 08:25:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254055,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-19/",
"name": "dt",
"value": "2024-03-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:38",
"last_data": "2024-05-14 08:25:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254078,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-20/",
"name": "dt",
"value": "2024-03-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:42",
"last_data": "2024-05-14 08:25:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254049,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-21/",
"name": "dt",
"value": "2024-03-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:38",
"last_data": "2024-05-14 08:25:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254074,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-22/",
"name": "dt",
"value": "2024-03-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:41",
"last_data": "2024-05-14 08:25:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254052,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-23/",
"name": "dt",
"value": "2024-03-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:38",
"last_data": "2024-05-14 08:25:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254034,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-24/",
"name": "dt",
"value": "2024-03-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:35",
"last_data": "2024-05-14 08:25:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254041,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-25/",
"name": "dt",
"value": "2024-03-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:37",
"last_data": "2024-05-14 08:25:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254060,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-26/",
"name": "dt",
"value": "2024-03-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:39",
"last_data": "2024-05-14 08:25:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254039,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-27/",
"name": "dt",
"value": "2024-03-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:36",
"last_data": "2024-05-14 08:25:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254035,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-28/",
"name": "dt",
"value": "2024-03-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:35",
"last_data": "2024-05-14 08:25:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254080,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-29/",
"name": "dt",
"value": "2024-03-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:42",
"last_data": "2024-05-14 08:25:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254082,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-30/",
"name": "dt",
"value": "2024-03-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:42",
"last_data": "2024-05-14 08:25:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254077,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-03-31/",
"name": "dt",
"value": "2024-03-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:42",
"last_data": "2024-05-14 08:25:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254092,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-01/",
"name": "dt",
"value": "2024-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:44",
"last_data": "2024-05-14 08:25:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254087,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-02/",
"name": "dt",
"value": "2024-04-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:43",
"last_data": "2024-05-14 08:25:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254081,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-03/",
"name": "dt",
"value": "2024-04-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:42",
"last_data": "2024-05-14 08:25:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254047,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-04/",
"name": "dt",
"value": "2024-04-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:37",
"last_data": "2024-05-14 08:25:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254036,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-05/",
"name": "dt",
"value": "2024-04-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:36",
"last_data": "2024-05-14 08:25:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254032,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-06/",
"name": "dt",
"value": "2024-04-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:35",
"last_data": "2024-05-14 08:25:35"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254065,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-07/",
"name": "dt",
"value": "2024-04-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:40",
"last_data": "2024-05-14 08:25:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254066,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-08/",
"name": "dt",
"value": "2024-04-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:40",
"last_data": "2024-05-14 08:25:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254063,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-09/",
"name": "dt",
"value": "2024-04-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:39",
"last_data": "2024-05-14 08:25:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254072,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-10/",
"name": "dt",
"value": "2024-04-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:41",
"last_data": "2024-05-14 08:25:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254089,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-11/",
"name": "dt",
"value": "2024-04-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:43",
"last_data": "2024-05-14 08:25:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254095,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-12/",
"name": "dt",
"value": "2024-04-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:44",
"last_data": "2024-05-14 08:25:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254053,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-13/",
"name": "dt",
"value": "2024-04-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:38",
"last_data": "2024-05-14 08:25:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254075,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-14/",
"name": "dt",
"value": "2024-04-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:41",
"last_data": "2024-05-14 08:25:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254070,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-15/",
"name": "dt",
"value": "2024-04-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:41",
"last_data": "2024-05-14 08:25:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254079,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-16/",
"name": "dt",
"value": "2024-04-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:42",
"last_data": "2024-05-14 08:25:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254073,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-17/",
"name": "dt",
"value": "2024-04-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:41",
"last_data": "2024-05-14 08:25:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254056,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-18/",
"name": "dt",
"value": "2024-04-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:38",
"last_data": "2024-05-14 08:25:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254050,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-19/",
"name": "dt",
"value": "2024-04-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:38",
"last_data": "2024-05-14 08:25:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254086,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-20/",
"name": "dt",
"value": "2024-04-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:43",
"last_data": "2024-05-14 08:25:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254096,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-21/",
"name": "dt",
"value": "2024-04-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:44",
"last_data": "2024-05-14 08:25:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254040,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-22/",
"name": "dt",
"value": "2024-04-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:36",
"last_data": "2024-05-14 08:25:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254028,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-23/",
"name": "dt",
"value": "2024-04-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:34",
"last_data": "2024-05-14 08:25:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254076,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-24/",
"name": "dt",
"value": "2024-04-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:42",
"last_data": "2024-05-14 08:25:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254062,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-25/",
"name": "dt",
"value": "2024-04-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:39",
"last_data": "2024-05-14 08:25:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254061,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-26/",
"name": "dt",
"value": "2024-04-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:39",
"last_data": "2024-05-14 08:25:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254088,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-27/",
"name": "dt",
"value": "2024-04-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:43",
"last_data": "2024-05-14 08:25:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254051,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-28/",
"name": "dt",
"value": "2024-04-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:38",
"last_data": "2024-05-14 08:25:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254048,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-29/",
"name": "dt",
"value": "2024-04-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:37",
"last_data": "2024-05-14 08:25:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254058,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-04-30/",
"name": "dt",
"value": "2024-04-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:39",
"last_data": "2024-05-14 08:25:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254037,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-01/",
"name": "dt",
"value": "2024-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:36",
"last_data": "2024-05-14 08:25:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254083,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-02/",
"name": "dt",
"value": "2024-05-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:43",
"last_data": "2024-05-14 08:25:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254090,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-03/",
"name": "dt",
"value": "2024-05-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:43",
"last_data": "2024-05-14 08:25:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254069,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-04/",
"name": "dt",
"value": "2024-05-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:40",
"last_data": "2024-05-14 08:25:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254097,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-05/",
"name": "dt",
"value": "2024-05-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:44",
"last_data": "2024-05-14 08:25:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254099,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-06/",
"name": "dt",
"value": "2024-05-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:44",
"last_data": "2024-05-14 08:25:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254054,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-07/",
"name": "dt",
"value": "2024-05-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:38",
"last_data": "2024-05-14 08:25:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254045,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-08/",
"name": "dt",
"value": "2024-05-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:37",
"last_data": "2024-05-14 08:25:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254059,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-09/",
"name": "dt",
"value": "2024-05-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:39",
"last_data": "2024-05-14 08:25:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254098,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-10/",
"name": "dt",
"value": "2024-05-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:44",
"last_data": "2024-05-14 08:25:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254046,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-11/",
"name": "dt",
"value": "2024-05-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:37",
"last_data": "2024-05-14 08:25:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254043,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-12/",
"name": "dt",
"value": "2024-05-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:37",
"last_data": "2024-05-14 08:25:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254038,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-13/",
"name": "dt",
"value": "2024-05-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:36",
"last_data": "2024-05-14 08:25:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 254025,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-05-14/1715692442/dt=2024-05-14/",
"name": "dt",
"value": "2024-05-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-05-14 08:25:12",
"last_data": "2024-05-14 08:25:12"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259913,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-15/",
"name": "dt",
"value": "2024-05-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:44",
"last_data": "2024-08-14 14:32:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259979,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-16/",
"name": "dt",
"value": "2024-05-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:52",
"last_data": "2024-08-14 14:32:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259922,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-17/",
"name": "dt",
"value": "2024-05-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:45",
"last_data": "2024-08-14 14:32:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259988,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-18/",
"name": "dt",
"value": "2024-05-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:53",
"last_data": "2024-08-14 14:32:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259928,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-19/",
"name": "dt",
"value": "2024-05-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259958,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-20/",
"name": "dt",
"value": "2024-05-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259959,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-21/",
"name": "dt",
"value": "2024-05-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259943,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-22/",
"name": "dt",
"value": "2024-05-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:47",
"last_data": "2024-08-14 14:32:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259909,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-23/",
"name": "dt",
"value": "2024-05-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:43",
"last_data": "2024-08-14 14:32:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259924,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-24/",
"name": "dt",
"value": "2024-05-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:45",
"last_data": "2024-08-14 14:32:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259934,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-25/",
"name": "dt",
"value": "2024-05-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259926,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-26/",
"name": "dt",
"value": "2024-05-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:45",
"last_data": "2024-08-14 14:32:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259927,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-27/",
"name": "dt",
"value": "2024-05-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:45",
"last_data": "2024-08-14 14:32:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259989,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-28/",
"name": "dt",
"value": "2024-05-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:53",
"last_data": "2024-08-14 14:32:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259929,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-29/",
"name": "dt",
"value": "2024-05-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259947,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-30/",
"name": "dt",
"value": "2024-05-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:48",
"last_data": "2024-08-14 14:32:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259992,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-05-31/",
"name": "dt",
"value": "2024-05-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:54",
"last_data": "2024-08-14 14:32:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259952,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-01/",
"name": "dt",
"value": "2024-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259937,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-02/",
"name": "dt",
"value": "2024-06-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259948,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-03/",
"name": "dt",
"value": "2024-06-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:48",
"last_data": "2024-08-14 14:32:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259904,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-04/",
"name": "dt",
"value": "2024-06-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:42",
"last_data": "2024-08-14 14:32:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259940,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-05/",
"name": "dt",
"value": "2024-06-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:47",
"last_data": "2024-08-14 14:32:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259994,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-06/",
"name": "dt",
"value": "2024-06-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:54",
"last_data": "2024-08-14 14:32:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259942,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-07/",
"name": "dt",
"value": "2024-06-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:47",
"last_data": "2024-08-14 14:32:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259930,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-08/",
"name": "dt",
"value": "2024-06-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259911,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-09/",
"name": "dt",
"value": "2024-06-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:43",
"last_data": "2024-08-14 14:32:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259914,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-10/",
"name": "dt",
"value": "2024-06-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:44",
"last_data": "2024-08-14 14:32:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259923,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-11/",
"name": "dt",
"value": "2024-06-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:45",
"last_data": "2024-08-14 14:32:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259918,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-12/",
"name": "dt",
"value": "2024-06-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:44",
"last_data": "2024-08-14 14:32:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259910,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-13/",
"name": "dt",
"value": "2024-06-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:43",
"last_data": "2024-08-14 14:32:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259944,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-14/",
"name": "dt",
"value": "2024-06-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:47",
"last_data": "2024-08-14 14:32:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259935,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-15/",
"name": "dt",
"value": "2024-06-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259973,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-16/",
"name": "dt",
"value": "2024-06-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259974,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-17/",
"name": "dt",
"value": "2024-06-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259949,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-18/",
"name": "dt",
"value": "2024-06-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:48",
"last_data": "2024-08-14 14:32:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259985,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-19/",
"name": "dt",
"value": "2024-06-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:53",
"last_data": "2024-08-14 14:32:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259907,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-20/",
"name": "dt",
"value": "2024-06-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:43",
"last_data": "2024-08-14 14:32:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259953,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-21/",
"name": "dt",
"value": "2024-06-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259984,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-22/",
"name": "dt",
"value": "2024-06-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:53",
"last_data": "2024-08-14 14:32:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259970,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-23/",
"name": "dt",
"value": "2024-06-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259916,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-24/",
"name": "dt",
"value": "2024-06-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:44",
"last_data": "2024-08-14 14:32:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259964,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-25/",
"name": "dt",
"value": "2024-06-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:50",
"last_data": "2024-08-14 14:32:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259954,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-26/",
"name": "dt",
"value": "2024-06-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259931,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-27/",
"name": "dt",
"value": "2024-06-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259905,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-28/",
"name": "dt",
"value": "2024-06-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:42",
"last_data": "2024-08-14 14:32:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259987,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-29/",
"name": "dt",
"value": "2024-06-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:53",
"last_data": "2024-08-14 14:32:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259936,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-06-30/",
"name": "dt",
"value": "2024-06-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259978,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-01/",
"name": "dt",
"value": "2024-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:52",
"last_data": "2024-08-14 14:32:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259967,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-02/",
"name": "dt",
"value": "2024-07-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:50",
"last_data": "2024-08-14 14:32:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259908,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-03/",
"name": "dt",
"value": "2024-07-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:43",
"last_data": "2024-08-14 14:32:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259939,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-04/",
"name": "dt",
"value": "2024-07-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:47",
"last_data": "2024-08-14 14:32:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259961,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-05/",
"name": "dt",
"value": "2024-07-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:50",
"last_data": "2024-08-14 14:32:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259990,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-06/",
"name": "dt",
"value": "2024-07-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:54",
"last_data": "2024-08-14 14:32:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259938,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-07/",
"name": "dt",
"value": "2024-07-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259993,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-08/",
"name": "dt",
"value": "2024-07-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:54",
"last_data": "2024-08-14 14:32:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259981,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-09/",
"name": "dt",
"value": "2024-07-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:52",
"last_data": "2024-08-14 14:32:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259991,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-10/",
"name": "dt",
"value": "2024-07-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:54",
"last_data": "2024-08-14 14:32:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259965,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-11/",
"name": "dt",
"value": "2024-07-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:50",
"last_data": "2024-08-14 14:32:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259951,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-12/",
"name": "dt",
"value": "2024-07-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:48",
"last_data": "2024-08-14 14:32:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259917,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-13/",
"name": "dt",
"value": "2024-07-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:44",
"last_data": "2024-08-14 14:32:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259960,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-14/",
"name": "dt",
"value": "2024-07-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259921,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-15/",
"name": "dt",
"value": "2024-07-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:45",
"last_data": "2024-08-14 14:32:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259962,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-16/",
"name": "dt",
"value": "2024-07-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:50",
"last_data": "2024-08-14 14:32:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259968,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-17/",
"name": "dt",
"value": "2024-07-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259955,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-18/",
"name": "dt",
"value": "2024-07-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259920,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-19/",
"name": "dt",
"value": "2024-07-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:44",
"last_data": "2024-08-14 14:32:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259906,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-20/",
"name": "dt",
"value": "2024-07-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:42",
"last_data": "2024-08-14 14:32:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259977,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-21/",
"name": "dt",
"value": "2024-07-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259945,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-22/",
"name": "dt",
"value": "2024-07-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:48",
"last_data": "2024-08-14 14:32:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259976,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-23/",
"name": "dt",
"value": "2024-07-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259956,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-24/",
"name": "dt",
"value": "2024-07-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259971,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-25/",
"name": "dt",
"value": "2024-07-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259912,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-26/",
"name": "dt",
"value": "2024-07-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:43",
"last_data": "2024-08-14 14:32:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259966,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-27/",
"name": "dt",
"value": "2024-07-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:50",
"last_data": "2024-08-14 14:32:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259957,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-28/",
"name": "dt",
"value": "2024-07-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:49",
"last_data": "2024-08-14 14:32:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259946,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-29/",
"name": "dt",
"value": "2024-07-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:48",
"last_data": "2024-08-14 14:32:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259975,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-30/",
"name": "dt",
"value": "2024-07-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259980,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-07-31/",
"name": "dt",
"value": "2024-07-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:52",
"last_data": "2024-08-14 14:32:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259986,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-01/",
"name": "dt",
"value": "2024-08-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:53",
"last_data": "2024-08-14 14:32:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259941,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-02/",
"name": "dt",
"value": "2024-08-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:47",
"last_data": "2024-08-14 14:32:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259932,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-03/",
"name": "dt",
"value": "2024-08-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259972,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-04/",
"name": "dt",
"value": "2024-08-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259915,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-05/",
"name": "dt",
"value": "2024-08-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:44",
"last_data": "2024-08-14 14:32:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259919,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-06/",
"name": "dt",
"value": "2024-08-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:44",
"last_data": "2024-08-14 14:32:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259925,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-07/",
"name": "dt",
"value": "2024-08-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:45",
"last_data": "2024-08-14 14:32:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259983,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-08/",
"name": "dt",
"value": "2024-08-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:53",
"last_data": "2024-08-14 14:32:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259982,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-09/",
"name": "dt",
"value": "2024-08-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:52",
"last_data": "2024-08-14 14:32:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259963,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-10/",
"name": "dt",
"value": "2024-08-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:50",
"last_data": "2024-08-14 14:32:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259933,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-11/",
"name": "dt",
"value": "2024-08-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:46",
"last_data": "2024-08-14 14:32:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259969,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-12/",
"name": "dt",
"value": "2024-08-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:51",
"last_data": "2024-08-14 14:32:51"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259950,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-13/",
"name": "dt",
"value": "2024-08-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:48",
"last_data": "2024-08-14 14:32:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 259902,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_facility_performance/2024-08-14/1723663430/dt=2024-08-14/",
"name": "dt",
"value": "2024-08-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-14 14:32:18",
"last_data": "2024-08-14 14:32:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"account_customer_segment": "varchar(30)",
"account_lifetime_customer_segment": "varchar(30)",
"account_manager": "varchar(24)",
"account_manager_key": "int",
"account_pricing_model": "varchar(10)",
"annotations": "varchar(2048)",
"audit_id": "bigint",
"average_sort_position": "decimal(16,2)",
"bid_flat": "decimal",
"bid_percent": "decimal(6,2)",
"city": "varchar(200)",
"clicks": "int",
"client_key": "int",
"client_name": "varchar(200)",
"county": "varchar(32)",
"day": "date",
"day_key": "int",
"facility_date_live": "date",
"facility_is_directory": "int",
"facility_key": "int",
"facility_name": "varchar(200)",
"facility_status": "varchar(40)",
"hold_day": "date",
"impressions": "int",
"integration": "varchar(100)",
"integration_key": "int",
"location_key": "int",
"move_in_day": "date",
"msa": "varchar(150)",
"negative_bid_change_amount": "int",
"negative_bid_changes": "int",
"npv": "decimal(18,2)",
"positive_bid_change_amount": "int",
"positive_bid_changes": "int",
"reservation_auto_state": "varchar(20)",
"reservation_pricing_model": "varchar(12)",
"reservation_state": "varchar(20)",
"reservation_touchpoint": "varchar(19)",
"reservation_type": "varchar(12)",
"reservations": "int",
"searches": "int",
"site": "varchar(255)",
"site_key": "int",
"sparefoot_charge": "decimal(18,2)",
"state": "varchar(2)",
"statement_batch_close_day": "date",
"statement_batch_key": "int",
"statement_batch_move_in_start_day": "date",
"sum_rank": "bigint",
"zip": "varchar(6)"
},
"created": "2024-08-14 14:32:18",
"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_facility_performance`\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 , `site_key` int , `site` varchar(255) , `facility_key` int , `facility_name` varchar(200) , `client_key` int , `client_name` varchar(200) , `integration_key` int , `integration` varchar(100) , `facility_date_live` date , `facility_is_directory` int , `account_customer_segment` varchar(30) , `account_lifetime_customer_segment` varchar(30) , `account_manager_key` int , `account_manager` varchar(24) , `account_pricing_model` varchar(10) , `location_key` int , `zip` varchar(6) , `city` varchar(200) , `state` varchar(2) , `msa` varchar(150) , `county` varchar(32) , `reservation_type` varchar(12) , `reservation_pricing_model` varchar(12) , `reservation_touchpoint` varchar(19) , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `statement_batch_key` int , `facility_status` varchar(40) , `annotations` varchar(2048) , `sparefoot_charge` decimal(18,2) , `impressions` int , `clicks` int , `searches` int , `sum_rank` bigint , `average_sort_position` decimal(16,2) , `reservations` int , `npv` decimal(18,2) , `bid_flat` decimal , `bid_percent` decimal(6,2) , `positive_bid_changes` int , `negative_bid_changes` int , `positive_bid_change_amount` int , `negative_bid_change_amount` int , `_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_facility_performance/2024-08-14/1723663430'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_facility_performance`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_facility_performance"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}