Schema Info

Schema Name: sfdl_prod_drivethru.biadhocsftp_crm_call_data

created: 2025-12-02 16:22:14
disabled: False
format: raw
id: 4296
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_drivethru",
    "table": "biadhocsftp_crm_call_data"
}

type: drivethrucsv

Schema Versions: 8

Version 1619711

created: 2026-01-23 14:07:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `LOCATION_ID`  string , `LOCATION_ACTIVE`  string , `LOCATION_EMAIL`  string , `LOCATION_ADDRESS_1`  string , `LOCATION_ADDRESS_2`  string , `LOCATION_CITY`  string , `LOCATION_PROVINCE`  string , `LOCATION_POSTAL`  string , `LOCATION_COUNTRY`  string , `LOCATION_PHONE`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2026-01-23/1769198838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2026-01-23/1769198838
id: 1619711
processed: 1

raw_data:

{
    "ABANDONED_CALL": 15,
    "ACCOUNT_ID": 0,
    "ANSWERED_CALL": 14,
    "CALL_CATEGORY": 18,
    "INBOUND_CALL_ID": 13,
    "LOCATION_ACTIVE": 2,
    "LOCATION_ADDRESS_1": 4,
    "LOCATION_ADDRESS_2": 5,
    "LOCATION_CITY": 6,
    "LOCATION_COUNTRY": 9,
    "LOCATION_EMAIL": 3,
    "LOCATION_ID": 1,
    "LOCATION_PHONE": 10,
    "LOCATION_POSTAL": 8,
    "LOCATION_PROVINCE": 7,
    "TALK_TIME_SECS": 17,
    "TIMESTAMP_LOCAL": 12,
    "TIME_IN_QUEUE_SECS": 16,
    "ZONE_NAME": 11
}

schema_attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "DAY": "string",
    "INBOUND_CALL_ID": "string",
    "LOCATION_ACTIVE": "string",
    "LOCATION_ADDRESS_1": "string",
    "LOCATION_ADDRESS_2": "string",
    "LOCATION_CITY": "string",
    "LOCATION_COUNTRY": "string",
    "LOCATION_EMAIL": "string",
    "LOCATION_ID": "string",
    "LOCATION_IS_ACTIVE": "string",
    "LOCATION_NAME": "string",
    "LOCATION_PHONE": "string",
    "LOCATION_POSTAL": "string",
    "LOCATION_PROVINCE": "string",
    "NUM_ACTIVE_LEADS": "string",
    "NUM_AUTO_COMPLETED_FOLLOWUPS": "string",
    "NUM_CALLS": "string",
    "NUM_COLLECTIONS_COMPLETED": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_CALL": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_EMAIL": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_SMS": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL_SECS": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_EMAIL": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_SMS": "string",
    "NUM_COLLECTIONS_PROMISE_TO_PAY": "string",
    "NUM_COLLECTIONS_SKIPPED": "string",
    "NUM_COMPLETED_FOLLOWUPS": "string",
    "NUM_DELAYED_FOLLOWUPS": "string",
    "NUM_ERROR_COLLECTIONS": "string",
    "NUM_FOLLOWUP_TIME_TO_FIRST_EVENTS": "string",
    "NUM_FOLLOWUP_TIME_TO_FIRST_SECONDS": "string",
    "NUM_INBOUND_CALLS": "string",
    "NUM_INBOUND_COLLECTION_CALLS": "string",
    "NUM_LOST_LEADS": "string",
    "NUM_MANUAL_COMPLETED_FOLLOWUPS": "string",
    "NUM_OUTBOUND_CALLS": "string",
    "NUM_OUTSTANDING_COLLECTIONS": "string",
    "NUM_OUTSTANDING_FOLLOWUPS": "string",
    "NUM_PAYMENTS": "string",
    "NUM_PAYMENTS_AGENT": "string",
    "NUM_PAYMENTS_AUTO": "string",
    "NUM_PAYMENTS_SOURCE_CALL": "string",
    "NUM_PAYMENTS_SOURCE_EMAIL": "string",
    "NUM_PAYMENTS_SOURCE_EMPLOYEE": "string",
    "NUM_PAYMENTS_SOURCE_MOVEIN": "string",
    "NUM_PAYMENTS_SOURCE_SMS": "string",
    "NUM_RENTED_LEADS": "string",
    "NUM_TRANSFERRED_LEADS": "string",
    "NUM_UNPROCESSED_CALLS": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "TOTAL_PAYMENT_AMOUNT": "string",
    "TOTAL_PAYMENT_AMOUNT_SOURCE_MOVEIN": "string",
    "ZONE_NAME": "string"
}

