Schema Info

Schema Name: sfdl_prod_drivethru.molo_moloxerophoneset

created: 2023-10-17 02:00:14
disabled: False
format: raw
id: 1738
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717829

created: 2026-04-17 03:13:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-17/1776413278'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-17/1776413278
id: 1717829
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 162167866
updated: 2026-04-17 03:13:58

Version 1716595

created: 2026-04-16 03:15:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-16/1776326754'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-16/1776326754
id: 1716595
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 162112059
updated: 2026-04-16 03:15:25

Version 1715357

created: 2026-04-15 03:12:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-15/1776240217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-15/1776240217
id: 1715357
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 162056157
updated: 2026-04-15 03:12:17

Version 1714151

created: 2026-04-14 03:11:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-14/1776154179'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-14/1776154179
id: 1714151
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 162000671
updated: 2026-04-14 03:11:30

Version 1712957

created: 2026-04-13 03:06:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-13/1776067172'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-13/1776067172
id: 1712957
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161942763
updated: 2026-04-13 03:06:33

Version 1711721

created: 2026-04-12 03:06:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-12/1775980874'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-12/1775980874
id: 1711721
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161893391
updated: 2026-04-12 03:06:53

Version 1710511

created: 2026-04-11 03:08:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-11/1775894653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-11/1775894653
id: 1710511
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161841300
updated: 2026-04-11 03:08:55

Version 1709422

created: 2026-04-10 03:13:07

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-10/1775808406'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-10/1775808406
id: 1709422
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161786129
updated: 2026-04-10 03:13:19

Version 1708219

created: 2026-04-09 03:07:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-09/1775721736'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-09/1775721736
id: 1708219
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161730474
updated: 2026-04-09 03:07:53

Version 1706971

created: 2026-04-08 03:08:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-08/1775635564'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-08/1775635564
id: 1706971
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161675628
updated: 2026-04-08 03:08:36

Version 1705834

created: 2026-04-07 03:02:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-07/1775548724'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-07/1775548724
id: 1705834
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161619297
updated: 2026-04-07 03:02:58

Version 1704576

created: 2026-04-06 03:09:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-06/1775462677'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-06/1775462677
id: 1704576
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161561705
updated: 2026-04-06 03:09:29

Version 1703447

created: 2026-04-05 03:10:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-05/1775376305'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-05/1775376305
id: 1703447
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161515037
updated: 2026-04-05 03:11:03

Version 1702302

created: 2026-04-04 03:12:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-04/1775289791'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-04/1775289791
id: 1702302
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161460631
updated: 2026-04-04 03:12:22

Version 1701098

created: 2026-04-03 03:21:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-03/1775203554'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/molo_moloXeroPhoneSet/2026-04-03/1775203554
id: 1701098
processed: 1

raw_data:

{
    "Id": 0,
    "PhoneAreaCode": 2,
    "PhoneCountryCode": 3,
    "PhoneNumber": 1,
    "XeroContact_Id": 6,
    "XeroOrganizationId": 4,
    "XeroPhoneType_Id": 5
}

schema_attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

schema_name_id: 1738
schema_scan_id: 161402101
updated: 2026-04-03 03:21:26

Schema Scans: 15

Last at 2026-04-17 03:13:43

Scan 162167866

duration: 0:00:14.364759

exit_message:

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

id: 162167866

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/molo_moloXeroPhoneSet/2026-04-17/1776413278",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-17/1776413278/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16088971805098203479,
        "service_name": "drive-thru",
        "span_id": 11169217836882677022,
        "trace_id": 14760224766803310111
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-17 03:13:43
success: True
trace_id: 14760224766803310111

Scan 162112059

duration: 0:00:14.355479

exit_message:

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

id: 162112059

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/molo_moloXeroPhoneSet/2026-04-16/1776326754",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-16/1776326754/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10368278475709394036,
        "service_name": "drive-thru",
        "span_id": 14467286888896407201,
        "trace_id": 6153498027786405713
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-16 03:15:11
success: True
trace_id: 6153498027786405713

Scan 162056157

duration: 0:00:14.385887

exit_message:

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

id: 162056157

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/molo_moloXeroPhoneSet/2026-04-15/1776240217",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-15/1776240217/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8866479821343260948,
        "service_name": "drive-thru",
        "span_id": 15482853998687297246,
        "trace_id": 16458223812016585358
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-15 03:12:03
success: True
trace_id: 16458223812016585358

Scan 162000671

duration: 0:00:11.818967

exit_message:

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

id: 162000671

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/molo_moloXeroPhoneSet/2026-04-14/1776154179",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-14/1776154179/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6640163410019457531,
        "service_name": "drive-thru",
        "span_id": 5021946288927544944,
        "trace_id": 16446434524475232586
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-14 03:11:18
success: True
trace_id: 16446434524475232586

Scan 161942763

duration: 0:00:11.765696

exit_message:

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

id: 161942763

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/molo_moloXeroPhoneSet/2026-04-13/1776067172",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-13/1776067172/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 616972978496030733,
        "service_name": "drive-thru",
        "span_id": 16727095822739161652,
        "trace_id": 14794810791047543345
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-13 03:06:21
success: True
trace_id: 14794810791047543345

Scan 161893391

duration: 0:00:14.289757

exit_message:

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

