Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imspos_sales

created: 2023-02-07 01:46:37
disabled: False
format: raw
id: 1463
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717950

created: 2026-04-17 04:56:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-17/1776419650
id: 1717950
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 162169287
updated: 2026-04-17 04:56:23

Version 1716715

created: 2026-04-16 05:16:55

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-16/1776334550'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-16/1776334550
id: 1716715
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 162114384
updated: 2026-04-16 05:17:06

Version 1715542

created: 2026-04-15 03:43:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-15/1776242364'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-15/1776242364
id: 1715542
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 162056429
updated: 2026-04-15 03:43:34

Version 1714323

created: 2026-04-14 05:01:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-14/1776160759'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-14/1776160759
id: 1714323
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 162002977
updated: 2026-04-14 05:01:32

Version 1713148

created: 2026-04-13 05:10:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-13/1776074805'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-13/1776074805
id: 1713148
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161945356
updated: 2026-04-13 05:10:23

Version 1711970

created: 2026-04-12 05:07:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-12/1775988162'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-12/1775988162
id: 1711970
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161896429
updated: 2026-04-12 05:07:59

Version 1710776

created: 2026-04-11 05:20:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-11/1775902578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-11/1775902578
id: 1710776
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161843998
updated: 2026-04-11 05:20:34

Version 1709516

created: 2026-04-10 05:01:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-10/1775815219
id: 1709516
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161788553
updated: 2026-04-10 05:01:20

Version 1708467

created: 2026-04-09 05:04:59

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-09/1775728839'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-09/1775728839
id: 1708467
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161733033
updated: 2026-04-09 05:05:12

Version 1707185

created: 2026-04-08 05:11:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-08/1775642990'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-08/1775642990
id: 1707185
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161678344
updated: 2026-04-08 05:11:57

Version 1705993

created: 2026-04-07 05:15:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-07/1775556859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-07/1775556859
id: 1705993
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161622071
updated: 2026-04-07 05:15:29

Version 1704834

created: 2026-04-06 05:19:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-06/1775470535'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-06/1775470535
id: 1704834
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161564310
updated: 2026-04-06 05:19:20

Version 1703598

created: 2026-04-05 04:58:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-05/1775382947'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-05/1775382947
id: 1703598
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161516597
updated: 2026-04-05 04:58:43

Version 1702406

created: 2026-04-04 04:55:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-04/1775296462'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-04/1775296462
id: 1702406
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161462108
updated: 2026-04-04 04:55:54

Version 1701220

created: 2026-04-03 05:12:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-03/1775211037'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imspos_sales/2026-04-03/1775211037
id: 1701220
processed: 1

raw_data:

{
    "admin_id": 3,
    "amount_paid": 8,
    "created_at": 9,
    "customer_name": 4,
    "deleted_at": 11,
    "grand_total": 7,
    "id": 1,
    "location_id": 2,
    "subtotal": 5,
    "tax_1": 6,
    "tenant": 0,
    "updated_at": 10
}

schema_attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1463
schema_scan_id: 161404818
updated: 2026-04-03 05:12:16

Schema Scans: 15

Last at 2026-04-17 04:56:09

Scan 162169287

duration: 0:00:14.326850

exit_message:

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

id: 162169287

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/stellar_imspos_sales/2026-04-17/1776419650",
        "key": "raw/stellar_imspos_sales/2026-04-17/1776419650/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12045117428344914594,
        "service_name": "drive-thru",
        "span_id": 16724067396003171702,
        "trace_id": 9371953010833873856
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-17 04:56:09
success: True
trace_id: 9371953010833873856

Scan 162114384

duration: 0:00:11.999681

exit_message:

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

id: 162114384

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/stellar_imspos_sales/2026-04-16/1776334550",
        "key": "raw/stellar_imspos_sales/2026-04-16/1776334550/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9452225338376379072,
        "service_name": "drive-thru",
        "span_id": 13120704162391554449,
        "trace_id": 14491787125616798150
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-16 05:16:54
success: True
trace_id: 14491787125616798150

Scan 162056429

duration: 0:00:14.321600

exit_message:

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

id: 162056429

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/stellar_imspos_sales/2026-04-15/1776242364",
        "key": "raw/stellar_imspos_sales/2026-04-15/1776242364/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17681626343167340079,
        "service_name": "drive-thru",
        "span_id": 18087274508891547236,
        "trace_id": 12148839932363738768
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-15 03:43:20
success: True
trace_id: 12148839932363738768

Scan 162002977

duration: 0:00:11.832090

exit_message:

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

id: 162002977

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/stellar_imspos_sales/2026-04-14/1776160759",
        "key": "raw/stellar_imspos_sales/2026-04-14/1776160759/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4475128389773459781,
        "service_name": "drive-thru",
        "span_id": 13765525224415820405,
        "trace_id": 12153834449025539146
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-14 05:01:20
success: True
trace_id: 12153834449025539146

Scan 161945356

duration: 0:00:14.360490

exit_message:

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

id: 161945356

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/stellar_imspos_sales/2026-04-13/1776074805",
        "key": "raw/stellar_imspos_sales/2026-04-13/1776074805/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18120334579865966906,
        "service_name": "drive-thru",
        "span_id": 5338993344337631120,
        "trace_id": 2400092915108002325
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-13 05:10:09
success: True
trace_id: 2400092915108002325

Scan 161896429

duration: 0:00:14.350381

exit_message:

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

