Schema Info
Schema Name: sfdl_prod_drivethru.callpotential_billing
- created: 2024-08-08 13:14:18
- disabled: False
- format: raw
- id: 1979
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "callpotential_billing" } - type: drivethrucsv
Schema Versions: 1
-
Version 972856
- created: 2024-08-08 13:14:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.callpotential_billing`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.callpotential_billing`\n(\n `MONTH` string , `LOCATION_ID` string , `USER_ID` string , `CONSOLIDATE_INVOICES` string , `IS_ACTIVE` string , `LOCATION_NAME` string , `ACTIVE` string , `PHONE` string , `COMPANY_NAME` string , `FIRST_NAME` string , `LAST_NAME` string , `EMAIL` string , `PACKAGE_NAME` string , `PACKAGE_COST` string , `DESCRIPTION` string , `INVOICE_STREET` string , `INVOICE_CITY` string , `INVOICE_STATE` string , `INVOICE_COUNTRY` string , `INVOICE_ZIP` string , `MAX_USAGE` string , `TRACKING_NUMBER_INCL` string , `TRACKING_NUMBER_RATE` string , `MINUTE_INCL` string , `MINUTE_RATE` string , `SMS_INCL` string , `SMS_RATE` string , `TRACKING_NUMBERS_ACTIVE` string , `MINUTES_TOTAL` string , `TRACKING_NUMBER_CHANGE` string , `MINUTES_CHANGE` string , `ERROR` string , `NUMBER` string , `USER_ID_CFLAG_UNIQUE_NUMBER` string , `UNIQUE` string , `TOTAL_SPEND` string , `UNLIMITED` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.callpotential_billing" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing
- id: 972856
- processed: 1
- raw_data:
{ "ACTIVE": 6, "COMPANY_NAME": 8, "CONSOLIDATE_INVOICES": 3, "DESCRIPTION": 14, "EMAIL": 11, "ERROR": 31, "FIRST_NAME": 9, "INVOICE_CITY": 16, "INVOICE_COUNTRY": 18, "INVOICE_STATE": 17, "INVOICE_STREET": 15, "INVOICE_ZIP": 19, "IS_ACTIVE": 4, "LAST_NAME": 10, "LOCATION_ID": 1, "LOCATION_NAME": 5, "MAX_USAGE": 20, "MINUTES_CHANGE": 30, "MINUTES_TOTAL": 28, "MINUTE_INCL": 23, "MINUTE_RATE": 24, "MONTH": 0, "NUMBER": 32, "PACKAGE_COST": 13, "PACKAGE_NAME": 12, "PHONE": 7, "SMS_INCL": 25, "SMS_RATE": 26, "TOTAL_SPEND": 35, "TRACKING_NUMBERS_ACTIVE": 27, "TRACKING_NUMBER_CHANGE": 29, "TRACKING_NUMBER_INCL": 21, "TRACKING_NUMBER_RATE": 22, "UNIQUE": 34, "UNLIMITED": 36, "USER_ID": 2, "USER_ID_CFLAG_UNIQUE_NUMBER": 33 } - schema_attributes:
{ "ACTIVE": "string", "COMPANY_NAME": "string", "CONSOLIDATE_INVOICES": "string", "DESCRIPTION": "string", "EMAIL": "string", "ERROR": "string", "FIRST_NAME": "string", "INVOICE_CITY": "string", "INVOICE_COUNTRY": "string", "INVOICE_STATE": "string", "INVOICE_STREET": "string", "INVOICE_ZIP": "string", "IS_ACTIVE": "string", "LAST_NAME": "string", "LOCATION_ID": "string", "LOCATION_NAME": "string", "MAX_USAGE": "string", "MINUTES_CHANGE": "string", "MINUTES_TOTAL": "string", "MINUTE_INCL": "string", "MINUTE_RATE": "string", "MONTH": "string", "NUMBER": "string", "PACKAGE_COST": "string", "PACKAGE_NAME": "string", "PHONE": "string", "SMS_INCL": "string", "SMS_RATE": "string", "TOTAL_SPEND": "string", "TRACKING_NUMBERS_ACTIVE": "string", "TRACKING_NUMBER_CHANGE": "string", "TRACKING_NUMBER_INCL": "string", "TRACKING_NUMBER_RATE": "string", "UNIQUE": "string", "UNLIMITED": "string", "USER_ID": "string", "USER_ID_CFLAG_UNIQUE_NUMBER": "string" } - schema_name_id: 1979
- schema_scan_id: 124766300
- updated: 2024-08-08 13:14:33
Schema Scans: 1
Last at 2024-08-08 13:14:18
-
Scan 124766300
- duration: 0:00:24.029402
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 68, "partitions_applied": false, "success": true } - id: 124766300
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-08-01", "name": "dt", "type": "string", "value": "2024-08-01" }, "s3": { "bucket": "sfdl-drivethrucsv-drivethru-prod", "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing", "key": "raw_incremental/callpotential_billing/dt=2024-08-01/billing.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.callpotential_billing", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14069991852887330072, "service_name": "drive-thru", "span_id": 1684257103005647865, "trace_id": 3140393427472382804 } } - running: False
- schema_name_id: 1979
- start_time: 2024-08-08 13:14:18
- success: True
- trace_id: 3140393427472382804
- count: 69
- ddl:
[ "ALTER TABLE\n `sfdl_prod_drivethru.callpotential_billing`\nADD\n\n\n PARTITION (dt='2019-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-01-01/'\n PARTITION (dt='2019-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-02-01/'\n PARTITION (dt='2019-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-03-01/'\n PARTITION (dt='2019-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-04-01/'\n PARTITION (dt='2019-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-05-01/'\n PARTITION (dt='2019-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-06-01/'\n PARTITION (dt='2019-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-07-01/'\n PARTITION (dt='2019-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-08-01/'\n PARTITION (dt='2019-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-09-01/'\n PARTITION (dt='2019-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-10-01/'\n PARTITION (dt='2019-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-11-01/'\n PARTITION (dt='2019-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-12-01/'\n PARTITION (dt='2020-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-01-01/'\n PARTITION (dt='2020-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-02-01/'\n PARTITION (dt='2020-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-03-01/'\n PARTITION (dt='2020-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-04-01/'\n PARTITION (dt='2020-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-05-01/'\n PARTITION (dt='2020-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-06-01/'\n PARTITION (dt='2020-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-07-01/'\n PARTITION (dt='2020-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-08-01/'\n PARTITION (dt='2020-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-09-01/'\n PARTITION (dt='2020-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-10-01/'\n PARTITION (dt='2020-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-11-01/'\n PARTITION (dt='2020-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-12-01/'\n PARTITION (dt='2021-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-01-01/'\n PARTITION (dt='2021-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-02-01/'\n PARTITION (dt='2021-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-03-01/'\n PARTITION (dt='2021-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-04-01/'\n PARTITION (dt='2021-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-05-01/'\n PARTITION (dt='2021-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-06-01/'\n PARTITION (dt='2021-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-07-01/'\n PARTITION (dt='2021-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-08-01/'\n PARTITION (dt='2021-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-09-01/'\n PARTITION (dt='2021-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-10-01/'\n PARTITION (dt='2021-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-11-01/'\n PARTITION (dt='2021-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-12-01/'\n PARTITION (dt='2022-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-01-01/'\n PARTITION (dt='2022-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-02-01/'\n PARTITION (dt='2022-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-03-01/'\n PARTITION (dt='2022-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-04-01/'\n PARTITION (dt='2022-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-05-01/'\n PARTITION (dt='2022-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-06-01/'\n PARTITION (dt='2022-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-07-01/'\n PARTITION (dt='2022-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-08-01/'\n PARTITION (dt='2022-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-09-01/'\n PARTITION (dt='2022-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-10-01/'\n PARTITION (dt='2022-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-11-01/'\n PARTITION (dt='2022-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-12-01/'\n PARTITION (dt='2023-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-01-01/'\n PARTITION (dt='2023-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-02-01/'\n PARTITION (dt='2023-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-03-01/'\n PARTITION (dt='2023-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-04-01/'\n PARTITION (dt='2023-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-05-01/'\n PARTITION (dt='2023-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-06-01/'\n PARTITION (dt='2023-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-07-01/'\n PARTITION (dt='2023-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-08-01/'\n PARTITION (dt='2023-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-09-01/'\n PARTITION (dt='2023-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-10-01/'\n PARTITION (dt='2023-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-11-01/'\n PARTITION (dt='2023-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-12-01/'\n PARTITION (dt='2024-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-01-01/'\n PARTITION (dt='2024-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-02-01/'\n PARTITION (dt='2024-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-03-01/'\n PARTITION (dt='2024-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-04-01/'\n PARTITION (dt='2024-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-05-01/'\n PARTITION (dt='2024-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-06-01/'\n PARTITION (dt='2024-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-07-01/'\n PARTITION (dt='2024-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-08-01/'\n PARTITION (dt='2024-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-09-01/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1284523, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-01-01/", "name": "dt", "value": "2019-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284510, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-02-01/", "name": "dt", "value": "2019-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284500, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-03-01/", "name": "dt", "value": "2019-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284494, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-04-01/", "name": "dt", "value": "2019-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:36", "last_data": "2024-08-08 13:14:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284544, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-05-01/", "name": "dt", "value": "2019-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284545, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-06-01/", "name": "dt", "value": "2019-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284521, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-07-01/", "name": "dt", "value": "2019-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284517, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-08-01/", "name": "dt", "value": "2019-08-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284505, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-09-01/", "name": "dt", "value": "2019-09-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284550, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-10-01/", "name": "dt", "value": "2019-10-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:42", "last_data": "2024-08-08 13:14:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284508, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-11-01/", "name": "dt", "value": "2019-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284556, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-12-01/", "name": "dt", "value": "2019-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:42", "last_data": "2024-08-08 13:14:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284540, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-01-01/", "name": "dt", "value": "2020-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284546, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-02-01/", "name": "dt", "value": "2020-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284555, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-03-01/", "name": "dt", "value": "2020-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:42", "last_data": "2024-08-08 13:14:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284553, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-04-01/", "name": "dt", "value": "2020-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:42", "last_data": "2024-08-08 13:14:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284532, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-05-01/", "name": "dt", "value": "2020-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284541, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-06-01/", "name": "dt", "value": "2020-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284503, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-07-01/", "name": "dt", "value": "2020-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284507, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-08-01/", "name": "dt", "value": "2020-08-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284533, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-09-01/", "name": "dt", "value": "2020-09-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284537, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-10-01/", "name": "dt", "value": "2020-10-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284501, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-11-01/", "name": "dt", "value": "2020-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284548, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-12-01/", "name": "dt", "value": "2020-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284502, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-01-01/", "name": "dt", "value": "2021-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284495, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-02-01/", "name": "dt", "value": "2021-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:36", "last_data": "2024-08-08 13:14:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284552, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-03-01/", "name": "dt", "value": "2021-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:42", "last_data": "2024-08-08 13:14:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284525, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-04-01/", "name": "dt", "value": "2021-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284542, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-05-01/", "name": "dt", "value": "2021-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284509, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-06-01/", "name": "dt", "value": "2021-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284515, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-07-01/", "name": "dt", "value": "2021-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284554, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-08-01/", "name": "dt", "value": "2021-08-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:42", "last_data": "2024-08-08 13:14:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284520, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-09-01/", "name": "dt", "value": "2021-09-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284490, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-10-01/", "name": "dt", "value": "2021-10-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:36", "last_data": "2024-08-08 13:14:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284534, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-11-01/", "name": "dt", "value": "2021-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284504, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-12-01/", "name": "dt", "value": "2021-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284492, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-01-01/", "name": "dt", "value": "2022-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:36", "last_data": "2024-08-08 13:14:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284543, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-02-01/", "name": "dt", "value": "2022-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284518, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-03-01/", "name": "dt", "value": "2022-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284497, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-04-01/", "name": "dt", "value": "2022-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284547, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-05-01/", "name": "dt", "value": "2022-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284535, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-06-01/", "name": "dt", "value": "2022-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284496, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-07-01/", "name": "dt", "value": "2022-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284529, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-08-01/", "name": "dt", "value": "2022-08-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284528, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-09-01/", "name": "dt", "value": "2022-09-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284538, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-10-01/", "name": "dt", "value": "2022-10-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284493, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-11-01/", "name": "dt", "value": "2022-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:36", "last_data": "2024-08-08 13:14:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284498, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-12-01/", "name": "dt", "value": "2022-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284506, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-01-01/", "name": "dt", "value": "2023-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284539, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-02-01/", "name": "dt", "value": "2023-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284524, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-03-01/", "name": "dt", "value": "2023-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284511, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-04-01/", "name": "dt", "value": "2023-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284551, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-05-01/", "name": "dt", "value": "2023-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:42", "last_data": "2024-08-08 13:14:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284499, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-06-01/", "name": "dt", "value": "2023-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:37", "last_data": "2024-08-08 13:14:37" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284514, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-07-01/", "name": "dt", "value": "2023-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284513, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-08-01/", "name": "dt", "value": "2023-08-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284526, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-09-01/", "name": "dt", "value": "2023-09-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284531, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-10-01/", "name": "dt", "value": "2023-10-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284536, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-11-01/", "name": "dt", "value": "2023-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284549, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-12-01/", "name": "dt", "value": "2023-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:41", "last_data": "2024-08-08 13:14:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284519, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-01-01/", "name": "dt", "value": "2024-01-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284516, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-02-01/", "name": "dt", "value": "2024-02-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284512, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-03-01/", "name": "dt", "value": "2024-03-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:38", "last_data": "2024-08-08 13:14:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284491, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-04-01/", "name": "dt", "value": "2024-04-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:36", "last_data": "2024-08-08 13:14:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284530, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-05-01/", "name": "dt", "value": "2024-05-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:40", "last_data": "2024-08-08 13:14:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284522, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-06-01/", "name": "dt", "value": "2024-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284527, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-07-01/", "name": "dt", "value": "2024-07-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:39", "last_data": "2024-08-08 13:14:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1284489, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-08-01/", "name": "dt", "value": "2024-08-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-08-08 13:14:20", "last_data": "2024-08-08 13:14:20" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1330249, "location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-09-01/", "name": "dt", "value": "2024-09-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2024-09-09 15:01:50", "last_data": "2024-09-09 15:01:50" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "ACTIVE": "string", "COMPANY_NAME": "string", "CONSOLIDATE_INVOICES": "string", "DESCRIPTION": "string", "EMAIL": "string", "ERROR": "string", "FIRST_NAME": "string", "INVOICE_CITY": "string", "INVOICE_COUNTRY": "string", "INVOICE_STATE": "string", "INVOICE_STREET": "string", "INVOICE_ZIP": "string", "IS_ACTIVE": "string", "LAST_NAME": "string", "LOCATION_ID": "string", "LOCATION_NAME": "string", "MAX_USAGE": "string", "MINUTES_CHANGE": "string", "MINUTES_TOTAL": "string", "MINUTE_INCL": "string", "MINUTE_RATE": "string", "MONTH": "string", "NUMBER": "string", "PACKAGE_COST": "string", "PACKAGE_NAME": "string", "PHONE": "string", "SMS_INCL": "string", "SMS_RATE": "string", "TOTAL_SPEND": "string", "TRACKING_NUMBERS_ACTIVE": "string", "TRACKING_NUMBER_CHANGE": "string", "TRACKING_NUMBER_INCL": "string", "TRACKING_NUMBER_RATE": "string", "UNIQUE": "string", "UNLIMITED": "string", "USER_ID": "string", "USER_ID_CFLAG_UNIQUE_NUMBER": "string" } - created: 2024-08-08 13:14:20
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.callpotential_billing`\n(\n `MONTH` string , `LOCATION_ID` string , `USER_ID` string , `CONSOLIDATE_INVOICES` string , `IS_ACTIVE` string , `LOCATION_NAME` string , `ACTIVE` string , `PHONE` string , `COMPANY_NAME` string , `FIRST_NAME` string , `LAST_NAME` string , `EMAIL` string , `PACKAGE_NAME` string , `PACKAGE_COST` string , `DESCRIPTION` string , `INVOICE_STREET` string , `INVOICE_CITY` string , `INVOICE_STATE` string , `INVOICE_COUNTRY` string , `INVOICE_ZIP` string , `MAX_USAGE` string , `TRACKING_NUMBER_INCL` string , `TRACKING_NUMBER_RATE` string , `MINUTE_INCL` string , `MINUTE_RATE` string , `SMS_INCL` string , `SMS_RATE` string , `TRACKING_NUMBERS_ACTIVE` string , `MINUTES_TOTAL` string , `TRACKING_NUMBER_CHANGE` string , `MINUTES_CHANGE` string , `ERROR` string , `NUMBER` string , `USER_ID_CFLAG_UNIQUE_NUMBER` string , `UNIQUE` string , `TOTAL_SPEND` string , `UNLIMITED` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.callpotential_billing`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.callpotential_billing" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2024-08-08 13:14:18",
"disabled": false,
"format": "raw",
"id": 1979,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "callpotential_billing"
},
"type": "drivethrucsv"
},
"partition": {
"count": 69,
"ddl": [
"ALTER TABLE\n `sfdl_prod_drivethru.callpotential_billing`\nADD\n\n\n PARTITION (dt='2019-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-01-01/'\n PARTITION (dt='2019-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-02-01/'\n PARTITION (dt='2019-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-03-01/'\n PARTITION (dt='2019-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-04-01/'\n PARTITION (dt='2019-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-05-01/'\n PARTITION (dt='2019-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-06-01/'\n PARTITION (dt='2019-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-07-01/'\n PARTITION (dt='2019-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-08-01/'\n PARTITION (dt='2019-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-09-01/'\n PARTITION (dt='2019-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-10-01/'\n PARTITION (dt='2019-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-11-01/'\n PARTITION (dt='2019-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-12-01/'\n PARTITION (dt='2020-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-01-01/'\n PARTITION (dt='2020-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-02-01/'\n PARTITION (dt='2020-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-03-01/'\n PARTITION (dt='2020-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-04-01/'\n PARTITION (dt='2020-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-05-01/'\n PARTITION (dt='2020-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-06-01/'\n PARTITION (dt='2020-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-07-01/'\n PARTITION (dt='2020-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-08-01/'\n PARTITION (dt='2020-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-09-01/'\n PARTITION (dt='2020-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-10-01/'\n PARTITION (dt='2020-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-11-01/'\n PARTITION (dt='2020-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-12-01/'\n PARTITION (dt='2021-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-01-01/'\n PARTITION (dt='2021-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-02-01/'\n PARTITION (dt='2021-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-03-01/'\n PARTITION (dt='2021-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-04-01/'\n PARTITION (dt='2021-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-05-01/'\n PARTITION (dt='2021-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-06-01/'\n PARTITION (dt='2021-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-07-01/'\n PARTITION (dt='2021-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-08-01/'\n PARTITION (dt='2021-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-09-01/'\n PARTITION (dt='2021-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-10-01/'\n PARTITION (dt='2021-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-11-01/'\n PARTITION (dt='2021-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-12-01/'\n PARTITION (dt='2022-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-01-01/'\n PARTITION (dt='2022-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-02-01/'\n PARTITION (dt='2022-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-03-01/'\n PARTITION (dt='2022-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-04-01/'\n PARTITION (dt='2022-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-05-01/'\n PARTITION (dt='2022-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-06-01/'\n PARTITION (dt='2022-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-07-01/'\n PARTITION (dt='2022-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-08-01/'\n PARTITION (dt='2022-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-09-01/'\n PARTITION (dt='2022-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-10-01/'\n PARTITION (dt='2022-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-11-01/'\n PARTITION (dt='2022-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-12-01/'\n PARTITION (dt='2023-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-01-01/'\n PARTITION (dt='2023-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-02-01/'\n PARTITION (dt='2023-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-03-01/'\n PARTITION (dt='2023-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-04-01/'\n PARTITION (dt='2023-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-05-01/'\n PARTITION (dt='2023-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-06-01/'\n PARTITION (dt='2023-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-07-01/'\n PARTITION (dt='2023-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-08-01/'\n PARTITION (dt='2023-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-09-01/'\n PARTITION (dt='2023-10-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-10-01/'\n PARTITION (dt='2023-11-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-11-01/'\n PARTITION (dt='2023-12-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-12-01/'\n PARTITION (dt='2024-01-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-01-01/'\n PARTITION (dt='2024-02-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-02-01/'\n PARTITION (dt='2024-03-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-03-01/'\n PARTITION (dt='2024-04-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-04-01/'\n PARTITION (dt='2024-05-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-05-01/'\n PARTITION (dt='2024-06-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-06-01/'\n PARTITION (dt='2024-07-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-07-01/'\n PARTITION (dt='2024-08-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-08-01/'\n PARTITION (dt='2024-09-01') location 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-09-01/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1284523,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-01-01/",
"name": "dt",
"value": "2019-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284510,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-02-01/",
"name": "dt",
"value": "2019-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284500,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-03-01/",
"name": "dt",
"value": "2019-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284494,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-04-01/",
"name": "dt",
"value": "2019-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:36",
"last_data": "2024-08-08 13:14:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284544,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-05-01/",
"name": "dt",
"value": "2019-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284545,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-06-01/",
"name": "dt",
"value": "2019-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284521,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-07-01/",
"name": "dt",
"value": "2019-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284517,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-08-01/",
"name": "dt",
"value": "2019-08-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284505,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-09-01/",
"name": "dt",
"value": "2019-09-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284550,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-10-01/",
"name": "dt",
"value": "2019-10-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:42",
"last_data": "2024-08-08 13:14:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284508,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-11-01/",
"name": "dt",
"value": "2019-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284556,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2019-12-01/",
"name": "dt",
"value": "2019-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:42",
"last_data": "2024-08-08 13:14:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284540,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-01-01/",
"name": "dt",
"value": "2020-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284546,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-02-01/",
"name": "dt",
"value": "2020-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284555,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-03-01/",
"name": "dt",
"value": "2020-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:42",
"last_data": "2024-08-08 13:14:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284553,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-04-01/",
"name": "dt",
"value": "2020-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:42",
"last_data": "2024-08-08 13:14:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284532,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-05-01/",
"name": "dt",
"value": "2020-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284541,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-06-01/",
"name": "dt",
"value": "2020-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284503,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-07-01/",
"name": "dt",
"value": "2020-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284507,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-08-01/",
"name": "dt",
"value": "2020-08-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284533,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-09-01/",
"name": "dt",
"value": "2020-09-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284537,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-10-01/",
"name": "dt",
"value": "2020-10-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284501,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-11-01/",
"name": "dt",
"value": "2020-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284548,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2020-12-01/",
"name": "dt",
"value": "2020-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284502,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-01-01/",
"name": "dt",
"value": "2021-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284495,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-02-01/",
"name": "dt",
"value": "2021-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:36",
"last_data": "2024-08-08 13:14:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284552,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-03-01/",
"name": "dt",
"value": "2021-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:42",
"last_data": "2024-08-08 13:14:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284525,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-04-01/",
"name": "dt",
"value": "2021-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284542,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-05-01/",
"name": "dt",
"value": "2021-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284509,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-06-01/",
"name": "dt",
"value": "2021-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284515,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-07-01/",
"name": "dt",
"value": "2021-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284554,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-08-01/",
"name": "dt",
"value": "2021-08-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:42",
"last_data": "2024-08-08 13:14:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284520,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-09-01/",
"name": "dt",
"value": "2021-09-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284490,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-10-01/",
"name": "dt",
"value": "2021-10-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:36",
"last_data": "2024-08-08 13:14:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284534,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-11-01/",
"name": "dt",
"value": "2021-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284504,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2021-12-01/",
"name": "dt",
"value": "2021-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284492,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-01-01/",
"name": "dt",
"value": "2022-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:36",
"last_data": "2024-08-08 13:14:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284543,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-02-01/",
"name": "dt",
"value": "2022-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284518,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-03-01/",
"name": "dt",
"value": "2022-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284497,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-04-01/",
"name": "dt",
"value": "2022-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284547,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-05-01/",
"name": "dt",
"value": "2022-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284535,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-06-01/",
"name": "dt",
"value": "2022-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284496,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-07-01/",
"name": "dt",
"value": "2022-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284529,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-08-01/",
"name": "dt",
"value": "2022-08-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284528,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-09-01/",
"name": "dt",
"value": "2022-09-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284538,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-10-01/",
"name": "dt",
"value": "2022-10-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284493,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-11-01/",
"name": "dt",
"value": "2022-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:36",
"last_data": "2024-08-08 13:14:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284498,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2022-12-01/",
"name": "dt",
"value": "2022-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284506,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-01-01/",
"name": "dt",
"value": "2023-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284539,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-02-01/",
"name": "dt",
"value": "2023-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284524,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-03-01/",
"name": "dt",
"value": "2023-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284511,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-04-01/",
"name": "dt",
"value": "2023-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284551,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-05-01/",
"name": "dt",
"value": "2023-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:42",
"last_data": "2024-08-08 13:14:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284499,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-06-01/",
"name": "dt",
"value": "2023-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:37",
"last_data": "2024-08-08 13:14:37"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284514,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-07-01/",
"name": "dt",
"value": "2023-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284513,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-08-01/",
"name": "dt",
"value": "2023-08-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284526,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-09-01/",
"name": "dt",
"value": "2023-09-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284531,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-10-01/",
"name": "dt",
"value": "2023-10-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284536,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-11-01/",
"name": "dt",
"value": "2023-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284549,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2023-12-01/",
"name": "dt",
"value": "2023-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:41",
"last_data": "2024-08-08 13:14:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284519,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-01-01/",
"name": "dt",
"value": "2024-01-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284516,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-02-01/",
"name": "dt",
"value": "2024-02-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284512,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-03-01/",
"name": "dt",
"value": "2024-03-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:38",
"last_data": "2024-08-08 13:14:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284491,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-04-01/",
"name": "dt",
"value": "2024-04-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:36",
"last_data": "2024-08-08 13:14:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284530,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-05-01/",
"name": "dt",
"value": "2024-05-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:40",
"last_data": "2024-08-08 13:14:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284522,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-06-01/",
"name": "dt",
"value": "2024-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284527,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-07-01/",
"name": "dt",
"value": "2024-07-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:39",
"last_data": "2024-08-08 13:14:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1284489,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-08-01/",
"name": "dt",
"value": "2024-08-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-08-08 13:14:20",
"last_data": "2024-08-08 13:14:20"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1330249,
"location": "s3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing/dt=2024-09-01/",
"name": "dt",
"value": "2024-09-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2024-09-09 15:01:50",
"last_data": "2024-09-09 15:01:50"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"ACTIVE": "string",
"COMPANY_NAME": "string",
"CONSOLIDATE_INVOICES": "string",
"DESCRIPTION": "string",
"EMAIL": "string",
"ERROR": "string",
"FIRST_NAME": "string",
"INVOICE_CITY": "string",
"INVOICE_COUNTRY": "string",
"INVOICE_STATE": "string",
"INVOICE_STREET": "string",
"INVOICE_ZIP": "string",
"IS_ACTIVE": "string",
"LAST_NAME": "string",
"LOCATION_ID": "string",
"LOCATION_NAME": "string",
"MAX_USAGE": "string",
"MINUTES_CHANGE": "string",
"MINUTES_TOTAL": "string",
"MINUTE_INCL": "string",
"MINUTE_RATE": "string",
"MONTH": "string",
"NUMBER": "string",
"PACKAGE_COST": "string",
"PACKAGE_NAME": "string",
"PHONE": "string",
"SMS_INCL": "string",
"SMS_RATE": "string",
"TOTAL_SPEND": "string",
"TRACKING_NUMBERS_ACTIVE": "string",
"TRACKING_NUMBER_CHANGE": "string",
"TRACKING_NUMBER_INCL": "string",
"TRACKING_NUMBER_RATE": "string",
"UNIQUE": "string",
"UNLIMITED": "string",
"USER_ID": "string",
"USER_ID_CFLAG_UNIQUE_NUMBER": "string"
},
"created": "2024-08-08 13:14:20",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.callpotential_billing`\n(\n `MONTH` string , `LOCATION_ID` string , `USER_ID` string , `CONSOLIDATE_INVOICES` string , `IS_ACTIVE` string , `LOCATION_NAME` string , `ACTIVE` string , `PHONE` string , `COMPANY_NAME` string , `FIRST_NAME` string , `LAST_NAME` string , `EMAIL` string , `PACKAGE_NAME` string , `PACKAGE_COST` string , `DESCRIPTION` string , `INVOICE_STREET` string , `INVOICE_CITY` string , `INVOICE_STATE` string , `INVOICE_COUNTRY` string , `INVOICE_ZIP` string , `MAX_USAGE` string , `TRACKING_NUMBER_INCL` string , `TRACKING_NUMBER_RATE` string , `MINUTE_INCL` string , `MINUTE_RATE` string , `SMS_INCL` string , `SMS_RATE` string , `TRACKING_NUMBERS_ACTIVE` string , `MINUTES_TOTAL` string , `TRACKING_NUMBER_CHANGE` string , `MINUTES_CHANGE` string , `ERROR` string , `NUMBER` string , `USER_ID_CFLAG_UNIQUE_NUMBER` string , `UNIQUE` string , `TOTAL_SPEND` string , `UNLIMITED` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-drivethrucsv-drivethru-prod/raw_incremental/callpotential_billing'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.callpotential_billing`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.callpotential_billing"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}