Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsbooking_boat_guests

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717943

created: 2026-04-17 04:55:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

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

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 162169280
updated: 2026-04-17 04:56:07

Version 1716700

created: 2026-04-16 05:16:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-16/1776334545
id: 1716700
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 162114369
updated: 2026-04-16 05:16:33

Version 1715446

created: 2026-04-15 03:39:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-15/1776242355'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-15/1776242355
id: 1715446
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 162056330
updated: 2026-04-15 03:39:53

Version 1714388

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-14/1776160758'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-14/1776160758
id: 1714388
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 162003120
updated: 2026-04-14 05:04:29

Version 1713109

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-13/1776074797'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

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

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161945315
updated: 2026-04-13 05:08:51

Version 1711894

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-12/1775988155'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-12/1775988155
id: 1711894
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161896335
updated: 2026-04-12 05:04:09

Version 1710773

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-11/1775902576
id: 1710773
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161843995
updated: 2026-04-11 05:20:25

Version 1709505

created: 2026-04-10 05:00:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-10/1775815210'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-10/1775815210
id: 1709505
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161788540
updated: 2026-04-10 05:00:54

Version 1708363

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-09/1775728833'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-09/1775728833
id: 1708363
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161732916
updated: 2026-04-09 05:01:10

Version 1707258

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

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

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161678418
updated: 2026-04-08 05:15:21

Version 1705988

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-07/1775556852'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-07/1775556852
id: 1705988
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161622066
updated: 2026-04-07 05:15:16

Version 1704755

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-06/1775470527'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-06/1775470527
id: 1704755
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161564226
updated: 2026-04-06 05:16:20

Version 1703540

created: 2026-04-05 04:56:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

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

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161516506
updated: 2026-04-05 04:56:25

Version 1702412

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-04/1775296468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-04/1775296468
id: 1702412
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161462113
updated: 2026-04-04 04:56:09

Version 1701222

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-03/1775211036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_guests/2026-04-03/1775211036
id: 1701222
processed: 1

raw_data:

