Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsbooking_adjustments

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717928

created: 2026-04-17 04:55:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-17/1776419646
id: 1717928
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 162169264
updated: 2026-04-17 04:55:28

Version 1716747

created: 2026-04-16 05:18:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-16/1776334543'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-16/1776334543
id: 1716747
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 162114416
updated: 2026-04-16 05:18:19

Version 1715482

created: 2026-04-15 03:40:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-15/1776242356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-15/1776242356
id: 1715482
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 162056365
updated: 2026-04-15 03:41:12

Version 1714370

created: 2026-04-14 05:03:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-14/1776160756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-14/1776160756
id: 1714370
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 162003090
updated: 2026-04-14 05:03:43

Version 1713111

created: 2026-04-13 05:08:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-13/1776074797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-13/1776074797
id: 1713111
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161945317
updated: 2026-04-13 05:08:53

Version 1711874

created: 2026-04-12 05:02:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-12/1775988152'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-12/1775988152
id: 1711874
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161896299
updated: 2026-04-12 05:02:53

Version 1710670

created: 2026-04-11 05:16:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-11/1775902569'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-11/1775902569
id: 1710670
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161843888
updated: 2026-04-11 05:16:26

Version 1709583

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-10/1775815218'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-10/1775815218
id: 1709583
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161788630
updated: 2026-04-10 05:03:53

Version 1708356

created: 2026-04-09 05:00:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-09/1775728835'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-09/1775728835
id: 1708356
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161732907
updated: 2026-04-09 05:00:53

Version 1707202

created: 2026-04-08 05:12:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-08/1775642998
id: 1707202
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161678361
updated: 2026-04-08 05:12:54

Version 1705984

created: 2026-04-07 05:14:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-07/1775556855'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-07/1775556855
id: 1705984
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161622062
updated: 2026-04-07 05:15:04

Version 1704752

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-06/1775470525'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-06/1775470525
id: 1704752
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161564223
updated: 2026-04-06 05:16:17

Version 1703554

created: 2026-04-05 04:56:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-05/1775382945
id: 1703554
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161516531
updated: 2026-04-05 04:57:01

Version 1702389

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-04/1775296466
id: 1702389
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161462090
updated: 2026-04-04 04:55:15

Version 1701252

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-03/1775211033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_adjustments/2026-04-03/1775211033
id: 1701252
processed: 1

raw_data:

{
    "amount": 6,
    "booking_id": 2,
    "category": 4,
    "created_at": 7,
    "id": 1,
    "notes": 5,
    "tenant": 0,
    "type_id": 3,
    "updated_at": 8
}

schema_attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

schema_name_id: 1456
schema_scan_id: 161404850
updated: 2026-04-03 05:13:28

Schema Scans: 15

Last at 2026-04-17 04:55:14

Scan 162169264

duration: 0:00:14.292925

exit_message:

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

id: 162169264

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_imsbooking_adjustments/2026-04-17/1776419646",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-17/1776419646/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15702374962736833497,
        "service_name": "drive-thru",
        "span_id": 14714772823327503357,
        "trace_id": 1310159464510689138
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-17 04:55:14
success: True
trace_id: 1310159464510689138

Scan 162114416

duration: 0:00:14.516825

exit_message:

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

id: 162114416

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_imsbooking_adjustments/2026-04-16/1776334543",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-16/1776334543/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13126787476090447941,
        "service_name": "drive-thru",
        "span_id": 5613951342943622734,
        "trace_id": 100439211097057856
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-16 05:18:04
success: True
trace_id: 100439211097057856

Scan 162056365

duration: 0:00:14.381186

exit_message:

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

id: 162056365

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_imsbooking_adjustments/2026-04-15/1776242356",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-15/1776242356/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 771996156888272338,
        "service_name": "drive-thru",
        "span_id": 11255748260501402880,
        "trace_id": 16693996502904253598
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-15 03:40:58
success: True
trace_id: 16693996502904253598

Scan 162003090

duration: 0:00:11.983773

exit_message:

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

id: 162003090

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_imsbooking_adjustments/2026-04-14/1776160756",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-14/1776160756/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18240641700343727737,
        "service_name": "drive-thru",
        "span_id": 816935460470671891,
        "trace_id": 11044671565985587327
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-14 05:03:31
success: True
trace_id: 11044671565985587327

Scan 161945317

duration: 0:00:11.842385

exit_message:

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

id: 161945317

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_imsbooking_adjustments/2026-04-13/1776074797",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-13/1776074797/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5748037525467045136,
        "service_name": "drive-thru",
        "span_id": 4102183196608106760,
        "trace_id": 12683166630096938653
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-13 05:08:41
success: True
trace_id: 12683166630096938653

Scan 161896299

duration: 0:00:11.826740

exit_message:

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