id: 161893391

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/molo_moloXeroPhoneSet/2026-04-12/1775980874",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-12/1775980874/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4884777778964173475,
        "service_name": "drive-thru",
        "span_id": 2094708472614807993,
        "trace_id": 4816316313297580003
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-12 03:06:39
success: True
trace_id: 4816316313297580003

Scan 161841300

duration: 0:00:11.716167

exit_message:

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

id: 161841300

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/molo_moloXeroPhoneSet/2026-04-11/1775894653",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-11/1775894653/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14010627128917888488,
        "service_name": "drive-thru",
        "span_id": 6621380332151074967,
        "trace_id": 4902549322458114473
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-11 03:08:43
success: True
trace_id: 4902549322458114473

Scan 161786129

duration: 0:00:12.208332

exit_message:

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

id: 161786129

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/molo_moloXeroPhoneSet/2026-04-10/1775808406",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-10/1775808406/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9572376891276296401,
        "service_name": "drive-thru",
        "span_id": 1339425175114721971,
        "trace_id": 10453087785411667934
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-10 03:13:07
success: True
trace_id: 10453087785411667934

Scan 161730474

duration: 0:00:11.882230

exit_message:

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

id: 161730474

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/molo_moloXeroPhoneSet/2026-04-09/1775721736",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-09/1775721736/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18053998894949568711,
        "service_name": "drive-thru",
        "span_id": 5665857734786348723,
        "trace_id": 3682275748391596323
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-09 03:07:41
success: True
trace_id: 3682275748391596323

Scan 161675628

duration: 0:00:11.744229

exit_message:

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

id: 161675628

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/molo_moloXeroPhoneSet/2026-04-08/1775635564",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-08/1775635564/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6179080350331059453,
        "service_name": "drive-thru",
        "span_id": 6464868622925883385,
        "trace_id": 4259922698417152681
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-08 03:08:24
success: True
trace_id: 4259922698417152681

Scan 161619297

duration: 0:00:11.803078

exit_message:

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

id: 161619297

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/molo_moloXeroPhoneSet/2026-04-07/1775548724",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-07/1775548724/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7472133107096948848,
        "service_name": "drive-thru",
        "span_id": 17261781616255583611,
        "trace_id": 16843348523842136531
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-07 03:02:46
success: True
trace_id: 16843348523842136531

Scan 161561705

duration: 0:00:14.297887

exit_message:

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

id: 161561705

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/molo_moloXeroPhoneSet/2026-04-06/1775462677",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-06/1775462677/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1471720607004759067,
        "service_name": "drive-thru",
        "span_id": 7281226109256565971,
        "trace_id": 16944699417433241218
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-06 03:09:15
success: True
trace_id: 16944699417433241218

Scan 161515037

duration: 0:00:11.771612

exit_message:

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

id: 161515037

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/molo_moloXeroPhoneSet/2026-04-05/1775376305",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-05/1775376305/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1351220696294025947,
        "service_name": "drive-thru",
        "span_id": 15633264534696968939,
        "trace_id": 8036407746373466127
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-05 03:10:51
success: True
trace_id: 8036407746373466127

Scan 161460631

duration: 0:00:14.351837

exit_message:

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

id: 161460631

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/molo_moloXeroPhoneSet/2026-04-04/1775289791",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-04/1775289791/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9272003676718855539,
        "service_name": "drive-thru",
        "span_id": 16974845531183863251,
        "trace_id": 2710754743905509602
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-04 03:12:08
success: True
trace_id: 2710754743905509602

Scan 161402101

duration: 0:00:16.921786

exit_message:

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

id: 161402101

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/molo_moloXeroPhoneSet/2026-04-03/1775203554",
        "key": "raw/molo_moloXeroPhoneSet/2026-04-03/1775203554/XeroPhoneSet.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.molo_moloXeroPhoneSet",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18355721421678805412,
        "service_name": "drive-thru",
        "span_id": 18387906549978190902,
        "trace_id": 950623419277245465
    }
}

running: False
schema_name_id: 1738
start_time: 2026-04-03 03:21:09
success: True
trace_id: 950623419277245465

Partitions:

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

Schema:

attributes:

{
    "Id": "string",
    "PhoneAreaCode": "string",
    "PhoneCountryCode": "string",
    "PhoneNumber": "string",
    "XeroContact_Id": "string",
    "XeroOrganizationId": "string",
    "XeroPhoneType_Id": "string"
}

created: 2026-04-17 03:13:44

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-17/1776413278'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-10-17 02:00:14",
        "disabled": false,
        "format": "raw",
        "id": 1738,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "molo_moloxerophoneset"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "Id": "string",
            "PhoneAreaCode": "string",
            "PhoneCountryCode": "string",
            "PhoneNumber": "string",
            "XeroContact_Id": "string",
            "XeroOrganizationId": "string",
            "XeroPhoneType_Id": "string"
        },
        "created": "2026-04-17 03:13:44",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.molo_moloxerophoneset`\n(\n `Id`  string , `PhoneNumber`  string , `PhoneAreaCode`  string , `PhoneCountryCode`  string , `XeroOrganizationId`  string , `XeroPhoneType_Id`  string , `XeroContact_Id`  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/molo_moloXeroPhoneSet/2026-04-17/1776413278'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.molo_moloxerophoneset`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.molo_moloxerophoneset"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}