schema_name_id: 4296
schema_scan_id: 157538016
updated: 2026-01-23 14:07:51

Version 1619708

created: 2026-01-23 14:04:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `LOCATION_EMAIL`  string , `LOCATION_ADDRESS_1`  string , `LOCATION_ADDRESS_2`  string , `LOCATION_CITY`  string , `LOCATION_PROVINCE`  string , `LOCATION_POSTAL`  string , `LOCATION_COUNTRY`  string , `LOCATION_PHONE`  string , `ACCOUNT_ID`  string , `LOCATION_ID`  string , `LOCATION_NAME`  string , `LOCATION_IS_ACTIVE`  string , `DAY`  string , `NUM_CALLS`  string , `NUM_UNPROCESSED_CALLS`  string , `NUM_INBOUND_CALLS`  string , `NUM_OUTBOUND_CALLS`  string , `NUM_INBOUND_COLLECTION_CALLS`  string , `NUM_ACTIVE_LEADS`  string , `NUM_RENTED_LEADS`  string , `NUM_LOST_LEADS`  string , `NUM_TRANSFERRED_LEADS`  string , `NUM_OUTSTANDING_COLLECTIONS`  string , `NUM_ERROR_COLLECTIONS`  string , `NUM_OUTSTANDING_FOLLOWUPS`  string , `NUM_COLLECTIONS_SKIPPED`  string , `NUM_COLLECTIONS_PROMISE_TO_PAY`  string , `NUM_COLLECTIONS_COMPLETED`  string , `NUM_COLLECTIONS_COMPLETED_AUTO_CALL`  string , `NUM_COLLECTIONS_COMPLETED_AUTO_SMS`  string , `NUM_COLLECTIONS_COMPLETED_AUTO_EMAIL`  string , `NUM_COLLECTIONS_COMPLETED_MANUAL_CALL`  string , `NUM_COLLECTIONS_COMPLETED_MANUAL_SMS`  string , `NUM_COLLECTIONS_COMPLETED_MANUAL_EMAIL`  string , `NUM_COLLECTIONS_COMPLETED_MANUAL_CALL_SECS`  string , `NUM_DELAYED_FOLLOWUPS`  string , `NUM_COMPLETED_FOLLOWUPS`  string , `NUM_MANUAL_COMPLETED_FOLLOWUPS`  string , `NUM_AUTO_COMPLETED_FOLLOWUPS`  string , `NUM_FOLLOWUP_TIME_TO_FIRST_SECONDS`  string , `NUM_FOLLOWUP_TIME_TO_FIRST_EVENTS`  string , `NUM_PAYMENTS`  string , `TOTAL_PAYMENT_AMOUNT`  string , `NUM_PAYMENTS_AUTO`  string , `NUM_PAYMENTS_AGENT`  string , `NUM_PAYMENTS_SOURCE_SMS`  string , `NUM_PAYMENTS_SOURCE_EMAIL`  string , `NUM_PAYMENTS_SOURCE_EMPLOYEE`  string , `NUM_PAYMENTS_SOURCE_CALL`  string , `NUM_PAYMENTS_SOURCE_MOVEIN`  string , `TOTAL_PAYMENT_AMOUNT_SOURCE_MOVEIN`  string \n)\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/biadhocsftp_crm_call_data/2026-01-23/1769198518'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2026-01-23/1769198518
id: 1619708
processed: 1

raw_data:

