Schema Info

Schema Name: sfdl_prod_drivethru.auctions_sa_admin_invoice_details

created: 2025-10-01 09:04:14
disabled: False
format: raw
id: 4280
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717281

created: 2026-04-16 19:08:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-16/1776384478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-16/1776384478
id: 1717281
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 162152397
updated: 2026-04-16 19:08:18

Version 1716051

created: 2026-04-15 19:07:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-15/1776298061'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-15/1776298061
id: 1716051
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 162096380
updated: 2026-04-15 19:08:00

Version 1714846

created: 2026-04-14 19:08:00

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-14/1776211673'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-14/1776211673
id: 1714846
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 162040865
updated: 2026-04-14 19:08:11

Version 1713646

created: 2026-04-13 19:07:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-13/1776125268'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-13/1776125268
id: 1713646
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161985247
updated: 2026-04-13 19:08:06

Version 1712433

created: 2026-04-12 19:08:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-12/1776038886'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-12/1776038886
id: 1712433
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161928037
updated: 2026-04-12 19:08:35

Version 1711239

created: 2026-04-11 19:08:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-11/1775952497'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-11/1775952497
id: 1711239
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161879305
updated: 2026-04-11 19:08:36

Version 1710029

created: 2026-04-10 19:07:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-10/1775866062'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-10/1775866062
id: 1710029
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161826414
updated: 2026-04-10 19:09:49

Version 1708895

created: 2026-04-09 19:08:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-09/1775779688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-09/1775779688
id: 1708895
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161770537
updated: 2026-04-09 19:08:28

Version 1707753

created: 2026-04-08 19:07:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-08/1775693254'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-08/1775693254
id: 1707753
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161715250
updated: 2026-04-08 19:07:52

Version 1706526

created: 2026-04-07 19:07:37

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-07/1775606849'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-07/1775606849
id: 1706526
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161660049
updated: 2026-04-07 19:07:50

Version 1705347

created: 2026-04-06 19:08:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-06/1775520474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-06/1775520474
id: 1705347
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161603821
updated: 2026-04-06 19:08:22

Version 1704117

created: 2026-04-05 19:07:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-05/1775434054'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-05/1775434054
id: 1704117
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161546870
updated: 2026-04-05 19:07:54

Version 1702932

created: 2026-04-04 19:08:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-04/1775347688'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-04/1775347688
id: 1702932
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161500647
updated: 2026-04-04 19:08:25

Version 1701757

created: 2026-04-03 19:08:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-03/1775261274'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-03/1775261274
id: 1701757
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161444664
updated: 2026-04-03 19:08:13

Version 1700547

created: 2026-04-02 19:07:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-02/1775174857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/auctions_sa_admin_invoice_details/2026-04-02/1775174857
id: 1700547
processed: 1

raw_data:

{
    "billing_method": 4,
    "cancelletion_history_id": 2,
    "created_at": 8,
    "created_by": 7,
    "id": 0,
    "invoice_id": 1,
    "is_deleted": 10,
    "location_id": 6,
    "monthly_fee": 5,
    "unit_id": 3,
    "updated_at": 9
}

schema_attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

schema_name_id: 4280
schema_scan_id: 161386053
updated: 2026-04-02 19:07:56

Schema Scans: 15

Last at 2026-04-16 19:08:03

Scan 162152397

duration: 0:00:14.557611

exit_message:

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

id: 162152397

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/auctions_sa_admin_invoice_details/2026-04-16/1776384478",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-16/1776384478/sa_admin_invoice_details_1776384002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4165361902971368245,
        "service_name": "drive-thru",
        "span_id": 14487904214715399979,
        "trace_id": 7840640347350335458
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-16 19:08:03
success: True
trace_id: 7840640347350335458

Scan 162096380

duration: 0:00:14.488481

exit_message:

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

id: 162096380

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/auctions_sa_admin_invoice_details/2026-04-15/1776298061",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-15/1776298061/sa_admin_invoice_details_1776297601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4453337244828440541,
        "service_name": "drive-thru",
        "span_id": 8397889628856080011,
        "trace_id": 15618506267519445295
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-15 19:07:45
success: True
trace_id: 15618506267519445295

Scan 162040865

duration: 0:00:11.935923

exit_message:

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

id: 162040865

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/auctions_sa_admin_invoice_details/2026-04-14/1776211673",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-14/1776211673/sa_admin_invoice_details_1776211201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11588147970554317910,
        "service_name": "drive-thru",
        "span_id": 6269024457272734687,
        "trace_id": 2331742759256561271
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-14 19:07:59
success: True
trace_id: 2331742759256561271

Scan 161985247

duration: 0:00:11.955337

exit_message:

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

id: 161985247

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/auctions_sa_admin_invoice_details/2026-04-13/1776125268",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-13/1776125268/sa_admin_invoice_details_1776124802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14348531348380845615,
        "service_name": "drive-thru",
        "span_id": 8763330876135870152,
        "trace_id": 12951279653159326735
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-13 19:07:55
success: True
trace_id: 12951279653159326735

Scan 161928037

duration: 0:00:24.624135

exit_message:

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

id: 161928037

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/auctions_sa_admin_invoice_details/2026-04-12/1776038886",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-12/1776038886/sa_admin_invoice_details_1776038402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8848833524535895078,
        "service_name": "drive-thru",
        "span_id": 3939523170279024025,
        "trace_id": 13076010864906006714
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-12 19:08:11
success: True
trace_id: 13076010864906006714

Scan 161879305

duration: 0:00:14.533276

exit_message:

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

id: 161879305

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/auctions_sa_admin_invoice_details/2026-04-11/1775952497",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-11/1775952497/sa_admin_invoice_details_1775952002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 584496599165076056,
        "service_name": "drive-thru",
        "span_id": 16328062191990311904,
        "trace_id": 769851636197593061
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-11 19:08:21
success: True
trace_id: 769851636197593061

