Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance

created: 2023-07-04 02:42:07
disabled: False
format: raw
id: 1542
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717941

created: 2026-04-17 04:55:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

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

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 162169278
updated: 2026-04-17 04:56:07

Version 1716733

created: 2026-04-16 05:17:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-16/1776334543'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

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

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 162114402
updated: 2026-04-16 05:17:45

Version 1715451

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-15/1776242356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

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

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 162056334
updated: 2026-04-15 03:40:03

Version 1714377

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-14/1776160756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

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

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 162003098
updated: 2026-04-14 05:04:03

Version 1713120

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-13/1776074798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_renters_insurance/2026-04-13/1776074798
id: 1713120
processed: 1

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161945326
updated: 2026-04-13 05:09:18

Version 1711883

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-12/1775988157'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_renters_insurance/2026-04-12/1775988157
id: 1711883
processed: 1

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161896316
updated: 2026-04-12 05:03:25

Version 1710679

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-11/1775902574'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_renters_insurance/2026-04-11/1775902574
id: 1710679
processed: 1

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161843898
updated: 2026-04-11 05:16:52

Version 1709535

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-10/1775815217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

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

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161788575
updated: 2026-04-10 05:02:01

Version 1708378

created: 2026-04-09 05:01:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-09/1775728838'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_renters_insurance/2026-04-09/1775728838
id: 1708378
processed: 1

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161732933
updated: 2026-04-09 05:01:44

Version 1707207

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_renters_insurance/2026-04-08/1775642999
id: 1707207
processed: 1

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161678366
updated: 2026-04-08 05:13:09

Version 1705980

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-07/1775556854'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_renters_insurance/2026-04-07/1775556854
id: 1705980
processed: 1

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161622058
updated: 2026-04-07 05:15:02

Version 1704798

created: 2026-04-06 05:17:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-06/1775470527'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

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

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161564271
updated: 2026-04-06 05:18:00

Version 1703539

created: 2026-04-05 04:56:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsbooking_boat_renters_insurance/2026-04-05/1775382946
id: 1703539
processed: 1

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161516505
updated: 2026-04-05 04:56:25

Version 1702404

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-04/1775296467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

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

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161462105
updated: 2026-04-04 04:55:45

Version 1701298

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-03/1775211036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
]

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

raw_data:

{
    "answers": 9,
    "boat_price": 10,
    "booking_boat_id": 2,
    "cc_fees": 16,
    "cc_saved_method_id": 22,
    "cc_saved_profile_id": 21,
    "certificate_date": 19,
    "commission": 15,
    "created_at": 23,
    "id": 1,
    "is_current": 20,
    "premium": 13,
    "premium_estimate_max": 12,
    "premium_estimate_min": 11,
    "premium_proposal_id": 4,
    "proposal_date": 18,
    "provider": 3,
    "reg_no": 6,
    "renter_certificate_id": 5,
    "status": 7,
    "tax": 14,
    "tenant": 0,
    "total": 17,
    "underwriting_decision": 8,
    "updated_at": 24
}

schema_attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

schema_name_id: 1542
schema_scan_id: 161404897
updated: 2026-04-03 05:15:20

Schema Scans: 15

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

Scan 162169278

duration: 0:00:14.758516

exit_message:

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

id: 162169278

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_renters_insurance/2026-04-17/1776419645",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-17/1776419645/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11905784209025988764,
        "service_name": "drive-thru",
        "span_id": 16501734419927752305,
        "trace_id": 14640647449032116164
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-17 04:55:52
success: True
trace_id: 14640647449032116164

Scan 162114402

duration: 0:00:12.295384

exit_message:

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

id: 162114402

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_renters_insurance/2026-04-16/1776334543",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-16/1776334543/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2703866270274687396,
        "service_name": "drive-thru",
        "span_id": 4600593004989912343,
        "trace_id": 1879610862516993151
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-16 05:17:33
success: True
trace_id: 1879610862516993151

Scan 162056334

duration: 0:00:12.310806

exit_message:

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

id: 162056334

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_renters_insurance/2026-04-15/1776242356",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-15/1776242356/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16280751376999015873,
        "service_name": "drive-thru",
        "span_id": 6808022852225874333,
        "trace_id": 12237255032298555116
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-15 03:39:51
success: True
trace_id: 12237255032298555116

Scan 162003098

duration: 0:00:12.263106

exit_message:

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

id: 162003098

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_renters_insurance/2026-04-14/1776160756",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-14/1776160756/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4792513855129433445,
        "service_name": "drive-thru",
        "span_id": 17815295667967914418,
        "trace_id": 10354163797663002131
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-14 05:03:50
success: True
trace_id: 10354163797663002131

Scan 161945326

duration: 0:00:14.774655

exit_message:

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

id: 161945326

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_renters_insurance/2026-04-13/1776074798",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-13/1776074798/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12860253518401448137,
        "service_name": "drive-thru",
        "span_id": 13872117910413207304,
        "trace_id": 4537538874640574384
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-13 05:09:04
success: True
trace_id: 4537538874640574384

Scan 161896316

duration: 0:00:14.744491

exit_message:

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

id: 161896316

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_renters_insurance/2026-04-12/1775988157",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-12/1775988157/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17558962898871928462,
        "service_name": "drive-thru",
        "span_id": 5560481006402491416,
        "trace_id": 11015313253923441896
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-12 05:03:10
success: True
trace_id: 11015313253923441896

Scan 161843898

duration: 0:00:14.818888

exit_message:

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