{
    "ACCOUNT_ID": 8,
    "DAY": 12,
    "LOCATION_ADDRESS_1": 1,
    "LOCATION_ADDRESS_2": 2,
    "LOCATION_CITY": 3,
    "LOCATION_COUNTRY": 6,
    "LOCATION_EMAIL": 0,
    "LOCATION_ID": 9,
    "LOCATION_IS_ACTIVE": 11,
    "LOCATION_NAME": 10,
    "LOCATION_PHONE": 7,
    "LOCATION_POSTAL": 5,
    "LOCATION_PROVINCE": 4,
    "NUM_ACTIVE_LEADS": 18,
    "NUM_AUTO_COMPLETED_FOLLOWUPS": 38,
    "NUM_CALLS": 13,
    "NUM_COLLECTIONS_COMPLETED": 27,
    "NUM_COLLECTIONS_COMPLETED_AUTO_CALL": 28,
    "NUM_COLLECTIONS_COMPLETED_AUTO_EMAIL": 30,
    "NUM_COLLECTIONS_COMPLETED_AUTO_SMS": 29,
    "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL": 31,
    "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL_SECS": 34,
    "NUM_COLLECTIONS_COMPLETED_MANUAL_EMAIL": 33,
    "NUM_COLLECTIONS_COMPLETED_MANUAL_SMS": 32,
    "NUM_COLLECTIONS_PROMISE_TO_PAY": 26,
    "NUM_COLLECTIONS_SKIPPED": 25,
    "NUM_COMPLETED_FOLLOWUPS": 36,
    "NUM_DELAYED_FOLLOWUPS": 35,
    "NUM_ERROR_COLLECTIONS": 23,
    "NUM_FOLLOWUP_TIME_TO_FIRST_EVENTS": 40,
    "NUM_FOLLOWUP_TIME_TO_FIRST_SECONDS": 39,
    "NUM_INBOUND_CALLS": 15,
    "NUM_INBOUND_COLLECTION_CALLS": 17,
    "NUM_LOST_LEADS": 20,
    "NUM_MANUAL_COMPLETED_FOLLOWUPS": 37,
    "NUM_OUTBOUND_CALLS": 16,
    "NUM_OUTSTANDING_COLLECTIONS": 22,
    "NUM_OUTSTANDING_FOLLOWUPS": 24,
    "NUM_PAYMENTS": 41,
    "NUM_PAYMENTS_AGENT": 44,
    "NUM_PAYMENTS_AUTO": 43,
    "NUM_PAYMENTS_SOURCE_CALL": 48,
    "NUM_PAYMENTS_SOURCE_EMAIL": 46,
    "NUM_PAYMENTS_SOURCE_EMPLOYEE": 47,
    "NUM_PAYMENTS_SOURCE_MOVEIN": 49,
    "NUM_PAYMENTS_SOURCE_SMS": 45,
    "NUM_RENTED_LEADS": 19,
    "NUM_TRANSFERRED_LEADS": 21,
    "NUM_UNPROCESSED_CALLS": 14,
    "TOTAL_PAYMENT_AMOUNT": 42,
    "TOTAL_PAYMENT_AMOUNT_SOURCE_MOVEIN": 50
}

schema_attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "DAY": "string",
    "INBOUND_CALL_ID": "string",
    "LOCATION_ACTIVE": "string",
    "LOCATION_ADDRESS_1": "string",
    "LOCATION_ADDRESS_2": "string",
    "LOCATION_CITY": "string",
    "LOCATION_COUNTRY": "string",
    "LOCATION_EMAIL": "string",
    "LOCATION_ID": "string",
    "LOCATION_IS_ACTIVE": "string",
    "LOCATION_NAME": "string",
    "LOCATION_PHONE": "string",
    "LOCATION_POSTAL": "string",
    "LOCATION_PROVINCE": "string",
    "NUM_ACTIVE_LEADS": "string",
    "NUM_AUTO_COMPLETED_FOLLOWUPS": "string",
    "NUM_CALLS": "string",
    "NUM_COLLECTIONS_COMPLETED": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_CALL": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_EMAIL": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_SMS": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL_SECS": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_EMAIL": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_SMS": "string",
    "NUM_COLLECTIONS_PROMISE_TO_PAY": "string",
    "NUM_COLLECTIONS_SKIPPED": "string",
    "NUM_COMPLETED_FOLLOWUPS": "string",
    "NUM_DELAYED_FOLLOWUPS": "string",
    "NUM_ERROR_COLLECTIONS": "string",
    "NUM_FOLLOWUP_TIME_TO_FIRST_EVENTS": "string",
    "NUM_FOLLOWUP_TIME_TO_FIRST_SECONDS": "string",
    "NUM_INBOUND_CALLS": "string",
    "NUM_INBOUND_COLLECTION_CALLS": "string",
    "NUM_LOST_LEADS": "string",
    "NUM_MANUAL_COMPLETED_FOLLOWUPS": "string",
    "NUM_OUTBOUND_CALLS": "string",
    "NUM_OUTSTANDING_COLLECTIONS": "string",
    "NUM_OUTSTANDING_FOLLOWUPS": "string",
    "NUM_PAYMENTS": "string",
    "NUM_PAYMENTS_AGENT": "string",
    "NUM_PAYMENTS_AUTO": "string",
    "NUM_PAYMENTS_SOURCE_CALL": "string",
    "NUM_PAYMENTS_SOURCE_EMAIL": "string",
    "NUM_PAYMENTS_SOURCE_EMPLOYEE": "string",
    "NUM_PAYMENTS_SOURCE_MOVEIN": "string",
    "NUM_PAYMENTS_SOURCE_SMS": "string",
    "NUM_RENTED_LEADS": "string",
    "NUM_TRANSFERRED_LEADS": "string",
    "NUM_UNPROCESSED_CALLS": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "TOTAL_PAYMENT_AMOUNT": "string",
    "TOTAL_PAYMENT_AMOUNT_SOURCE_MOVEIN": "string",
    "ZONE_NAME": "string"
}

