Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsbooking_boat_accessories

created: 2024-06-11 03:14:34
disabled: False
format: raw
id: 1889
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717925

created: 2026-04-17 04:55:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-17/1776419645
id: 1717925
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 162169261
updated: 2026-04-17 04:55:22

Version 1716701

created: 2026-04-16 05:16:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-16/1776334542'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-16/1776334542
id: 1716701
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 162114370
updated: 2026-04-16 05:16:36

Version 1715479

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-15/1776242356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 162056362
updated: 2026-04-15 03:41:06

Version 1714376

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-14/1776160755'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-14/1776160755
id: 1714376
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 162003097
updated: 2026-04-14 05:03:55

Version 1713093

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-13/1776074796'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-13/1776074796
id: 1713093
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161945299
updated: 2026-04-13 05:08:14

Version 1711928

created: 2026-04-12 05:05:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-12/1775988156'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-12/1775988156
id: 1711928
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161896377
updated: 2026-04-12 05:05:50

Version 1710697

created: 2026-04-11 05:17:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-11/1775902575'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-11/1775902575
id: 1710697
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161843916
updated: 2026-04-11 05:17:28

Version 1709550

created: 2026-04-10 05:02:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-10/1775815217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-10/1775815217
id: 1709550
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161788590
updated: 2026-04-10 05:02:32

Version 1708357

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-09/1775728832'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-09/1775728832
id: 1708357
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161732909
updated: 2026-04-09 05:00:53

Version 1707276

created: 2026-04-08 05:15:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-08/1775643000'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-08/1775643000
id: 1707276
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161678436
updated: 2026-04-08 05:16:00

Version 1706000

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-07/1775556856
id: 1706000
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161622078
updated: 2026-04-07 05:15:44

Version 1704844

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-06/1775470530'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-06/1775470530
id: 1704844
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161564320
updated: 2026-04-06 05:19:44

Version 1703580

created: 2026-04-05 04:57:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161516573
updated: 2026-04-05 04:58:03

Version 1702484

created: 2026-04-04 04:58:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-04/1775296467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-04/1775296467
id: 1702484
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161462234
updated: 2026-04-04 04:58:45

Version 1701192

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-03/1775211030'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_accessories/2026-04-03/1775211030
id: 1701192
processed: 1

raw_data:

{
    "accessory_id": 2,
    "accessory_option_id": 5,
    "booking_boat_id": 1,
    "created_at": 6,
    "qty": 3,
    "rate": 4,
    "tenant": 0,
    "updated_at": 7
}

schema_attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1889
schema_scan_id: 161404790
updated: 2026-04-03 05:11:08

Schema Scans: 15

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

Scan 162169261

duration: 0:00:14.418274

exit_message:

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

id: 162169261

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_boat_accessories/2026-04-17/1776419645",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-17/1776419645/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4220641051186687281,
        "service_name": "drive-thru",
        "span_id": 574221314523443250,
        "trace_id": 1474296040073992921
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-17 04:55:07
success: True
trace_id: 1474296040073992921

Scan 162114370

duration: 0:00:14.470708

exit_message:

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

id: 162114370

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_boat_accessories/2026-04-16/1776334542",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-16/1776334542/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10992707186340229191,
        "service_name": "drive-thru",
        "span_id": 4503971390524699576,
        "trace_id": 11782154507140569778
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-16 05:16:22
success: True
trace_id: 11782154507140569778

Scan 162056362

duration: 0:00:14.516079

exit_message:

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

id: 162056362

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_boat_accessories/2026-04-15/1776242356",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-15/1776242356/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 254964165252160560,
        "service_name": "drive-thru",
        "span_id": 13771216776224920404,
        "trace_id": 12368765137194239834
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-15 03:40:52
success: True
trace_id: 12368765137194239834

Scan 162003097

duration: 0:00:11.847570

exit_message:

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

id: 162003097

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_boat_accessories/2026-04-14/1776160755",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-14/1776160755/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12641241460019155759,
        "service_name": "drive-thru",
        "span_id": 1233517555182949423,
        "trace_id": 13774139292868705028
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-14 05:03:43
success: True
trace_id: 13774139292868705028

Scan 161945299

duration: 0:00:14.378976

exit_message:

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

id: 161945299

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_boat_accessories/2026-04-13/1776074796",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-13/1776074796/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8959846882524336535,
        "service_name": "drive-thru",
        "span_id": 1066589520367958297,
        "trace_id": 2804539777802270783
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-13 05:08:00
success: True
trace_id: 2804539777802270783

Scan 161896377

duration: 0:00:11.787614