{
    "billing_city": 12,
    "billing_country": 14,
    "billing_state": 13,
    "billing_street1": 10,
    "billing_street2": 11,
    "billing_zip": 15,
    "booking_boat_id": 2,
    "created_at": 16,
    "customer_id": 3,
    "dob": 9,
    "email": 6,
    "firstname": 4,
    "id": 1,
    "is_driver": 8,
    "lastname": 5,
    "phone": 7,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1890
schema_scan_id: 161404820
updated: 2026-04-03 05:12:24

Schema Scans: 15

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

Scan 162169280

duration: 0:00:12.142562

exit_message:

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

id: 162169280

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_guests/2026-04-17/1776419646",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-17/1776419646/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3936481097399373438,
        "service_name": "drive-thru",
        "span_id": 15350754736098821070,
        "trace_id": 489366406527345835
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-17 04:55:55
success: True
trace_id: 489366406527345835

Scan 162114369

duration: 0:00:14.661194

exit_message:

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

id: 162114369

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_guests/2026-04-16/1776334545",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-16/1776334545/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15197432576152517263,
        "service_name": "drive-thru",
        "span_id": 17789186231968491548,
        "trace_id": 1622059960011468802
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-16 05:16:18
success: True
trace_id: 1622059960011468802

Scan 162056330

duration: 0:00:14.639723

exit_message:

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

id: 162056330

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_guests/2026-04-15/1776242355",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-15/1776242355/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6495707263763662893,
        "service_name": "drive-thru",
        "span_id": 8978264021960331095,
        "trace_id": 2872004950494009410
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-15 03:39:38
success: True
trace_id: 2872004950494009410

Scan 162003120

duration: 0:00:14.583971

exit_message:

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

id: 162003120

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_guests/2026-04-14/1776160758",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-14/1776160758/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17052848357217100608,
        "service_name": "drive-thru",
        "span_id": 10371986080179499801,
        "trace_id": 3959754008909366792
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-14 05:04:15
success: True
trace_id: 3959754008909366792

Scan 161945315

duration: 0:00:12.006886

exit_message:

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

id: 161945315

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_guests/2026-04-13/1776074797",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-13/1776074797/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6399365692665343795,
        "service_name": "drive-thru",
        "span_id": 1910618726406486300,
        "trace_id": 17394558355143787334
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-13 05:08:39
success: True
trace_id: 17394558355143787334

Scan 161896335

duration: 0:00:14.665049

exit_message:

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

id: 161896335

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_guests/2026-04-12/1775988155",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-12/1775988155/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10479145419896690334,
        "service_name": "drive-thru",
        "span_id": 3237930452152532205,
        "trace_id": 1033829702510440774
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-12 05:03:54
success: True
trace_id: 1033829702510440774

Scan 161843995

duration: 0:00:12.096228

exit_message:

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

id: 161843995

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_guests/2026-04-11/1775902576",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-11/1775902576/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13211061992946159402,
        "service_name": "drive-thru",
        "span_id": 5494932322418085480,
        "trace_id": 14722464370282929680
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-11 05:20:13
success: True
trace_id: 14722464370282929680

Scan 161788540

duration: 0:00:14.715441

exit_message:

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

id: 161788540

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_guests/2026-04-10/1775815210",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-10/1775815210/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9447388567813665677,
        "service_name": "drive-thru",
        "span_id": 17290034871627960874,
        "trace_id": 8496319698280280325
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-10 05:00:39
success: True
trace_id: 8496319698280280325

Scan 161732916

duration: 0:00:14.811495

exit_message:

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

id: 161732916

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_guests/2026-04-09/1775728833",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-09/1775728833/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8133575564948791506,
        "service_name": "drive-thru",
        "span_id": 13292260504975769579,
        "trace_id": 14718258152954452090
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-09 05:00:55
success: True
trace_id: 14718258152954452090

Scan 161678418

duration: 0:00:14.656294

exit_message:

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

id: 161678418

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_guests/2026-04-08/1775642998",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-08/1775642998/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9927882742740118209,
        "service_name": "drive-thru",
        "span_id": 16286383519947357371,
        "trace_id": 6259429922602113503
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-08 05:15:06
success: True
trace_id: 6259429922602113503

Scan 161622066

duration: 0:00:12.091559

exit_message:

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

id: 161622066

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_guests/2026-04-07/1775556852",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-07/1775556852/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15571152680846437192,
        "service_name": "drive-thru",
        "span_id": 8546408287883156904,
        "trace_id": 8370949327476196273
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-07 05:15:04
success: True
trace_id: 8370949327476196273

Scan 161564226

duration: 0:00:14.650804

exit_message:

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

id: 161564226

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_guests/2026-04-06/1775470527",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-06/1775470527/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14465261241279728243,
        "service_name": "drive-thru",
        "span_id": 10367106041668451801,
        "trace_id": 477646595538916757
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-06 05:16:05
success: True
trace_id: 477646595538916757

Scan 161516506

duration: 0:00:14.662726

exit_message:

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

id: 161516506

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_guests/2026-04-05/1775382945",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-05/1775382945/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3859763929637665971,
        "service_name": "drive-thru",
        "span_id": 6560017204264320579,
        "trace_id": 1678060966596826764
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-05 04:56:11
success: True
trace_id: 1678060966596826764

Scan 161462113

duration: 0:00:14.654571

exit_message:

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

id: 161462113

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_guests/2026-04-04/1775296468",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-04/1775296468/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12001134057753267271,
        "service_name": "drive-thru",
        "span_id": 16470339604580223053,
        "trace_id": 15423146998543311403
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-04 04:55:54
success: True
trace_id: 15423146998543311403

Scan 161404820

duration: 0:00:14.680247

exit_message:

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

id: 161404820

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_guests/2026-04-03/1775211036",
        "key": "raw/stellar_imsbooking_boat_guests/2026-04-03/1775211036/booking_boat_guests.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_guests",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7571814699279709164,
        "service_name": "drive-thru",
        "span_id": 9693205431313120422,
        "trace_id": 12208786481174867906
    }
}

running: False
schema_name_id: 1890
start_time: 2026-04-03 05:12:10
success: True
trace_id: 12208786481174867906

Partitions:

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

Schema:

attributes:

{
    "billing_city": "string",
    "billing_country": "string",
    "billing_state": "string",
    "billing_street1": "string",
    "billing_street2": "string",
    "billing_zip": "string",
    "booking_boat_id": "string",
    "created_at": "string",
    "customer_id": "string",
    "dob": "string",
    "email": "string",
    "firstname": "string",
    "id": "string",
    "is_driver": "string",
    "lastname": "string",
    "phone": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:55:56

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_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
}

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:49",
        "disabled": false,
        "format": "raw",
        "id": 1890,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsbooking_boat_guests"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "billing_city": "string",
            "billing_country": "string",
            "billing_state": "string",
            "billing_street1": "string",
            "billing_street2": "string",
            "billing_zip": "string",
            "booking_boat_id": "string",
            "created_at": "string",
            "customer_id": "string",
            "dob": "string",
            "email": "string",
            "firstname": "string",
            "id": "string",
            "is_driver": "string",
            "lastname": "string",
            "phone": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:55:56",
        "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_guests`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `customer_id`  string , `firstname`  string , `lastname`  string , `email`  string , `phone`  string , `is_driver`  string , `dob`  string , `billing_street1`  string , `billing_street2`  string , `billing_city`  string , `billing_state`  string , `billing_country`  string , `billing_zip`  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_guests/2026-04-17/1776419646'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_guests`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_guests"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}