schema_name_id: 4296
schema_scan_id: 157537858
updated: 2026-01-23 14:04:40

Version 1619657

created: 2026-01-23 10:05:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `LOCATION_ID`  string , `LOCATION_ACTIVE`  string , `LOCATION_EMAIL`  string , `LOCATION_ADDRESS_1`  string , `LOCATION_ADDRESS_2`  string , `LOCATION_CITY`  string , `LOCATION_PROVINCE`  string , `LOCATION_POSTAL`  string , `LOCATION_COUNTRY`  string , `LOCATION_PHONE`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2026-01-23/1769184282'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2026-01-23/1769184282
id: 1619657
processed: 1

raw_data:

{
    "ABANDONED_CALL": 15,
    "ACCOUNT_ID": 0,
    "ANSWERED_CALL": 14,
    "CALL_CATEGORY": 18,
    "INBOUND_CALL_ID": 13,
    "LOCATION_ACTIVE": 2,
    "LOCATION_ADDRESS_1": 4,
    "LOCATION_ADDRESS_2": 5,
    "LOCATION_CITY": 6,
    "LOCATION_COUNTRY": 9,
    "LOCATION_EMAIL": 3,
    "LOCATION_ID": 1,
    "LOCATION_PHONE": 10,
    "LOCATION_POSTAL": 8,
    "LOCATION_PROVINCE": 7,
    "TALK_TIME_SECS": 17,
    "TIMESTAMP_LOCAL": 12,
    "TIME_IN_QUEUE_SECS": 16,
    "ZONE_NAME": 11
}

schema_attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "INBOUND_CALL_ID": "string",
    "LOCATION_ACTIVE": "string",
    "LOCATION_ADDRESS_1": "string",
    "LOCATION_ADDRESS_2": "string",
    "LOCATION_CITY": "string",
    "LOCATION_COUNTRY": "string",
    "LOCATION_EMAIL": "string",
    "LOCATION_ID": "string",
    "LOCATION_PHONE": "string",
    "LOCATION_POSTAL": "string",
    "LOCATION_PROVINCE": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "ZONE_NAME": "string"
}

schema_name_id: 4296
schema_scan_id: 157525558
updated: 2026-01-23 10:05:19

Version 1563908

created: 2025-12-05 11:54:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `LOCATION_ID`  string , `LOCATION_ACTIVE`  string , `LOCATION_EMAIL`  string , `LOCATION_ADDRESS_1`  string , `LOCATION_ADDRESS_2`  string , `LOCATION_CITY`  string , `LOCATION_PROVINCE`  string , `LOCATION_POSTAL`  string , `LOCATION_COUNTRY`  string , `LOCATION_PHONE`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2025-12-05/1764955986'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-05/1764955986
id: 1563908
processed: 1

raw_data:

{
    "ABANDONED_CALL": 15,
    "ACCOUNT_ID": 0,
    "ANSWERED_CALL": 14,
    "CALL_CATEGORY": 18,
    "INBOUND_CALL_ID": 13,
    "LOCATION_ACTIVE": 2,
    "LOCATION_ADDRESS_1": 4,
    "LOCATION_ADDRESS_2": 5,
    "LOCATION_CITY": 6,
    "LOCATION_COUNTRY": 9,
    "LOCATION_EMAIL": 3,
    "LOCATION_ID": 1,
    "LOCATION_PHONE": 10,
    "LOCATION_POSTAL": 8,
    "LOCATION_PROVINCE": 7,
    "TALK_TIME_SECS": 17,
    "TIMESTAMP_LOCAL": 12,
    "TIME_IN_QUEUE_SECS": 16,
    "ZONE_NAME": 11
}

schema_attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "INBOUND_CALL_ID": "string",
    "LOCATION_ACTIVE": "string",
    "LOCATION_ADDRESS_1": "string",
    "LOCATION_ADDRESS_2": "string",
    "LOCATION_CITY": "string",
    "LOCATION_COUNTRY": "string",
    "LOCATION_EMAIL": "string",
    "LOCATION_ID": "string",
    "LOCATION_PHONE": "string",
    "LOCATION_POSTAL": "string",
    "LOCATION_PROVINCE": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "ZONE_NAME": "string"
}