exit_message:

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

id: 161896377

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_boat_accessories/2026-04-12/1775988156",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-12/1775988156/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6611625210408974636,
        "service_name": "drive-thru",
        "span_id": 8283753773570034262,
        "trace_id": 16448357493747106003
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-12 05:05:38
success: True
trace_id: 16448357493747106003

Scan 161843916

duration: 0:00:11.797824

exit_message:

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

id: 161843916

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_boat_accessories/2026-04-11/1775902575",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-11/1775902575/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7996803343558629354,
        "service_name": "drive-thru",
        "span_id": 3345266623951335714,
        "trace_id": 16107241098165371071
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-11 05:17:16
success: True
trace_id: 16107241098165371071

Scan 161788590

duration: 0:00:11.896078

exit_message:

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

id: 161788590

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_boat_accessories/2026-04-10/1775815217",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-10/1775815217/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8603906651216372334,
        "service_name": "drive-thru",
        "span_id": 1361244646457756122,
        "trace_id": 6555469660059217841
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-10 05:02:20
success: True
trace_id: 6555469660059217841

Scan 161732909

duration: 0:00:11.872706

exit_message:

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

id: 161732909

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_boat_accessories/2026-04-09/1775728832",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-09/1775728832/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10971091773876708028,
        "service_name": "drive-thru",
        "span_id": 11385074324630616063,
        "trace_id": 7089412479624540958
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-09 05:00:41
success: True
trace_id: 7089412479624540958

Scan 161678436

duration: 0:00:14.362614

exit_message:

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

id: 161678436

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_boat_accessories/2026-04-08/1775643000",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-08/1775643000/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10454610536294349103,
        "service_name": "drive-thru",
        "span_id": 8779417915811659771,
        "trace_id": 8060906507808564511
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-08 05:15:46
success: True
trace_id: 8060906507808564511

Scan 161622078

duration: 0:00:14.400337

exit_message:

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

id: 161622078

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_boat_accessories/2026-04-07/1775556856",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-07/1775556856/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7704232324798045331,
        "service_name": "drive-thru",
        "span_id": 911477383630682579,
        "trace_id": 2772205222471293890
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-07 05:15:30
success: True
trace_id: 2772205222471293890

Scan 161564320

duration: 0:00:14.326951

exit_message:

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

id: 161564320

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_boat_accessories/2026-04-06/1775470530",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-06/1775470530/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11541697560987862053,
        "service_name": "drive-thru",
        "span_id": 13839955497381631171,
        "trace_id": 15169878621457154894
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-06 05:19:30
success: True
trace_id: 15169878621457154894

Scan 161516573

duration: 0:00:11.689109

exit_message:

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

id: 161516573

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_boat_accessories/2026-04-05/1775382945",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-05/1775382945/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14975598727968575310,
        "service_name": "drive-thru",
        "span_id": 8606920952465370412,
        "trace_id": 13588740848659233513
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-05 04:57:52
success: True
trace_id: 13588740848659233513

Scan 161462234

duration: 0:00:11.976668

exit_message:

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

id: 161462234

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_boat_accessories/2026-04-04/1775296467",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-04/1775296467/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15294798019972562531,
        "service_name": "drive-thru",
        "span_id": 17303551061967471173,
        "trace_id": 9555113889631968477
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-04 04:58:33
success: True
trace_id: 9555113889631968477

Scan 161404790

duration: 0:00:11.895055

exit_message:

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

id: 161404790

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_boat_accessories/2026-04-03/1775211030",
        "key": "raw/stellar_imsbooking_boat_accessories/2026-04-03/1775211030/booking_boat_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12683080439088094016,
        "service_name": "drive-thru",
        "span_id": 4234009145530051910,
        "trace_id": 12681544553135904928
    }
}

running: False
schema_name_id: 1889
start_time: 2026-04-03 05:10:56
success: True
trace_id: 12681544553135904928

Partitions:

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

Schema:

attributes:

{
    "accessory_id": "string",
    "accessory_option_id": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "qty": "string",
    "rate": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:55:08

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_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-06-11 03:14:34",
        "disabled": false,
        "format": "raw",
        "id": 1889,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsbooking_boat_accessories"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accessory_id": "string",
            "accessory_option_id": "string",
            "booking_boat_id": "string",
            "created_at": "string",
            "qty": "string",
            "rate": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:55:08",
        "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_boat_accessories`\n(\n `tenant`  string , `booking_boat_id`  string , `accessory_id`  string , `qty`  string , `rate`  string , `accessory_option_id`  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_boat_accessories/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_accessories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_accessories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}