Scan 161826414

duration: 0:02:01.264530

exit_message:

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

id: 161826414

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/auctions_sa_admin_invoice_details/2026-04-10/1775866062",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-10/1775866062/sa_admin_invoice_details_1775865602.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6633834081079834959,
        "service_name": "drive-thru",
        "span_id": 17196075733560997743,
        "trace_id": 7936331283469313154
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-10 19:07:48
success: True
trace_id: 7936331283469313154

Scan 161770537

duration: 0:00:14.373091

exit_message:

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

id: 161770537

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/auctions_sa_admin_invoice_details/2026-04-09/1775779688",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-09/1775779688/sa_admin_invoice_details_1775779202.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13656837069799185396,
        "service_name": "drive-thru",
        "span_id": 5416477632037496521,
        "trace_id": 15590392025018226250
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-09 19:08:13
success: True
trace_id: 15590392025018226250

Scan 161715250

duration: 0:00:11.883171

exit_message:

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

id: 161715250

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/auctions_sa_admin_invoice_details/2026-04-08/1775693254",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-08/1775693254/sa_admin_invoice_details_1775692802.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18190902438355637698,
        "service_name": "drive-thru",
        "span_id": 342370196953616298,
        "trace_id": 8658640582226964496
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-08 19:07:40
success: True
trace_id: 8658640582226964496

Scan 161660049

duration: 0:00:14.468776

exit_message:

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

id: 161660049

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/auctions_sa_admin_invoice_details/2026-04-07/1775606849",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-07/1775606849/sa_admin_invoice_details_1775606402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13198035998517958688,
        "service_name": "drive-thru",
        "span_id": 10283223381249352856,
        "trace_id": 3301197689828920952
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-07 19:07:36
success: True
trace_id: 3301197689828920952

Scan 161603821

duration: 0:00:11.999027

exit_message:

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

id: 161603821

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/auctions_sa_admin_invoice_details/2026-04-06/1775520474",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-06/1775520474/sa_admin_invoice_details_1775520002.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15787724461664501770,
        "service_name": "drive-thru",
        "span_id": 13062009360051241626,
        "trace_id": 11165298042200461556
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-06 19:08:10
success: True
trace_id: 11165298042200461556

Scan 161546870

duration: 0:00:14.415889

exit_message:

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

id: 161546870

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/auctions_sa_admin_invoice_details/2026-04-05/1775434054",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-05/1775434054/sa_admin_invoice_details_1775433601.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3740513954655652670,
        "service_name": "drive-thru",
        "span_id": 4107878320928261332,
        "trace_id": 8954724314542614420
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-05 19:07:39
success: True
trace_id: 8954724314542614420

Scan 161500647

duration: 0:00:12.169028

exit_message:

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

id: 161500647

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/auctions_sa_admin_invoice_details/2026-04-04/1775347688",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-04/1775347688/sa_admin_invoice_details_1775347201.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 542642066296432829,
        "service_name": "drive-thru",
        "span_id": 12406011308819150195,
        "trace_id": 10624865811919544255
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-04 19:08:13
success: True
trace_id: 10624865811919544255

Scan 161444664

duration: 0:00:12.247085

exit_message:

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

id: 161444664

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/auctions_sa_admin_invoice_details/2026-04-03/1775261274",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-03/1775261274/sa_admin_invoice_details_1775260801.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10317388995571662081,
        "service_name": "drive-thru",
        "span_id": 10288648100684948981,
        "trace_id": 7865504278391417969
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-03 19:08:00
success: True
trace_id: 7865504278391417969

Scan 161386053

duration: 0:00:14.439884

exit_message:

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

id: 161386053

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/auctions_sa_admin_invoice_details/2026-04-02/1775174857",
        "key": "raw/auctions_sa_admin_invoice_details/2026-04-02/1775174857/sa_admin_invoice_details_1775174402.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.auctions_sa_admin_invoice_details",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3570015104886208832,
        "service_name": "drive-thru",
        "span_id": 7917698978163812693,
        "trace_id": 12444892491063758189
    }
}

running: False
schema_name_id: 4280
start_time: 2026-04-02 19:07:41
success: True
trace_id: 12444892491063758189

Partitions:

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

Schema:

attributes:

{
    "billing_method": "string",
    "cancelletion_history_id": "string",
    "created_at": "string",
    "created_by": "string",
    "id": "string",
    "invoice_id": "string",
    "is_deleted": "string",
    "location_id": "string",
    "monthly_fee": "string",
    "unit_id": "string",
    "updated_at": "string"
}

created: 2026-04-16 19:08:04

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-16/1776384478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
}

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-10-01 09:04:14",
        "disabled": false,
        "format": "raw",
        "id": 4280,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "auctions_sa_admin_invoice_details"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "billing_method": "string",
            "cancelletion_history_id": "string",
            "created_at": "string",
            "created_by": "string",
            "id": "string",
            "invoice_id": "string",
            "is_deleted": "string",
            "location_id": "string",
            "monthly_fee": "string",
            "unit_id": "string",
            "updated_at": "string"
        },
        "created": "2026-04-16 19:08:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.auctions_sa_admin_invoice_details`\n(\n `id`  string , `invoice_id`  string , `cancelletion_history_id`  string , `unit_id`  string , `billing_method`  string , `monthly_fee`  string , `location_id`  string , `created_by`  string , `created_at`  string , `updated_at`  string , `is_deleted`  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/auctions_sa_admin_invoice_details/2026-04-16/1776384478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.auctions_sa_admin_invoice_details`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.auctions_sa_admin_invoice_details"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}