schema_name_id: 4296
schema_scan_id: 154895759
updated: 2025-12-05 11:54:14

Version 1563905

created: 2025-12-05 11:51:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `LOCATION_ID`  string , `LOCATION_ACTIVE`  string , `LOCATION_EMAIL`  string , `LOCATION_ADDRESS_1`  string , `LOCATION_ADDRESS_2`  string , `LOCATION_CITY`  string , `LOCATION_PROVINCE`  string , `LOCATION_POSTAL`  string , `LOCATION_COUNTRY`  string , `LOCATION_PHONE`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2025-12-05/1764956788'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-05/1764956788
id: 1563905
processed: 1

raw_data:

{
    "ABANDONED_CALL": 15,
    "ACCOUNT_ID": 0,
    "ANSWERED_CALL": 14,
    "CALL_CATEGORY": 18,
    "INBOUND_CALL_ID": 13,
    "LOCATION_ACTIVE": 2,
    "LOCATION_ADDRESS_1": 4,
    "LOCATION_ADDRESS_2": 5,
    "LOCATION_CITY": 6,
    "LOCATION_COUNTRY": 9,
    "LOCATION_EMAIL": 3,
    "LOCATION_ID": 1,
    "LOCATION_PHONE": 10,
    "LOCATION_POSTAL": 8,
    "LOCATION_PROVINCE": 7,
    "TALK_TIME_SECS": 17,
    "TIMESTAMP_LOCAL": 12,
    "TIME_IN_QUEUE_SECS": 16,
    "ZONE_NAME": 11
}

schema_attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "INBOUND_CALL_ID": "string",
    "LOCATION_ACTIVE": "string",
    "LOCATION_ADDRESS_1": "string",
    "LOCATION_ADDRESS_2": "string",
    "LOCATION_CITY": "string",
    "LOCATION_COUNTRY": "string",
    "LOCATION_EMAIL": "string",
    "LOCATION_ID": "string",
    "LOCATION_PHONE": "string",
    "LOCATION_POSTAL": "string",
    "LOCATION_PROVINCE": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "ZONE_NAME": "string"
}

schema_name_id: 4296
schema_scan_id: 154895662
updated: 2025-12-05 11:51:51

Version 1562764

created: 2025-12-04 11:35:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `LOCATION_ID`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2025-12-04/1764868773'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-04/1764868773
id: 1562764
processed: 1

raw_data:

{
    "ABANDONED_CALL": 6,
    "ACCOUNT_ID": 0,
    "ANSWERED_CALL": 5,
    "CALL_CATEGORY": 9,
    "INBOUND_CALL_ID": 4,
    "LOCATION_ID": 1,
    "TALK_TIME_SECS": 8,
    "TIMESTAMP_LOCAL": 3,
    "TIME_IN_QUEUE_SECS": 7,
    "ZONE_NAME": 2
}

schema_attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "INBOUND_CALL_ID": "string",
    "LOCATION_ID": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "ZONE_NAME": "string"
}

schema_name_id: 4296
schema_scan_id: 154836042
updated: 2025-12-04 11:35:51

Version 1562761

created: 2025-12-04 11:27:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `LOCATION_ID`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2025-12-04/1764868077'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-04/1764868077
id: 1562761
processed: 1

raw_data:

{
    "ABANDONED_CALL": 6,
    "ACCOUNT_ID": 0,
    "ANSWERED_CALL": 5,
    "CALL_CATEGORY": 9,
    "INBOUND_CALL_ID": 4,
    "LOCATION_ID": 1,
    "TALK_TIME_SECS": 8,
    "TIMESTAMP_LOCAL": 3,
    "TIME_IN_QUEUE_SECS": 7,
    "ZONE_NAME": 2
}

schema_attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "INBOUND_CALL_ID": "string",
    "LOCATION_ID": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "ZONE_NAME": "string"
}

schema_name_id: 4296
schema_scan_id: 154836028
updated: 2025-12-04 11:27:23

Version 1560620

created: 2025-12-02 16:22:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2025-12-02/1764713989'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-02/1764713989
id: 1560620
processed: 1

raw_data:

