Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsliability_waivers

created: 2024-07-30 04:33:55
disabled: False
format: raw
id: 1976
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717931

created: 2026-04-17 04:55:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-17/1776419648
id: 1717931
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 162169267
updated: 2026-04-17 04:55:41

Version 1716732

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-16/1776334548'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-16/1776334548
id: 1716732
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 162114401
updated: 2026-04-16 05:17:45

Version 1715491

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-15/1776242362'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-15/1776242362
id: 1715491
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 162056374
updated: 2026-04-15 03:41:32

Version 1714329

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-14/1776160757
id: 1714329
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 162002986
updated: 2026-04-14 05:01:49

Version 1713126

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-13/1776074802'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-13/1776074802
id: 1713126
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161945332
updated: 2026-04-13 05:09:33

Version 1711927

created: 2026-04-12 05:05:35

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-12/1775988159'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-12/1775988159
id: 1711927
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161896376
updated: 2026-04-12 05:05:49

Version 1710700

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-11/1775902577
id: 1710700
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161843919
updated: 2026-04-11 05:17:38

Version 1709513

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-10/1775815217'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

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

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161788551
updated: 2026-04-10 05:01:11

Version 1708426

created: 2026-04-09 05:03:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-09/1775728839'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

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

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161732987
updated: 2026-04-09 05:03:35

Version 1707283

created: 2026-04-08 05:16:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-08/1775643004'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-08/1775643004
id: 1707283
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161678445
updated: 2026-04-08 05:16:14

Version 1706080

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-07/1775556857'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-07/1775556857
id: 1706080
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161622173
updated: 2026-04-07 05:19:00

Version 1704791

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-06/1775470532'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-06/1775470532
id: 1704791
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161564262
updated: 2026-04-06 05:17:41

Version 1703577

created: 2026-04-05 04:57:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

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

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161516569
updated: 2026-04-05 04:58:01

Version 1702468

created: 2026-04-04 04:57:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-04/1775296473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsliability_waivers/2026-04-04/1775296473
id: 1702468
processed: 1

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161462177
updated: 2026-04-04 04:58:10

Version 1701229

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-03/1775211037'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
]

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

raw_data:

{
    "created_at": 12,
    "created_by": 10,
    "guest_type": 6,
    "id": 1,
    "location_id": 3,
    "name": 2,
    "policies_html": 7,
    "status": 8,
    "style_group_id": 4,
    "style_id": 5,
    "tenant": 0,
    "tile_to_pdf": 9,
    "updated_at": 13,
    "updated_by": 11
}

schema_attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

schema_name_id: 1976
schema_scan_id: 161404827
updated: 2026-04-03 05:12:39

Schema Scans: 15

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

Scan 162169267

duration: 0:00:14.622374

exit_message:

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

id: 162169267

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_imsliability_waivers/2026-04-17/1776419648",
        "key": "raw/stellar_imsliability_waivers/2026-04-17/1776419648/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16251801633114992518,
        "service_name": "drive-thru",
        "span_id": 11424645838203886941,
        "trace_id": 9972217998625134969
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-17 04:55:26
success: True
trace_id: 9972217998625134969

Scan 162114401

duration: 0:00:12.150619

exit_message:

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

id: 162114401

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_imsliability_waivers/2026-04-16/1776334548",
        "key": "raw/stellar_imsliability_waivers/2026-04-16/1776334548/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1416394916097862832,
        "service_name": "drive-thru",
        "span_id": 14635107953691314555,
        "trace_id": 18403157686793569783
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-16 05:17:33
success: True
trace_id: 18403157686793569783

Scan 162056374

duration: 0:00:11.947154

exit_message:

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

id: 162056374

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_imsliability_waivers/2026-04-15/1776242362",
        "key": "raw/stellar_imsliability_waivers/2026-04-15/1776242362/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3320559378244558769,
        "service_name": "drive-thru",
        "span_id": 14745729933730827141,
        "trace_id": 5170675317716183894
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-15 03:41:20
success: True
trace_id: 5170675317716183894

Scan 162002986

duration: 0:00:14.587385

exit_message:

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

id: 162002986

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_imsliability_waivers/2026-04-14/1776160757",
        "key": "raw/stellar_imsliability_waivers/2026-04-14/1776160757/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15959731422748988883,
        "service_name": "drive-thru",
        "span_id": 7298947836659839388,
        "trace_id": 3560343884003130095
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-14 05:01:34
success: True
trace_id: 3560343884003130095

Scan 161945332

duration: 0:00:14.444417

exit_message:

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

id: 161945332

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_imsliability_waivers/2026-04-13/1776074802",
        "key": "raw/stellar_imsliability_waivers/2026-04-13/1776074802/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6014090861287080172,
        "service_name": "drive-thru",
        "span_id": 7003626647623474097,
        "trace_id": 15338849124083636507
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-13 05:09:18
success: True
trace_id: 15338849124083636507

Scan 161896376

duration: 0:00:14.427261

exit_message:

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

id: 161896376

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_imsliability_waivers/2026-04-12/1775988159",
        "key": "raw/stellar_imsliability_waivers/2026-04-12/1775988159/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17429062918862552573,
        "service_name": "drive-thru",
        "span_id": 17387606121598764670,
        "trace_id": 16024524005742533139
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-12 05:05:34
success: True
trace_id: 16024524005742533139

Scan 161843919

duration: 0:00:14.541106

exit_message:

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