id: 161896299

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_imsbooking_adjustments/2026-04-12/1775988152",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-12/1775988152/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15639343996570549129,
        "service_name": "drive-thru",
        "span_id": 5073733830018659105,
        "trace_id": 3585065760927260066
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-12 05:02:41
success: True
trace_id: 3585065760927260066

Scan 161843888

duration: 0:00:11.736668

exit_message:

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

id: 161843888

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_imsbooking_adjustments/2026-04-11/1775902569",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-11/1775902569/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3230447090066134334,
        "service_name": "drive-thru",
        "span_id": 1796999693623326217,
        "trace_id": 11187598945952158653
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-11 05:16:14
success: True
trace_id: 11187598945952158653

Scan 161788630

duration: 0:00:11.900808

exit_message:

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

id: 161788630

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_imsbooking_adjustments/2026-04-10/1775815218",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-10/1775815218/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1763742687775333404,
        "service_name": "drive-thru",
        "span_id": 15565076334335987710,
        "trace_id": 16766536088520657977
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-10 05:03:41
success: True
trace_id: 16766536088520657977

Scan 161732907

duration: 0:00:14.357121

exit_message:

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

id: 161732907

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_imsbooking_adjustments/2026-04-09/1775728835",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-09/1775728835/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17391924531109576431,
        "service_name": "drive-thru",
        "span_id": 6235872182636519670,
        "trace_id": 11536844908510971541
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-09 05:00:39
success: True
trace_id: 11536844908510971541

Scan 161678361

duration: 0:00:14.366136

exit_message:

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

id: 161678361

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_imsbooking_adjustments/2026-04-08/1775642998",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-08/1775642998/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6316872778211941454,
        "service_name": "drive-thru",
        "span_id": 10454680742613071055,
        "trace_id": 4322743892489615395
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-08 05:12:40
success: True
trace_id: 4322743892489615395

Scan 161622062

duration: 0:00:11.841396

exit_message:

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

id: 161622062

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_imsbooking_adjustments/2026-04-07/1775556855",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-07/1775556855/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14201400149162237736,
        "service_name": "drive-thru",
        "span_id": 10226220168189187997,
        "trace_id": 10425163452203209819
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-07 05:14:52
success: True
trace_id: 10425163452203209819

Scan 161564223

duration: 0:00:14.532801

exit_message:

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

id: 161564223

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_imsbooking_adjustments/2026-04-06/1775470525",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-06/1775470525/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7794237730825698142,
        "service_name": "drive-thru",
        "span_id": 13946385005038929757,
        "trace_id": 12795938271139240765
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-06 05:16:02
success: True
trace_id: 12795938271139240765

Scan 161516531

duration: 0:00:14.259685

exit_message:

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

id: 161516531

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_imsbooking_adjustments/2026-04-05/1775382945",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-05/1775382945/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7276714300441717626,
        "service_name": "drive-thru",
        "span_id": 10339213138203266242,
        "trace_id": 7090377672971043546
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-05 04:56:46
success: True
trace_id: 7090377672971043546

Scan 161462090

duration: 0:00:11.810319

exit_message:

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

id: 161462090

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_imsbooking_adjustments/2026-04-04/1775296466",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-04/1775296466/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17186232042254438017,
        "service_name": "drive-thru",
        "span_id": 16807679316821736744,
        "trace_id": 11071516457564930426
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-04 04:55:03
success: True
trace_id: 11071516457564930426

Scan 161404850

duration: 0:00:11.894058

exit_message:

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

id: 161404850

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_imsbooking_adjustments/2026-04-03/1775211033",
        "key": "raw/stellar_imsbooking_adjustments/2026-04-03/1775211033/booking_adjustments.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_adjustments",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16486817398446132846,
        "service_name": "drive-thru",
        "span_id": 4771601723116045581,
        "trace_id": 15136985743849261727
    }
}

running: False
schema_name_id: 1456
start_time: 2026-04-03 05:13:17
success: True
trace_id: 15136985743849261727

Partitions:

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

Schema:

attributes:

{
    "amount": "string",
    "booking_id": "string",
    "category": "string",
    "created_at": "string",
    "id": "string",
    "notes": "string",
    "tenant": "string",
    "type_id": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:55:15

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
}

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:24",
        "disabled": false,
        "format": "raw",
        "id": 1456,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsbooking_adjustments"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount": "string",
            "booking_id": "string",
            "category": "string",
            "created_at": "string",
            "id": "string",
            "notes": "string",
            "tenant": "string",
            "type_id": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:55:15",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_adjustments`\n(\n `tenant`  string , `id`  string , `booking_id`  string , `type_id`  string , `category`  string , `notes`  string , `amount`  string , `created_at`  string , `updated_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_imsbooking_adjustments/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_adjustments`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_adjustments"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}