{
    "ABANDONED_CALL": 5,
    "ACCOUNT_ID": 0,
    "ANSWERED_CALL": 4,
    "CALL_CATEGORY": 8,
    "INBOUND_CALL_ID": 3,
    "TALK_TIME_SECS": 7,
    "TIMESTAMP_LOCAL": 2,
    "TIME_IN_QUEUE_SECS": 6,
    "ZONE_NAME": 1
}

schema_attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "INBOUND_CALL_ID": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "ZONE_NAME": "string"
}

schema_name_id: 4296
schema_scan_id: 154730332
updated: 2025-12-02 16:22:29

Schema Scans: 8

Last at 2026-01-23 14:07:38

Scan 157538016

duration: 0:00:12.846608

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 157538016

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2026-01-23/1769198838",
        "key": "raw/biadhocsftp_crm_call_data/2026-01-23/1769198838/crm_calldata_output123.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.biadhocsftp_crm_call_data",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1286526204684004963,
        "service_name": "drive-thru",
        "span_id": 12834233527989562807,
        "trace_id": 12892873726125822023
    }
}

running: False
schema_name_id: 4296
start_time: 2026-01-23 14:07:38
success: True
trace_id: 12892873726125822023

Scan 157537858

duration: 0:00:13.246276

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 157537858

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2026-01-23/1769198518",
        "key": "raw/biadhocsftp_crm_call_data/2026-01-23/1769198518/collections_raw_output123.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.biadhocsftp_crm_call_data",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6193093595809178454,
        "service_name": "drive-thru",
        "span_id": 18037867620394082123,
        "trace_id": 15833725736928591173
    }
}

running: False
schema_name_id: 4296
start_time: 2026-01-23 14:04:27
success: True
trace_id: 15833725736928591173

Scan 157525558

duration: 0:00:14.832891

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 157525558

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2026-01-23/1769184282",
        "key": "raw/biadhocsftp_crm_call_data/2026-01-23/1769184282/crm_calldata_output123.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.biadhocsftp_crm_call_data",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16653357808057470436,
        "service_name": "drive-thru",
        "span_id": 10221469878853140230,
        "trace_id": 7129907031271397997
    }
}

running: False
schema_name_id: 4296
start_time: 2026-01-23 10:05:04
success: True
trace_id: 7129907031271397997

Scan 154895759

duration: 0:00:12.459784

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 154895759

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-05/1764955986",
        "key": "raw/biadhocsftp_crm_call_data/2025-12-05/1764955986/crm_call_data_cleaned.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.biadhocsftp_crm_call_data",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12279073017846821624,
        "service_name": "drive-thru",
        "span_id": 17457075281802519137,
        "trace_id": 12481575414053820308
    }
}

running: False
schema_name_id: 4296
start_time: 2025-12-05 11:54:01
success: True
trace_id: 12481575414053820308

Scan 154895662

duration: 0:00:12.400136

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 154895662

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-05/1764956788",
        "key": "raw/biadhocsftp_crm_call_data/2025-12-05/1764956788/crm_call_data_cleaned.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.biadhocsftp_crm_call_data",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4434516858253680728,
        "service_name": "drive-thru",
        "span_id": 9329398433299474357,
        "trace_id": 15462946896536298911
    }
}

running: False
schema_name_id: 4296
start_time: 2025-12-05 11:51:38
success: True
trace_id: 15462946896536298911

Scan 154836042

duration: 0:00:12.146409

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 154836042

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-04/1764868773",
        "key": "raw/biadhocsftp_crm_call_data/2025-12-04/1764868773/crm_call_data_cleaned.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.biadhocsftp_crm_call_data",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6283880995918121229,
        "service_name": "drive-thru",
        "span_id": 10969764257533952255,
        "trace_id": 17151784208472923324
    }
}

running: False
schema_name_id: 4296
start_time: 2025-12-04 11:35:39
success: True
trace_id: 17151784208472923324

Scan 154836028

duration: 0:00:14.641045

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 154836028

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-04/1764868077",
        "key": "raw/biadhocsftp_crm_call_data/2025-12-04/1764868077/crm_call_data_cleaned.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.biadhocsftp_crm_call_data",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16779765222121508285,
        "service_name": "drive-thru",
        "span_id": 14256109373662506254,
        "trace_id": 4537998766220709159
    }
}

running: False
schema_name_id: 4296
start_time: 2025-12-04 11:27:09
success: True
trace_id: 4537998766220709159

Scan 154730332

duration: 0:00:14.835112

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 154730332

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/biadhocsftp_crm_call_data/2025-12-02/1764713989",
        "key": "raw/biadhocsftp_crm_call_data/2025-12-02/1764713989/crm_calldata_cleaned.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.biadhocsftp_crm_call_data",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2222277451488414232,
        "service_name": "drive-thru",
        "span_id": 3891545930001617892,
        "trace_id": 7535489961778290264
    }
}