id: 161843919

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_imsliability_waivers/2026-04-11/1775902577",
        "key": "raw/stellar_imsliability_waivers/2026-04-11/1775902577/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9649459841285959406,
        "service_name": "drive-thru",
        "span_id": 8342200734762298986,
        "trace_id": 7788175393614094612
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-11 05:17:23
success: True
trace_id: 7788175393614094612

Scan 161788551

duration: 0:00:14.582520

exit_message:

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

id: 161788551

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_imsliability_waivers/2026-04-10/1775815217",
        "key": "raw/stellar_imsliability_waivers/2026-04-10/1775815217/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6907167333118891654,
        "service_name": "drive-thru",
        "span_id": 1453793446643795536,
        "trace_id": 4191040544061044634
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-10 05:00:57
success: True
trace_id: 4191040544061044634

Scan 161732987

duration: 0:00:14.459754

exit_message:

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

id: 161732987

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_imsliability_waivers/2026-04-09/1775728839",
        "key": "raw/stellar_imsliability_waivers/2026-04-09/1775728839/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12689097853097519413,
        "service_name": "drive-thru",
        "span_id": 2779528131984500560,
        "trace_id": 14625791146456828206
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-09 05:03:21
success: True
trace_id: 14625791146456828206

Scan 161678445

duration: 0:00:11.947393

exit_message:

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

id: 161678445

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_imsliability_waivers/2026-04-08/1775643004",
        "key": "raw/stellar_imsliability_waivers/2026-04-08/1775643004/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15467766828460781566,
        "service_name": "drive-thru",
        "span_id": 11384628375780524463,
        "trace_id": 6165036864248796712
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-08 05:16:02
success: True
trace_id: 6165036864248796712

Scan 161622173

duration: 0:00:14.556068

exit_message:

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

id: 161622173

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_imsliability_waivers/2026-04-07/1775556857",
        "key": "raw/stellar_imsliability_waivers/2026-04-07/1775556857/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16514498420737035725,
        "service_name": "drive-thru",
        "span_id": 18198409394797366746,
        "trace_id": 8202666996161526121
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-07 05:18:45
success: True
trace_id: 8202666996161526121

Scan 161564262

duration: 0:00:11.835065

exit_message:

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

id: 161564262

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_imsliability_waivers/2026-04-06/1775470532",
        "key": "raw/stellar_imsliability_waivers/2026-04-06/1775470532/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10971734446287763293,
        "service_name": "drive-thru",
        "span_id": 12054337580773196009,
        "trace_id": 241797415428346136
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-06 05:17:30
success: True
trace_id: 241797415428346136

Scan 161516569

duration: 0:00:14.434998

exit_message:

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

id: 161516569

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_imsliability_waivers/2026-04-05/1775382945",
        "key": "raw/stellar_imsliability_waivers/2026-04-05/1775382945/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16968447656119722971,
        "service_name": "drive-thru",
        "span_id": 12239031693204102757,
        "trace_id": 16551966540735985744
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-05 04:57:46
success: True
trace_id: 16551966540735985744

Scan 161462177

duration: 0:00:14.587904

exit_message:

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

id: 161462177

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_imsliability_waivers/2026-04-04/1775296473",
        "key": "raw/stellar_imsliability_waivers/2026-04-04/1775296473/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9798995918248239398,
        "service_name": "drive-thru",
        "span_id": 11821512097336862697,
        "trace_id": 1969283367872123502
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-04 04:57:55
success: True
trace_id: 1969283367872123502

Scan 161404827

duration: 0:00:12.008447

exit_message:

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

id: 161404827

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_imsliability_waivers/2026-04-03/1775211037",
        "key": "raw/stellar_imsliability_waivers/2026-04-03/1775211037/liability_waivers.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsliability_waivers",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5601088815388695412,
        "service_name": "drive-thru",
        "span_id": 13332244797417671000,
        "trace_id": 13318187807073928935
    }
}

running: False
schema_name_id: 1976
start_time: 2026-04-03 05:12:27
success: True
trace_id: 13318187807073928935

Partitions:

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

Schema:

attributes:

{
    "created_at": "string",
    "created_by": "string",
    "guest_type": "string",
    "id": "string",
    "location_id": "string",
    "name": "string",
    "policies_html": "string",
    "status": "string",
    "style_group_id": "string",
    "style_id": "string",
    "tenant": "string",
    "tile_to_pdf": "string",
    "updated_at": "string",
    "updated_by": "string"
}

created: 2026-04-17 04:55:27

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
}

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-07-30 04:33:55",
        "disabled": false,
        "format": "raw",
        "id": 1976,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsliability_waivers"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "created_at": "string",
            "created_by": "string",
            "guest_type": "string",
            "id": "string",
            "location_id": "string",
            "name": "string",
            "policies_html": "string",
            "status": "string",
            "style_group_id": "string",
            "style_id": "string",
            "tenant": "string",
            "tile_to_pdf": "string",
            "updated_at": "string",
            "updated_by": "string"
        },
        "created": "2026-04-17 04:55:27",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsliability_waivers`\n(\n `tenant`  string , `id`  string , `name`  string , `location_id`  string , `style_group_id`  string , `style_id`  string , `guest_type`  string , `policies_html`  string , `status`  string , `tile_to_pdf`  string , `created_by`  string , `updated_by`  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_imsliability_waivers/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsliability_waivers`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsliability_waivers"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}