id: 161843898

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_renters_insurance/2026-04-11/1775902574",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-11/1775902574/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6436422539870301744,
        "service_name": "drive-thru",
        "span_id": 13965187760072759426,
        "trace_id": 9308419854910867191
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-11 05:16:38
success: True
trace_id: 9308419854910867191

Scan 161788575

duration: 0:00:12.361462

exit_message:

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

id: 161788575

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_renters_insurance/2026-04-10/1775815217",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-10/1775815217/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16149812152444462288,
        "service_name": "drive-thru",
        "span_id": 7104924320735532282,
        "trace_id": 10703095369729364582
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-10 05:01:49
success: True
trace_id: 10703095369729364582

Scan 161732933

duration: 0:00:14.791942

exit_message:

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

id: 161732933

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_renters_insurance/2026-04-09/1775728838",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-09/1775728838/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12817363212640671130,
        "service_name": "drive-thru",
        "span_id": 7156772951775988425,
        "trace_id": 10273556792275624734
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-09 05:01:29
success: True
trace_id: 10273556792275624734

Scan 161678366

duration: 0:00:14.826398

exit_message:

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

id: 161678366

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_renters_insurance/2026-04-08/1775642999",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-08/1775642999/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15695611280409400377,
        "service_name": "drive-thru",
        "span_id": 12960924373866526236,
        "trace_id": 16028586249729689952
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-08 05:12:54
success: True
trace_id: 16028586249729689952

Scan 161622058

duration: 0:00:12.205311

exit_message:

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

id: 161622058

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_renters_insurance/2026-04-07/1775556854",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-07/1775556854/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5744285194581220736,
        "service_name": "drive-thru",
        "span_id": 10109133905892820522,
        "trace_id": 7649476536913849164
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-07 05:14:50
success: True
trace_id: 7649476536913849164

Scan 161564271

duration: 0:00:12.297360

exit_message:

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

id: 161564271

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_renters_insurance/2026-04-06/1775470527",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-06/1775470527/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11399731438904951773,
        "service_name": "drive-thru",
        "span_id": 1684882957650500704,
        "trace_id": 7617800401106165303
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-06 05:17:47
success: True
trace_id: 7617800401106165303

Scan 161516505

duration: 0:00:14.774921

exit_message:

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

id: 161516505

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_renters_insurance/2026-04-05/1775382946",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-05/1775382946/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13918627282289896284,
        "service_name": "drive-thru",
        "span_id": 12394382426806299990,
        "trace_id": 11997277691542777234
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-05 04:56:10
success: True
trace_id: 11997277691542777234

Scan 161462105

duration: 0:00:12.413895

exit_message:

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

id: 161462105

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_renters_insurance/2026-04-04/1775296467",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-04/1775296467/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18375442881963864055,
        "service_name": "drive-thru",
        "span_id": 9352356340421110745,
        "trace_id": 12909625519300398239
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-04 04:55:33
success: True
trace_id: 12909625519300398239

Scan 161404897

duration: 0:00:14.925292

exit_message:

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

id: 161404897

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_renters_insurance/2026-04-03/1775211036",
        "key": "raw/stellar_imsbooking_boat_renters_insurance/2026-04-03/1775211036/booking_boat_renters_insurance.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5955150214453672249,
        "service_name": "drive-thru",
        "span_id": 3413592283476981957,
        "trace_id": 9605474714677624820
    }
}

running: False
schema_name_id: 1542
start_time: 2026-04-03 05:15:05
success: True
trace_id: 9605474714677624820

Partitions:

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

Schema:

attributes:

{
    "answers": "string",
    "boat_price": "string",
    "booking_boat_id": "string",
    "cc_fees": "string",
    "cc_saved_method_id": "string",
    "cc_saved_profile_id": "string",
    "certificate_date": "string",
    "commission": "string",
    "created_at": "string",
    "id": "string",
    "is_current": "string",
    "premium": "string",
    "premium_estimate_max": "string",
    "premium_estimate_min": "string",
    "premium_proposal_id": "string",
    "proposal_date": "string",
    "provider": "string",
    "reg_no": "string",
    "renter_certificate_id": "string",
    "status": "string",
    "tax": "string",
    "tenant": "string",
    "total": "string",
    "underwriting_decision": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:55:53

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_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-07-04 02:42:07",
        "disabled": false,
        "format": "raw",
        "id": 1542,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsbooking_boat_renters_insurance"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "answers": "string",
            "boat_price": "string",
            "booking_boat_id": "string",
            "cc_fees": "string",
            "cc_saved_method_id": "string",
            "cc_saved_profile_id": "string",
            "certificate_date": "string",
            "commission": "string",
            "created_at": "string",
            "id": "string",
            "is_current": "string",
            "premium": "string",
            "premium_estimate_max": "string",
            "premium_estimate_min": "string",
            "premium_proposal_id": "string",
            "proposal_date": "string",
            "provider": "string",
            "reg_no": "string",
            "renter_certificate_id": "string",
            "status": "string",
            "tax": "string",
            "tenant": "string",
            "total": "string",
            "underwriting_decision": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:55:53",
        "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_renters_insurance`\n(\n `tenant`  string , `id`  string , `booking_boat_id`  string , `provider`  string , `premium_proposal_id`  string , `renter_certificate_id`  string , `reg_no`  string , `status`  string , `underwriting_decision`  string , `answers`  string , `boat_price`  string , `premium_estimate_min`  string , `premium_estimate_max`  string , `premium`  string , `tax`  string , `commission`  string , `cc_fees`  string , `total`  string , `proposal_date`  string , `certificate_date`  string , `is_current`  string , `cc_saved_profile_id`  string , `cc_saved_method_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_renters_insurance/2026-04-17/1776419645'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsbooking_boat_renters_insurance"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}