running: False
schema_name_id: 4296
start_time: 2025-12-02 16:22:14
success: True
trace_id: 7535489961778290264

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "ABANDONED_CALL": "string",
    "ACCOUNT_ID": "string",
    "ANSWERED_CALL": "string",
    "CALL_CATEGORY": "string",
    "DAY": "string",
    "INBOUND_CALL_ID": "string",
    "LOCATION_ACTIVE": "string",
    "LOCATION_ADDRESS_1": "string",
    "LOCATION_ADDRESS_2": "string",
    "LOCATION_CITY": "string",
    "LOCATION_COUNTRY": "string",
    "LOCATION_EMAIL": "string",
    "LOCATION_ID": "string",
    "LOCATION_IS_ACTIVE": "string",
    "LOCATION_NAME": "string",
    "LOCATION_PHONE": "string",
    "LOCATION_POSTAL": "string",
    "LOCATION_PROVINCE": "string",
    "NUM_ACTIVE_LEADS": "string",
    "NUM_AUTO_COMPLETED_FOLLOWUPS": "string",
    "NUM_CALLS": "string",
    "NUM_COLLECTIONS_COMPLETED": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_CALL": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_EMAIL": "string",
    "NUM_COLLECTIONS_COMPLETED_AUTO_SMS": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL_SECS": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_EMAIL": "string",
    "NUM_COLLECTIONS_COMPLETED_MANUAL_SMS": "string",
    "NUM_COLLECTIONS_PROMISE_TO_PAY": "string",
    "NUM_COLLECTIONS_SKIPPED": "string",
    "NUM_COMPLETED_FOLLOWUPS": "string",
    "NUM_DELAYED_FOLLOWUPS": "string",
    "NUM_ERROR_COLLECTIONS": "string",
    "NUM_FOLLOWUP_TIME_TO_FIRST_EVENTS": "string",
    "NUM_FOLLOWUP_TIME_TO_FIRST_SECONDS": "string",
    "NUM_INBOUND_CALLS": "string",
    "NUM_INBOUND_COLLECTION_CALLS": "string",
    "NUM_LOST_LEADS": "string",
    "NUM_MANUAL_COMPLETED_FOLLOWUPS": "string",
    "NUM_OUTBOUND_CALLS": "string",
    "NUM_OUTSTANDING_COLLECTIONS": "string",
    "NUM_OUTSTANDING_FOLLOWUPS": "string",
    "NUM_PAYMENTS": "string",
    "NUM_PAYMENTS_AGENT": "string",
    "NUM_PAYMENTS_AUTO": "string",
    "NUM_PAYMENTS_SOURCE_CALL": "string",
    "NUM_PAYMENTS_SOURCE_EMAIL": "string",
    "NUM_PAYMENTS_SOURCE_EMPLOYEE": "string",
    "NUM_PAYMENTS_SOURCE_MOVEIN": "string",
    "NUM_PAYMENTS_SOURCE_SMS": "string",
    "NUM_RENTED_LEADS": "string",
    "NUM_TRANSFERRED_LEADS": "string",
    "NUM_UNPROCESSED_CALLS": "string",
    "TALK_TIME_SECS": "string",
    "TIMESTAMP_LOCAL": "string",
    "TIME_IN_QUEUE_SECS": "string",
    "TOTAL_PAYMENT_AMOUNT": "string",
    "TOTAL_PAYMENT_AMOUNT_SOURCE_MOVEIN": "string",
    "ZONE_NAME": "string"
}

