Schema Info
Schema Name: sfdl_prod_csv.talkdesk_calls
- created: 2023-01-10 10:03:25
- disabled: False
- format: raw
- id: 1251
- is_partitioned: True
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_csv", "table": "talkdesk_calls" } - type: csv
Schema Versions: 2
-
Version 1191182
- created: 2025-02-11 06:31:38
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.talkdesk_calls`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.talkdesk_calls`\n(\n `Call_Id` string , `Callsid` string , `Type` string , `Start_At` string , `End_At` string , `Talkdesk_Phone_Number` string , `Talkdesk_Phone_Display_Name` string , `Contact_Phone_Number` string , `User_Id` string , `User_Name` string , `User_Email` string , `Total_Time` string , `Talk_Time` string , `Wait_Time` string , `Hold_Time` string , `Abandon_Time` string , `Total_Ringing_Time` string , `Disposition_Code` string , `Notes` string , `User_Voice_Rating` string , `Ring_Groups` string , `IVR_Options` string , `Is_In_Business_Hours` string , `Is_Callback_From_Queue` string , `Is_Transfer` string , `Handling_User_Id` string , `Handling_User_Name` string , `Handling_User_Email` string , `Recording_Url` string , `Is_External_Transfer` string , `Is_If_No_Answer` string , `Is_Call_Forwarding` string , `CSAT_Score` string , `CSAT_Survey_Time` string , `Team_Id` string , `Team_Name` string , `Rating_Reason` string , `Agent_Disconnected` string , `Data_Status__Valid___Damaged_` string , `Disposition_Set` string , `Nested_Disposition` 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-csv-talkdesk-prod/raw_incremental/calls'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.talkdesk_calls" ] - hive_path: s3://sfdl-csv-talkdesk-prod/raw_incremental/calls
- id: 1191182
- processed: 1
- raw_data:
{ "Abandon Time": 15, "Agent Disconnected": 37, "CSAT Score": 32, "CSAT Survey Time": 33, "Call Id": 0, "Callsid": 1, "Contact Phone Number": 7, "Data Status (Valid / Damaged)": 38, "Disposition Code": 17, "Disposition Set": 39, "End At": 4, "Handling User Email": 27, "Handling User Id": 25, "Handling User Name": 26, "Hold Time": 14, "IVR Options": 21, "Is Call Forwarding": 31, "Is Callback From Queue": 23, "Is External Transfer": 29, "Is If No Answer": 30, "Is In Business Hours": 22, "Is Transfer": 24, "Nested Disposition": 40, "Notes": 18, "Rating Reason": 36, "Recording Url": 28, "Ring Groups": 20, "Start At": 3, "Talk Time": 12, "Talkdesk Phone Display Name": 6, "Talkdesk Phone Number": 5, "Team Id": 34, "Team Name": 35, "Total Ringing Time": 16, "Total Time": 11, "Type": 2, "User Email": 10, "User Id": 8, "User Name": 9, "User Voice Rating": 19, "Wait Time": 13 } - schema_attributes:
{ "Abandon_Time": "string", "Agent_Disconnected": "string", "CSAT_Score": "string", "CSAT_Survey_Time": "string", "Call_Id": "string", "Callsid": "string", "Contact_Phone_Number": "string", "Data_Status__Valid___Damaged_": "string", "Disposition_Code": "string", "Disposition_Set": "string", "End_At": "string", "Handling_User_Email": "string", "Handling_User_Id": "string", "Handling_User_Name": "string", "Hold_Time": "string", "IVR_Options": "string", "Is_Call_Forwarding": "string", "Is_Callback_From_Queue": "string", "Is_External_Transfer": "string", "Is_If_No_Answer": "string", "Is_In_Business_Hours": "string", "Is_Transfer": "string", "Nested_Disposition": "string", "Notes": "string", "Rating_Reason": "string", "Recording_Url": "string", "Ring_Groups": "string", "Start_At": "string", "Talk_Time": "string", "Talkdesk_Phone_Display_Name": "string", "Talkdesk_Phone_Number": "string", "Team_Id": "string", "Team_Name": "string", "Total_Ringing_Time": "string", "Total_Time": "string", "Type": "string", "User_Email": "string", "User_Id": "string", "User_Name": "string", "User_Voice_Rating": "string", "Wait_Time": "string" } - schema_name_id: 1251
- schema_scan_id: 136971930
- updated: 2025-02-11 06:32:15
-
Version 419645
- created: 2023-01-10 10:03:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "DROP TABLE IF EXISTS `sfdl_prod_csv.talkdesk_calls`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.talkdesk_calls`\n(\n `Call_Id` string , `Callsid` string , `Type` string , `Start_At` string , `End_At` string , `Talkdesk_Phone_Number` string , `Talkdesk_Phone_Display_Name` string , `Contact_Phone_Number` string , `User_Id` string , `User_Name` string , `User_Email` string , `Total_Time` string , `Talk_Time` string , `Wait_Time` string , `Hold_Time` string , `Abandon_Time` string , `Total_Ringing_Time` string , `Disposition_Code` string , `Notes` string , `User_Voice_Rating` string , `Ring_Groups` string , `IVR_Options` string , `Is_In_Business_Hours` string , `Is_Callback_From_Queue` string , `Is_Transfer` string , `Handling_User_Id` string , `Handling_User_Name` string , `Handling_User_Email` string , `Recording_Url` string , `Is_External_Transfer` string , `Is_If_No_Answer` string , `Is_Call_Forwarding` string , `CSAT_Score` string , `CSAT_Survey_Time` string , `Team_Id` string , `Team_Name` string , `Rating_Reason` string , `Agent_Disconnected` string , `Data_Status__Valid___Damaged_` 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-csv-talkdesk-prod/raw_incremental/calls'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_csv.talkdesk_calls" ] - hive_path: s3://sfdl-csv-talkdesk-prod/raw_incremental/calls
- id: 419645
- processed: 1
- raw_data:
{ "Abandon Time": 15, "Agent Disconnected": 37, "CSAT Score": 32, "CSAT Survey Time": 33, "Call Id": 0, "Callsid": 1, "Contact Phone Number": 7, "Data Status (Valid / Damaged)": 38, "Disposition Code": 17, "End At": 4, "Handling User Email": 27, "Handling User Id": 25, "Handling User Name": 26, "Hold Time": 14, "IVR Options": 21, "Is Call Forwarding": 31, "Is Callback From Queue": 23, "Is External Transfer": 29, "Is If No Answer": 30, "Is In Business Hours": 22, "Is Transfer": 24, "Notes": 18, "Rating Reason": 36, "Recording Url": 28, "Ring Groups": 20, "Start At": 3, "Talk Time": 12, "Talkdesk Phone Display Name": 6, "Talkdesk Phone Number": 5, "Team Id": 34, "Team Name": 35, "Total Ringing Time": 16, "Total Time": 11, "Type": 2, "User Email": 10, "User Id": 8, "User Name": 9, "User Voice Rating": 19, "Wait Time": 13 } - schema_attributes:
{ "Abandon_Time": "string", "Agent_Disconnected": "string", "CSAT_Score": "string", "CSAT_Survey_Time": "string", "Call_Id": "string", "Callsid": "string", "Contact_Phone_Number": "string", "Data_Status__Valid___Damaged_": "string", "Disposition_Code": "string", "End_At": "string", "Handling_User_Email": "string", "Handling_User_Id": "string", "Handling_User_Name": "string", "Hold_Time": "string", "IVR_Options": "string", "Is_Call_Forwarding": "string", "Is_Callback_From_Queue": "string", "Is_External_Transfer": "string", "Is_If_No_Answer": "string", "Is_In_Business_Hours": "string", "Is_Transfer": "string", "Notes": "string", "Rating_Reason": "string", "Recording_Url": "string", "Ring_Groups": "string", "Start_At": "string", "Talk_Time": "string", "Talkdesk_Phone_Display_Name": "string", "Talkdesk_Phone_Number": "string", "Team_Id": "string", "Team_Name": "string", "Total_Ringing_Time": "string", "Total_Time": "string", "Type": "string", "User_Email": "string", "User_Id": "string", "User_Name": "string", "User_Voice_Rating": "string", "Wait_Time": "string" } - schema_name_id: 1251
- schema_scan_id: 83442530
- updated: 2023-01-10 10:04:15
Schema Scans: 2
Last at 2025-02-11 06:31:37
-
Scan 136971930
- duration: 0:02:32.979637
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 1471, "partitions_applied": false, "success": true } - id: 136971930
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-02-10", "name": "dt", "type": "string", "value": "2025-02-10" }, "s3": { "bucket": "sfdl-csv-talkdesk-prod", "hive_path": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls", "key": "raw_incremental/calls/dt=2025-02-10/data.csv.gz" }, "schema": { "name": "sfdl_prod_csv.talkdesk_calls", "type": "csv" }, "trace_context": { "parent_id": 3834648016872966754, "service_name": "drive-thru", "span_id": 14217710703068746069, "trace_id": 979181257597509921 } } - running: False
- schema_name_id: 1251
- start_time: 2025-02-11 06:31:37
- success: True
- trace_id: 979181257597509921
-
Scan 83442530
- duration: 0:01:50.704677
- exit_message:
{ "ddl_changed": true, "ingested_partitions": 708, "partitions_applied": false, "success": true } - id: 83442530
- payload:
{ "datatype_dict": null, "file_format": "csv", "file_properties": { "data_has_header_row": true }, "is_schema_datatyped": true, "partition": { "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2023-01-09", "name": "dt", "type": "string", "value": "2023-01-09" }, "s3": { "bucket": "sfdl-csv-talkdesk-prod", "hive_path": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls", "key": "raw_incremental/calls/dt=2023-01-09/data.csv.gz" }, "schema": { "name": "sfdl_prod_csv.talkdesk_calls", "type": "csv" }, "trace_context": { "parent_id": 17494190569262334146, "service_name": "drive-thru", "span_id": 639718994018513733, "trace_id": 4409467917487306509 } } - running: False
- schema_name_id: 1251
- start_time: 2023-01-10 10:03:25
- success: True
- trace_id: 4409467917487306509
- count: 56
- ddl:
[ "ALTER TABLE\n `sfdl_prod_csv.talkdesk_calls`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-14/'\n PARTITION (dt='2025-10-15') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-15/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-26/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-28/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-29/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-08/'\n;" ] - name: dt
- state:
[ { "info": { "id": 1566070, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-14/", "name": "dt", "value": "2025-10-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-15 06:01:06", "last_data": "2025-10-15 06:01:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1566304, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-15/", "name": "dt", "value": "2025-10-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-16 06:02:38", "last_data": "2025-10-16 06:02:38" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1584184, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-16/", "name": "dt", "value": "2025-10-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-17 06:01:39", "last_data": "2025-10-17 06:01:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1595966, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-17/", "name": "dt", "value": "2025-10-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-18 06:00:53", "last_data": "2025-10-18 06:00:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1596190, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-18/", "name": "dt", "value": "2025-10-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-19 06:01:28", "last_data": "2025-10-19 06:01:28" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1596758, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-19/", "name": "dt", "value": "2025-10-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-20 06:07:19", "last_data": "2025-10-20 06:07:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1596998, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-20/", "name": "dt", "value": "2025-10-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-21 06:07:56", "last_data": "2025-10-21 06:07:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597235, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-21/", "name": "dt", "value": "2025-10-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-22 06:07:17", "last_data": "2025-10-22 06:07:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597463, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-22/", "name": "dt", "value": "2025-10-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-23 06:10:04", "last_data": "2025-10-23 06:10:04" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597724, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-23/", "name": "dt", "value": "2025-10-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-24 06:09:47", "last_data": "2025-10-24 06:09:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1597962, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-24/", "name": "dt", "value": "2025-10-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-25 06:11:07", "last_data": "2025-10-25 06:11:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598196, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-25/", "name": "dt", "value": "2025-10-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-26 06:31:33", "last_data": "2025-10-26 06:31:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598418, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-26/", "name": "dt", "value": "2025-10-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-27 06:08:44", "last_data": "2025-10-27 06:08:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598663, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-27/", "name": "dt", "value": "2025-10-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-28 06:31:32", "last_data": "2025-10-28 06:31:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1598895, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-28/", "name": "dt", "value": "2025-10-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-29 06:36:06", "last_data": "2025-10-29 06:36:06" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599132, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-29/", "name": "dt", "value": "2025-10-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-30 06:08:29", "last_data": "2025-10-30 06:08:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599369, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-30/", "name": "dt", "value": "2025-10-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-10-31 06:44:25", "last_data": "2025-10-31 06:44:25" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1599611, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-31/", "name": "dt", "value": "2025-10-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-01 06:32:16", "last_data": "2025-11-01 06:32:16" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600037, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-01/", "name": "dt", "value": "2025-11-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-02 06:11:08", "last_data": "2025-11-02 06:11:08" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600272, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-02/", "name": "dt", "value": "2025-11-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-03 06:09:48", "last_data": "2025-11-03 06:09:48" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600512, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-03/", "name": "dt", "value": "2025-11-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-04 06:09:02", "last_data": "2025-11-04 06:09:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600757, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-04/", "name": "dt", "value": "2025-11-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-05 06:33:32", "last_data": "2025-11-05 06:33:32" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1600990, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-05/", "name": "dt", "value": "2025-11-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-06 06:10:15", "last_data": "2025-11-06 06:10:15" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601230, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-06/", "name": "dt", "value": "2025-11-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-07 06:31:36", "last_data": "2025-11-07 06:31:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601492, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-07/", "name": "dt", "value": "2025-11-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-08 06:11:33", "last_data": "2025-11-08 06:11:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601727, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-08/", "name": "dt", "value": "2025-11-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-09 06:35:39", "last_data": "2025-11-09 06:35:39" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1601962, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-09/", "name": "dt", "value": "2025-11-09" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-10 06:13:57", "last_data": "2025-11-10 06:13:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602199, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-10/", "name": "dt", "value": "2025-11-10" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-11 06:07:52", "last_data": "2025-11-11 06:07:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602446, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-11/", "name": "dt", "value": "2025-11-11" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-12 07:16:33", "last_data": "2025-11-12 07:16:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602676, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-12/", "name": "dt", "value": "2025-11-12" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-13 06:09:45", "last_data": "2025-11-13 06:09:45" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1602912, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-13/", "name": "dt", "value": "2025-11-13" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-14 06:10:10", "last_data": "2025-11-14 06:10:10" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1603143, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-14/", "name": "dt", "value": "2025-11-14" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-15 06:14:54", "last_data": "2025-11-15 06:14:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1604789, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-15/", "name": "dt", "value": "2025-11-15" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-16 06:10:34", "last_data": "2025-11-16 06:10:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1605802, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-16/", "name": "dt", "value": "2025-11-16" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-17 06:10:18", "last_data": "2025-11-17 06:10:18" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606071, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-17/", "name": "dt", "value": "2025-11-17" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-18 06:08:57", "last_data": "2025-11-18 06:08:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606304, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-18/", "name": "dt", "value": "2025-11-18" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-19 06:13:09", "last_data": "2025-11-19 06:13:09" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606547, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-19/", "name": "dt", "value": "2025-11-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-20 06:11:57", "last_data": "2025-11-20 06:11:57" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1606779, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-20/", "name": "dt", "value": "2025-11-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-21 06:09:14", "last_data": "2025-11-21 06:09:14" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1607545, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-21/", "name": "dt", "value": "2025-11-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-22 06:11:19", "last_data": "2025-11-22 06:11:19" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1607800, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-22/", "name": "dt", "value": "2025-11-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-23 06:06:40", "last_data": "2025-11-23 06:06:40" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608028, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-23/", "name": "dt", "value": "2025-11-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-24 06:31:36", "last_data": "2025-11-24 06:31:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608267, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-24/", "name": "dt", "value": "2025-11-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-25 06:09:00", "last_data": "2025-11-25 06:09:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608501, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-25/", "name": "dt", "value": "2025-11-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-26 06:10:47", "last_data": "2025-11-26 06:10:47" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608734, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-26/", "name": "dt", "value": "2025-11-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-27 06:07:11", "last_data": "2025-11-27 06:07:11" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1608960, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-27/", "name": "dt", "value": "2025-11-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-28 06:06:53", "last_data": "2025-11-28 06:06:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609193, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-28/", "name": "dt", "value": "2025-11-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-29 06:09:43", "last_data": "2025-11-29 06:09:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609420, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-29/", "name": "dt", "value": "2025-11-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-11-30 06:08:29", "last_data": "2025-11-30 06:08:29" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609652, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-30/", "name": "dt", "value": "2025-11-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-01 06:08:46", "last_data": "2025-12-01 06:08:46" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1609899, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-01/", "name": "dt", "value": "2025-12-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-02 06:07:27", "last_data": "2025-12-02 06:07:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610138, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-02/", "name": "dt", "value": "2025-12-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-03 06:11:21", "last_data": "2025-12-03 06:11:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610382, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-03/", "name": "dt", "value": "2025-12-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-04 06:15:22", "last_data": "2025-12-04 06:15:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1610614, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-04/", "name": "dt", "value": "2025-12-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-05 06:04:01", "last_data": "2025-12-05 06:04:01" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611131, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-05/", "name": "dt", "value": "2025-12-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-06 06:10:36", "last_data": "2025-12-06 06:10:36" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611362, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-06/", "name": "dt", "value": "2025-12-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-07 06:15:56", "last_data": "2025-12-07 06:15:56" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611587, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-07/", "name": "dt", "value": "2025-12-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-08 06:09:07", "last_data": "2025-12-08 06:09:07" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 1611825, "location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-08/", "name": "dt", "value": "2025-12-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2025-12-09 06:07:17", "last_data": "2025-12-09 06:07:17" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "Abandon_Time": "string", "Agent_Disconnected": "string", "CSAT_Score": "string", "CSAT_Survey_Time": "string", "Call_Id": "string", "Callsid": "string", "Contact_Phone_Number": "string", "Data_Status__Valid___Damaged_": "string", "Disposition_Code": "string", "Disposition_Set": "string", "End_At": "string", "Handling_User_Email": "string", "Handling_User_Id": "string", "Handling_User_Name": "string", "Hold_Time": "string", "IVR_Options": "string", "Is_Call_Forwarding": "string", "Is_Callback_From_Queue": "string", "Is_External_Transfer": "string", "Is_If_No_Answer": "string", "Is_In_Business_Hours": "string", "Is_Transfer": "string", "Nested_Disposition": "string", "Notes": "string", "Rating_Reason": "string", "Recording_Url": "string", "Ring_Groups": "string", "Start_At": "string", "Talk_Time": "string", "Talkdesk_Phone_Display_Name": "string", "Talkdesk_Phone_Number": "string", "Team_Id": "string", "Team_Name": "string", "Total_Ringing_Time": "string", "Total_Time": "string", "Type": "string", "User_Email": "string", "User_Id": "string", "User_Name": "string", "User_Voice_Rating": "string", "Wait_Time": "string" } - created: 2025-02-11 06:31:38
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.talkdesk_calls`\n(\n `Call_Id` string , `Callsid` string , `Type` string , `Start_At` string , `End_At` string , `Talkdesk_Phone_Number` string , `Talkdesk_Phone_Display_Name` string , `Contact_Phone_Number` string , `User_Id` string , `User_Name` string , `User_Email` string , `Total_Time` string , `Talk_Time` string , `Wait_Time` string , `Hold_Time` string , `Abandon_Time` string , `Total_Ringing_Time` string , `Disposition_Code` string , `Notes` string , `User_Voice_Rating` string , `Ring_Groups` string , `IVR_Options` string , `Is_In_Business_Hours` string , `Is_Callback_From_Queue` string , `Is_Transfer` string , `Handling_User_Id` string , `Handling_User_Name` string , `Handling_User_Email` string , `Recording_Url` string , `Is_External_Transfer` string , `Is_If_No_Answer` string , `Is_Call_Forwarding` string , `CSAT_Score` string , `CSAT_Survey_Time` string , `Team_Id` string , `Team_Name` string , `Rating_Reason` string , `Agent_Disconnected` string , `Data_Status__Valid___Damaged_` string , `Disposition_Set` string , `Nested_Disposition` 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-csv-talkdesk-prod/raw_incremental/calls'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.talkdesk_calls`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.talkdesk_calls" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-01-10 10:03:25",
"disabled": false,
"format": "raw",
"id": 1251,
"is_partitioned": true,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_csv",
"table": "talkdesk_calls"
},
"type": "csv"
},
"partition": {
"count": 56,
"ddl": [
"ALTER TABLE\n `sfdl_prod_csv.talkdesk_calls`\nADD\n\n\n PARTITION (dt='2025-10-14') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-14/'\n PARTITION (dt='2025-10-15') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-15/'\n PARTITION (dt='2025-10-16') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-16/'\n PARTITION (dt='2025-10-17') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-17/'\n PARTITION (dt='2025-10-18') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-18/'\n PARTITION (dt='2025-10-19') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-19/'\n PARTITION (dt='2025-10-20') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-20/'\n PARTITION (dt='2025-10-21') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-21/'\n PARTITION (dt='2025-10-22') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-22/'\n PARTITION (dt='2025-10-23') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-23/'\n PARTITION (dt='2025-10-24') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-24/'\n PARTITION (dt='2025-10-25') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-25/'\n PARTITION (dt='2025-10-26') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-26/'\n PARTITION (dt='2025-10-27') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-27/'\n PARTITION (dt='2025-10-28') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-28/'\n PARTITION (dt='2025-10-29') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-29/'\n PARTITION (dt='2025-10-30') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-30/'\n PARTITION (dt='2025-10-31') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-31/'\n PARTITION (dt='2025-11-01') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-01/'\n PARTITION (dt='2025-11-02') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-02/'\n PARTITION (dt='2025-11-03') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-03/'\n PARTITION (dt='2025-11-04') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-04/'\n PARTITION (dt='2025-11-05') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-05/'\n PARTITION (dt='2025-11-06') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-06/'\n PARTITION (dt='2025-11-07') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-07/'\n PARTITION (dt='2025-11-08') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-08/'\n PARTITION (dt='2025-11-09') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-09/'\n PARTITION (dt='2025-11-10') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-10/'\n PARTITION (dt='2025-11-11') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-11/'\n PARTITION (dt='2025-11-12') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-12/'\n PARTITION (dt='2025-11-13') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-13/'\n PARTITION (dt='2025-11-14') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-14/'\n PARTITION (dt='2025-11-15') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-15/'\n PARTITION (dt='2025-11-16') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-16/'\n PARTITION (dt='2025-11-17') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-17/'\n PARTITION (dt='2025-11-18') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-18/'\n PARTITION (dt='2025-11-19') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-19/'\n PARTITION (dt='2025-11-20') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-20/'\n PARTITION (dt='2025-11-21') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-21/'\n PARTITION (dt='2025-11-22') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-22/'\n PARTITION (dt='2025-11-23') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-23/'\n PARTITION (dt='2025-11-24') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-24/'\n PARTITION (dt='2025-11-25') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-25/'\n PARTITION (dt='2025-11-26') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-26/'\n PARTITION (dt='2025-11-27') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-27/'\n PARTITION (dt='2025-11-28') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-28/'\n PARTITION (dt='2025-11-29') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-29/'\n PARTITION (dt='2025-11-30') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-30/'\n PARTITION (dt='2025-12-01') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-01/'\n PARTITION (dt='2025-12-02') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-02/'\n PARTITION (dt='2025-12-03') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-03/'\n PARTITION (dt='2025-12-04') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-04/'\n PARTITION (dt='2025-12-05') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-05/'\n PARTITION (dt='2025-12-06') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-06/'\n PARTITION (dt='2025-12-07') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-07/'\n PARTITION (dt='2025-12-08') location 's3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-08/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 1566070,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-14/",
"name": "dt",
"value": "2025-10-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-15 06:01:06",
"last_data": "2025-10-15 06:01:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1566304,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-15/",
"name": "dt",
"value": "2025-10-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-16 06:02:38",
"last_data": "2025-10-16 06:02:38"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1584184,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-16/",
"name": "dt",
"value": "2025-10-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-17 06:01:39",
"last_data": "2025-10-17 06:01:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1595966,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-17/",
"name": "dt",
"value": "2025-10-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-18 06:00:53",
"last_data": "2025-10-18 06:00:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1596190,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-18/",
"name": "dt",
"value": "2025-10-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-19 06:01:28",
"last_data": "2025-10-19 06:01:28"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1596758,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-19/",
"name": "dt",
"value": "2025-10-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-20 06:07:19",
"last_data": "2025-10-20 06:07:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1596998,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-20/",
"name": "dt",
"value": "2025-10-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-21 06:07:56",
"last_data": "2025-10-21 06:07:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597235,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-21/",
"name": "dt",
"value": "2025-10-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-22 06:07:17",
"last_data": "2025-10-22 06:07:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597463,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-22/",
"name": "dt",
"value": "2025-10-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-23 06:10:04",
"last_data": "2025-10-23 06:10:04"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597724,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-23/",
"name": "dt",
"value": "2025-10-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-24 06:09:47",
"last_data": "2025-10-24 06:09:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1597962,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-24/",
"name": "dt",
"value": "2025-10-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-25 06:11:07",
"last_data": "2025-10-25 06:11:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598196,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-25/",
"name": "dt",
"value": "2025-10-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-26 06:31:33",
"last_data": "2025-10-26 06:31:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598418,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-26/",
"name": "dt",
"value": "2025-10-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-27 06:08:44",
"last_data": "2025-10-27 06:08:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598663,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-27/",
"name": "dt",
"value": "2025-10-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-28 06:31:32",
"last_data": "2025-10-28 06:31:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1598895,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-28/",
"name": "dt",
"value": "2025-10-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-29 06:36:06",
"last_data": "2025-10-29 06:36:06"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599132,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-29/",
"name": "dt",
"value": "2025-10-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-30 06:08:29",
"last_data": "2025-10-30 06:08:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599369,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-30/",
"name": "dt",
"value": "2025-10-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-10-31 06:44:25",
"last_data": "2025-10-31 06:44:25"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1599611,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-10-31/",
"name": "dt",
"value": "2025-10-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-01 06:32:16",
"last_data": "2025-11-01 06:32:16"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600037,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-01/",
"name": "dt",
"value": "2025-11-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-02 06:11:08",
"last_data": "2025-11-02 06:11:08"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600272,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-02/",
"name": "dt",
"value": "2025-11-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-03 06:09:48",
"last_data": "2025-11-03 06:09:48"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600512,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-03/",
"name": "dt",
"value": "2025-11-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-04 06:09:02",
"last_data": "2025-11-04 06:09:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600757,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-04/",
"name": "dt",
"value": "2025-11-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-05 06:33:32",
"last_data": "2025-11-05 06:33:32"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1600990,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-05/",
"name": "dt",
"value": "2025-11-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-06 06:10:15",
"last_data": "2025-11-06 06:10:15"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601230,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-06/",
"name": "dt",
"value": "2025-11-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-07 06:31:36",
"last_data": "2025-11-07 06:31:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601492,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-07/",
"name": "dt",
"value": "2025-11-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-08 06:11:33",
"last_data": "2025-11-08 06:11:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601727,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-08/",
"name": "dt",
"value": "2025-11-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-09 06:35:39",
"last_data": "2025-11-09 06:35:39"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1601962,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-09/",
"name": "dt",
"value": "2025-11-09"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-10 06:13:57",
"last_data": "2025-11-10 06:13:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602199,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-10/",
"name": "dt",
"value": "2025-11-10"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-11 06:07:52",
"last_data": "2025-11-11 06:07:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602446,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-11/",
"name": "dt",
"value": "2025-11-11"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-12 07:16:33",
"last_data": "2025-11-12 07:16:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602676,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-12/",
"name": "dt",
"value": "2025-11-12"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-13 06:09:45",
"last_data": "2025-11-13 06:09:45"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1602912,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-13/",
"name": "dt",
"value": "2025-11-13"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-14 06:10:10",
"last_data": "2025-11-14 06:10:10"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1603143,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-14/",
"name": "dt",
"value": "2025-11-14"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-15 06:14:54",
"last_data": "2025-11-15 06:14:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1604789,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-15/",
"name": "dt",
"value": "2025-11-15"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-16 06:10:34",
"last_data": "2025-11-16 06:10:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1605802,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-16/",
"name": "dt",
"value": "2025-11-16"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-17 06:10:18",
"last_data": "2025-11-17 06:10:18"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606071,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-17/",
"name": "dt",
"value": "2025-11-17"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-18 06:08:57",
"last_data": "2025-11-18 06:08:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606304,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-18/",
"name": "dt",
"value": "2025-11-18"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-19 06:13:09",
"last_data": "2025-11-19 06:13:09"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606547,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-19/",
"name": "dt",
"value": "2025-11-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-20 06:11:57",
"last_data": "2025-11-20 06:11:57"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1606779,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-20/",
"name": "dt",
"value": "2025-11-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-21 06:09:14",
"last_data": "2025-11-21 06:09:14"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1607545,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-21/",
"name": "dt",
"value": "2025-11-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-22 06:11:19",
"last_data": "2025-11-22 06:11:19"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1607800,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-22/",
"name": "dt",
"value": "2025-11-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-23 06:06:40",
"last_data": "2025-11-23 06:06:40"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608028,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-23/",
"name": "dt",
"value": "2025-11-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-24 06:31:36",
"last_data": "2025-11-24 06:31:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608267,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-24/",
"name": "dt",
"value": "2025-11-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-25 06:09:00",
"last_data": "2025-11-25 06:09:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608501,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-25/",
"name": "dt",
"value": "2025-11-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-26 06:10:47",
"last_data": "2025-11-26 06:10:47"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608734,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-26/",
"name": "dt",
"value": "2025-11-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-27 06:07:11",
"last_data": "2025-11-27 06:07:11"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1608960,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-27/",
"name": "dt",
"value": "2025-11-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-28 06:06:53",
"last_data": "2025-11-28 06:06:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609193,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-28/",
"name": "dt",
"value": "2025-11-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-29 06:09:43",
"last_data": "2025-11-29 06:09:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609420,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-29/",
"name": "dt",
"value": "2025-11-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-11-30 06:08:29",
"last_data": "2025-11-30 06:08:29"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609652,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-11-30/",
"name": "dt",
"value": "2025-11-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-01 06:08:46",
"last_data": "2025-12-01 06:08:46"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1609899,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-01/",
"name": "dt",
"value": "2025-12-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-02 06:07:27",
"last_data": "2025-12-02 06:07:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610138,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-02/",
"name": "dt",
"value": "2025-12-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-03 06:11:21",
"last_data": "2025-12-03 06:11:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610382,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-03/",
"name": "dt",
"value": "2025-12-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-04 06:15:22",
"last_data": "2025-12-04 06:15:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1610614,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-04/",
"name": "dt",
"value": "2025-12-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-05 06:04:01",
"last_data": "2025-12-05 06:04:01"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611131,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-05/",
"name": "dt",
"value": "2025-12-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-06 06:10:36",
"last_data": "2025-12-06 06:10:36"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611362,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-06/",
"name": "dt",
"value": "2025-12-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-07 06:15:56",
"last_data": "2025-12-07 06:15:56"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611587,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-07/",
"name": "dt",
"value": "2025-12-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-08 06:09:07",
"last_data": "2025-12-08 06:09:07"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 1611825,
"location": "s3://sfdl-csv-talkdesk-prod/raw_incremental/calls/dt=2025-12-08/",
"name": "dt",
"value": "2025-12-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2025-12-09 06:07:17",
"last_data": "2025-12-09 06:07:17"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"Abandon_Time": "string",
"Agent_Disconnected": "string",
"CSAT_Score": "string",
"CSAT_Survey_Time": "string",
"Call_Id": "string",
"Callsid": "string",
"Contact_Phone_Number": "string",
"Data_Status__Valid___Damaged_": "string",
"Disposition_Code": "string",
"Disposition_Set": "string",
"End_At": "string",
"Handling_User_Email": "string",
"Handling_User_Id": "string",
"Handling_User_Name": "string",
"Hold_Time": "string",
"IVR_Options": "string",
"Is_Call_Forwarding": "string",
"Is_Callback_From_Queue": "string",
"Is_External_Transfer": "string",
"Is_If_No_Answer": "string",
"Is_In_Business_Hours": "string",
"Is_Transfer": "string",
"Nested_Disposition": "string",
"Notes": "string",
"Rating_Reason": "string",
"Recording_Url": "string",
"Ring_Groups": "string",
"Start_At": "string",
"Talk_Time": "string",
"Talkdesk_Phone_Display_Name": "string",
"Talkdesk_Phone_Number": "string",
"Team_Id": "string",
"Team_Name": "string",
"Total_Ringing_Time": "string",
"Total_Time": "string",
"Type": "string",
"User_Email": "string",
"User_Id": "string",
"User_Name": "string",
"User_Voice_Rating": "string",
"Wait_Time": "string"
},
"created": "2025-02-11 06:31:38",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_csv`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_csv.talkdesk_calls`\n(\n `Call_Id` string , `Callsid` string , `Type` string , `Start_At` string , `End_At` string , `Talkdesk_Phone_Number` string , `Talkdesk_Phone_Display_Name` string , `Contact_Phone_Number` string , `User_Id` string , `User_Name` string , `User_Email` string , `Total_Time` string , `Talk_Time` string , `Wait_Time` string , `Hold_Time` string , `Abandon_Time` string , `Total_Ringing_Time` string , `Disposition_Code` string , `Notes` string , `User_Voice_Rating` string , `Ring_Groups` string , `IVR_Options` string , `Is_In_Business_Hours` string , `Is_Callback_From_Queue` string , `Is_Transfer` string , `Handling_User_Id` string , `Handling_User_Name` string , `Handling_User_Email` string , `Recording_Url` string , `Is_External_Transfer` string , `Is_If_No_Answer` string , `Is_Call_Forwarding` string , `CSAT_Score` string , `CSAT_Survey_Time` string , `Team_Id` string , `Team_Name` string , `Rating_Reason` string , `Agent_Disconnected` string , `Data_Status__Valid___Damaged_` string , `Disposition_Set` string , `Nested_Disposition` 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-csv-talkdesk-prod/raw_incremental/calls'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_csv.talkdesk_calls`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_csv.talkdesk_calls"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}