id: 161896429

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/stellar_imspos_sales/2026-04-12/1775988162",
        "key": "raw/stellar_imspos_sales/2026-04-12/1775988162/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13079562141064560922,
        "service_name": "drive-thru",
        "span_id": 5732180877137943725,
        "trace_id": 4418565510079691070
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-12 05:07:45
success: True
trace_id: 4418565510079691070

Scan 161843998

duration: 0:00:14.370001

exit_message:

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

id: 161843998

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/stellar_imspos_sales/2026-04-11/1775902578",
        "key": "raw/stellar_imspos_sales/2026-04-11/1775902578/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8051182533253871567,
        "service_name": "drive-thru",
        "span_id": 12544976348027942430,
        "trace_id": 13083271550473114964
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-11 05:20:20
success: True
trace_id: 13083271550473114964

Scan 161788553

duration: 0:00:14.425388

exit_message:

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

id: 161788553

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/stellar_imspos_sales/2026-04-10/1775815219",
        "key": "raw/stellar_imspos_sales/2026-04-10/1775815219/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5068971227073340595,
        "service_name": "drive-thru",
        "span_id": 12126613037055347114,
        "trace_id": 14821249280123288322
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-10 05:01:05
success: True
trace_id: 14821249280123288322

Scan 161733033

duration: 0:00:14.339856

exit_message:

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

id: 161733033

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/stellar_imspos_sales/2026-04-09/1775728839",
        "key": "raw/stellar_imspos_sales/2026-04-09/1775728839/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14419724941790923887,
        "service_name": "drive-thru",
        "span_id": 1301435654376111570,
        "trace_id": 12474077849467358061
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-09 05:04:58
success: True
trace_id: 12474077849467358061

Scan 161678344

duration: 0:00:14.373346

exit_message:

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

id: 161678344

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/stellar_imspos_sales/2026-04-08/1775642990",
        "key": "raw/stellar_imspos_sales/2026-04-08/1775642990/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11815740045883278803,
        "service_name": "drive-thru",
        "span_id": 11536741573890548352,
        "trace_id": 9265561862816251666
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-08 05:11:43
success: True
trace_id: 9265561862816251666

Scan 161622071

duration: 0:00:11.763441

exit_message:

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

id: 161622071

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/stellar_imspos_sales/2026-04-07/1775556859",
        "key": "raw/stellar_imspos_sales/2026-04-07/1775556859/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 96290016644820782,
        "service_name": "drive-thru",
        "span_id": 17903793434385930081,
        "trace_id": 18023163358880002116
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-07 05:15:17
success: True
trace_id: 18023163358880002116

Scan 161564310

duration: 0:00:11.803649

exit_message:

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

id: 161564310

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/stellar_imspos_sales/2026-04-06/1775470535",
        "key": "raw/stellar_imspos_sales/2026-04-06/1775470535/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13505855959102939892,
        "service_name": "drive-thru",
        "span_id": 14439373791899707516,
        "trace_id": 2328833966688348561
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-06 05:19:08
success: True
trace_id: 2328833966688348561

Scan 161516597

duration: 0:00:11.716456

exit_message:

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

id: 161516597

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/stellar_imspos_sales/2026-04-05/1775382947",
        "key": "raw/stellar_imspos_sales/2026-04-05/1775382947/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12159101034916485368,
        "service_name": "drive-thru",
        "span_id": 7178031651722422191,
        "trace_id": 720093623616258959
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-05 04:58:31
success: True
trace_id: 720093623616258959

Scan 161462108

duration: 0:00:11.796165

exit_message:

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

id: 161462108

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/stellar_imspos_sales/2026-04-04/1775296462",
        "key": "raw/stellar_imspos_sales/2026-04-04/1775296462/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5088164814659013118,
        "service_name": "drive-thru",
        "span_id": 15835914834401631086,
        "trace_id": 8021749784965224387
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-04 04:55:42
success: True
trace_id: 8021749784965224387

Scan 161404818

duration: 0:00:11.951551

exit_message:

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

id: 161404818

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/stellar_imspos_sales/2026-04-03/1775211037",
        "key": "raw/stellar_imspos_sales/2026-04-03/1775211037/pos_sales.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imspos_sales",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8119368276598890603,
        "service_name": "drive-thru",
        "span_id": 10509377912604694438,
        "trace_id": 8982350828245054079
    }
}

running: False
schema_name_id: 1463
start_time: 2026-04-03 05:12:04
success: True
trace_id: 8982350828245054079

Partitions:

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

Schema:

attributes:

{
    "admin_id": "string",
    "amount_paid": "string",
    "created_at": "string",
    "customer_name": "string",
    "deleted_at": "string",
    "grand_total": "string",
    "id": "string",
    "location_id": "string",
    "subtotal": "string",
    "tax_1": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:56:09

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
}

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-02-07 01:46:37",
        "disabled": false,
        "format": "raw",
        "id": 1463,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imspos_sales"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "admin_id": "string",
            "amount_paid": "string",
            "created_at": "string",
            "customer_name": "string",
            "deleted_at": "string",
            "grand_total": "string",
            "id": "string",
            "location_id": "string",
            "subtotal": "string",
            "tax_1": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:56:09",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imspos_sales`\n(\n `tenant`  string , `id`  string , `location_id`  string , `admin_id`  string , `customer_name`  string , `subtotal`  string , `tax_1`  string , `grand_total`  string , `amount_paid`  string , `created_at`  string , `updated_at`  string , `deleted_at`  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/stellar_imspos_sales/2026-04-17/1776419650'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imspos_sales`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imspos_sales"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}