created: 2026-01-23 14:07:40

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `LOCATION_ID`  string , `LOCATION_ACTIVE`  string , `LOCATION_EMAIL`  string , `LOCATION_ADDRESS_1`  string , `LOCATION_ADDRESS_2`  string , `LOCATION_CITY`  string , `LOCATION_PROVINCE`  string , `LOCATION_POSTAL`  string , `LOCATION_COUNTRY`  string , `LOCATION_PHONE`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2026-01-23/1769198838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2025-12-02 16:22:14",
        "disabled": false,
        "format": "raw",
        "id": 4296,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "biadhocsftp_crm_call_data"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "ABANDONED_CALL": "string",
            "ACCOUNT_ID": "string",
            "ANSWERED_CALL": "string",
            "CALL_CATEGORY": "string",
            "DAY": "string",
            "INBOUND_CALL_ID": "string",
            "LOCATION_ACTIVE": "string",
            "LOCATION_ADDRESS_1": "string",
            "LOCATION_ADDRESS_2": "string",
            "LOCATION_CITY": "string",
            "LOCATION_COUNTRY": "string",
            "LOCATION_EMAIL": "string",
            "LOCATION_ID": "string",
            "LOCATION_IS_ACTIVE": "string",
            "LOCATION_NAME": "string",
            "LOCATION_PHONE": "string",
            "LOCATION_POSTAL": "string",
            "LOCATION_PROVINCE": "string",
            "NUM_ACTIVE_LEADS": "string",
            "NUM_AUTO_COMPLETED_FOLLOWUPS": "string",
            "NUM_CALLS": "string",
            "NUM_COLLECTIONS_COMPLETED": "string",
            "NUM_COLLECTIONS_COMPLETED_AUTO_CALL": "string",
            "NUM_COLLECTIONS_COMPLETED_AUTO_EMAIL": "string",
            "NUM_COLLECTIONS_COMPLETED_AUTO_SMS": "string",
            "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL": "string",
            "NUM_COLLECTIONS_COMPLETED_MANUAL_CALL_SECS": "string",
            "NUM_COLLECTIONS_COMPLETED_MANUAL_EMAIL": "string",
            "NUM_COLLECTIONS_COMPLETED_MANUAL_SMS": "string",
            "NUM_COLLECTIONS_PROMISE_TO_PAY": "string",
            "NUM_COLLECTIONS_SKIPPED": "string",
            "NUM_COMPLETED_FOLLOWUPS": "string",
            "NUM_DELAYED_FOLLOWUPS": "string",
            "NUM_ERROR_COLLECTIONS": "string",
            "NUM_FOLLOWUP_TIME_TO_FIRST_EVENTS": "string",
            "NUM_FOLLOWUP_TIME_TO_FIRST_SECONDS": "string",
            "NUM_INBOUND_CALLS": "string",
            "NUM_INBOUND_COLLECTION_CALLS": "string",
            "NUM_LOST_LEADS": "string",
            "NUM_MANUAL_COMPLETED_FOLLOWUPS": "string",
            "NUM_OUTBOUND_CALLS": "string",
            "NUM_OUTSTANDING_COLLECTIONS": "string",
            "NUM_OUTSTANDING_FOLLOWUPS": "string",
            "NUM_PAYMENTS": "string",
            "NUM_PAYMENTS_AGENT": "string",
            "NUM_PAYMENTS_AUTO": "string",
            "NUM_PAYMENTS_SOURCE_CALL": "string",
            "NUM_PAYMENTS_SOURCE_EMAIL": "string",
            "NUM_PAYMENTS_SOURCE_EMPLOYEE": "string",
            "NUM_PAYMENTS_SOURCE_MOVEIN": "string",
            "NUM_PAYMENTS_SOURCE_SMS": "string",
            "NUM_RENTED_LEADS": "string",
            "NUM_TRANSFERRED_LEADS": "string",
            "NUM_UNPROCESSED_CALLS": "string",
            "TALK_TIME_SECS": "string",
            "TIMESTAMP_LOCAL": "string",
            "TIME_IN_QUEUE_SECS": "string",
            "TOTAL_PAYMENT_AMOUNT": "string",
            "TOTAL_PAYMENT_AMOUNT_SOURCE_MOVEIN": "string",
            "ZONE_NAME": "string"
        },
        "created": "2026-01-23 14:07:40",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.biadhocsftp_crm_call_data`\n(\n `ACCOUNT_ID`  string , `LOCATION_ID`  string , `LOCATION_ACTIVE`  string , `LOCATION_EMAIL`  string , `LOCATION_ADDRESS_1`  string , `LOCATION_ADDRESS_2`  string , `LOCATION_CITY`  string , `LOCATION_PROVINCE`  string , `LOCATION_POSTAL`  string , `LOCATION_COUNTRY`  string , `LOCATION_PHONE`  string , `ZONE_NAME`  string , `TIMESTAMP_LOCAL`  string , `INBOUND_CALL_ID`  string , `ANSWERED_CALL`  string , `ABANDONED_CALL`  string , `TIME_IN_QUEUE_SECS`  string , `TALK_TIME_SECS`  string , `CALL_CATEGORY`  string \n)\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/biadhocsftp_crm_call_data/2026-01-23/1769198838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.biadhocsftp_crm_call_data`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.biadhocsftp_crm_call_data"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}