Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsclosed_dates

created: 2023-02-07 01:47:26
disabled: False
format: raw
id: 1479
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718003

created: 2026-04-17 04:58:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclosed_dates/2026-04-17/1776419649
id: 1718003
processed: 1

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 162169344
updated: 2026-04-17 04:58:25

Version 1716714

created: 2026-04-16 05:16:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

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

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 162114383
updated: 2026-04-16 05:17:03

Version 1715511

created: 2026-04-15 03:42:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-15/1776242358'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclosed_dates/2026-04-15/1776242358
id: 1715511
processed: 1

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 162056396
updated: 2026-04-15 03:42:15

Version 1714395

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-14/1776160755'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

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

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 162003130
updated: 2026-04-14 05:04:49

Version 1713130

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-13/1776074799'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclosed_dates/2026-04-13/1776074799
id: 1713130
processed: 1

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161945336
updated: 2026-04-13 05:09:35

Version 1711937

created: 2026-04-12 05:06:05

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-12/1775988157'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

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

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161896389
updated: 2026-04-12 05:06:16

Version 1710786

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-11/1775902579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclosed_dates/2026-04-11/1775902579
id: 1710786
processed: 1

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161844017
updated: 2026-04-11 05:21:04

Version 1709571

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclosed_dates/2026-04-10/1775815220
id: 1709571
processed: 1

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161788613
updated: 2026-04-10 05:03:24

Version 1708401

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-09/1775728841'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclosed_dates/2026-04-09/1775728841
id: 1708401
processed: 1

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161732959
updated: 2026-04-09 05:02:33

Version 1707210

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-08/1775643000'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

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

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161678369
updated: 2026-04-08 05:13:13

Version 1706028

created: 2026-04-07 05:16:38

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

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

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161622106
updated: 2026-04-07 05:16:49

Version 1704802

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclosed_dates/2026-04-06/1775470528
id: 1704802
processed: 1

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161564275
updated: 2026-04-06 05:18:06

Version 1703570

created: 2026-04-05 04:57:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

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

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161516560
updated: 2026-04-05 04:57:43

Version 1702454

created: 2026-04-04 04:57:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-04/1775296469'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsclosed_dates/2026-04-04/1775296469
id: 1702454
processed: 1

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161462156
updated: 2026-04-04 04:57:37

Version 1701233

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-03/1775211036'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
]

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

raw_data:

{
    "allow_backend_departures": 4,
    "allow_backend_returns": 5,
    "allow_frontend_departures": 6,
    "allow_frontend_returns": 7,
    "closed_date": 3,
    "created_at": 8,
    "id": 1,
    "location_id": 2,
    "tenant": 0,
    "updated_at": 9
}

schema_attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

schema_name_id: 1479
schema_scan_id: 161404831
updated: 2026-04-03 05:12:43

Schema Scans: 15

Last at 2026-04-17 04:58:13

Scan 162169344

duration: 0:00:11.872597

exit_message:

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

id: 162169344

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_imsclosed_dates/2026-04-17/1776419649",
        "key": "raw/stellar_imsclosed_dates/2026-04-17/1776419649/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11008586042463842798,
        "service_name": "drive-thru",
        "span_id": 13706462313978515610,
        "trace_id": 8576571343773170347
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-17 04:58:13
success: True
trace_id: 8576571343773170347

Scan 162114383

duration: 0:00:14.607162

exit_message:

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

id: 162114383

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_imsclosed_dates/2026-04-16/1776334545",
        "key": "raw/stellar_imsclosed_dates/2026-04-16/1776334545/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 338634792686789611,
        "service_name": "drive-thru",
        "span_id": 1938423193129952929,
        "trace_id": 13891954349941469944
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-16 05:16:48
success: True
trace_id: 13891954349941469944

Scan 162056396

duration: 0:00:11.782342

exit_message:

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

id: 162056396

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_imsclosed_dates/2026-04-15/1776242358",
        "key": "raw/stellar_imsclosed_dates/2026-04-15/1776242358/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16087095041239311088,
        "service_name": "drive-thru",
        "span_id": 8379603218772397585,
        "trace_id": 16408956691193537632
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-15 03:42:03
success: True
trace_id: 16408956691193537632

Scan 162003130

duration: 0:00:14.351320

exit_message:

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

id: 162003130

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_imsclosed_dates/2026-04-14/1776160755",
        "key": "raw/stellar_imsclosed_dates/2026-04-14/1776160755/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2692362041577269769,
        "service_name": "drive-thru",
        "span_id": 10731144480307960506,
        "trace_id": 1743773911174604116
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-14 05:04:34
success: True
trace_id: 1743773911174604116

Scan 161945336

duration: 0:00:14.380145

exit_message:

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

id: 161945336

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_imsclosed_dates/2026-04-13/1776074799",
        "key": "raw/stellar_imsclosed_dates/2026-04-13/1776074799/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10856623706549880123,
        "service_name": "drive-thru",
        "span_id": 12654228155492122790,
        "trace_id": 10014167592337625464
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-13 05:09:21
success: True
trace_id: 10014167592337625464

Scan 161896389

duration: 0:00:11.774315

exit_message:

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

id: 161896389

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_imsclosed_dates/2026-04-12/1775988157",
        "key": "raw/stellar_imsclosed_dates/2026-04-12/1775988157/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12439214409037573246,
        "service_name": "drive-thru",
        "span_id": 14483071124680380262,
        "trace_id": 7749997517314502319
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-12 05:06:04
success: True
trace_id: 7749997517314502319

Scan 161844017

duration: 0:00:14.413734

exit_message:

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

id: 161844017

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_imsclosed_dates/2026-04-11/1775902579",
        "key": "raw/stellar_imsclosed_dates/2026-04-11/1775902579/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16777835301865958101,
        "service_name": "drive-thru",
        "span_id": 171803963736124552,
        "trace_id": 4365013857871349896
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-11 05:20:50
success: True
trace_id: 4365013857871349896

Scan 161788613

duration: 0:00:11.872345

exit_message:

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

id: 161788613

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_imsclosed_dates/2026-04-10/1775815220",
        "key": "raw/stellar_imsclosed_dates/2026-04-10/1775815220/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2158459746253860589,
        "service_name": "drive-thru",
        "span_id": 12424637758665826958,
        "trace_id": 16416746933189808941
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-10 05:03:12
success: True
trace_id: 16416746933189808941

Scan 161732959

duration: 0:00:11.899177

exit_message:

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

id: 161732959

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_imsclosed_dates/2026-04-09/1775728841",
        "key": "raw/stellar_imsclosed_dates/2026-04-09/1775728841/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10739802780252504552,
        "service_name": "drive-thru",
        "span_id": 5312579368059146211,
        "trace_id": 17119118417478411692
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-09 05:02:21
success: True
trace_id: 17119118417478411692

Scan 161678369

duration: 0:00:11.850801

exit_message:

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

id: 161678369

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_imsclosed_dates/2026-04-08/1775643000",
        "key": "raw/stellar_imsclosed_dates/2026-04-08/1775643000/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7484155525353841434,
        "service_name": "drive-thru",
        "span_id": 17757659456116019443,
        "trace_id": 17807248066723237894
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-08 05:13:01
success: True
trace_id: 17807248066723237894

Scan 161622106

duration: 0:00:11.794422

exit_message:

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

id: 161622106

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_imsclosed_dates/2026-04-07/1775556856",
        "key": "raw/stellar_imsclosed_dates/2026-04-07/1775556856/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12206069983402558232,
        "service_name": "drive-thru",
        "span_id": 1741565313314028930,
        "trace_id": 10128631343343208381
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-07 05:16:37
success: True
trace_id: 10128631343343208381

Scan 161564275

duration: 0:00:11.928784

exit_message:

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

id: 161564275

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_imsclosed_dates/2026-04-06/1775470528",
        "key": "raw/stellar_imsclosed_dates/2026-04-06/1775470528/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13528328960470221868,
        "service_name": "drive-thru",
        "span_id": 4824876912123921259,
        "trace_id": 14603862876047859479
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-06 05:17:54
success: True
trace_id: 14603862876047859479

Scan 161516560

duration: 0:00:14.353931

exit_message:

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

id: 161516560

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_imsclosed_dates/2026-04-05/1775382945",
        "key": "raw/stellar_imsclosed_dates/2026-04-05/1775382945/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5427560869313639989,
        "service_name": "drive-thru",
        "span_id": 12995560962065563781,
        "trace_id": 9692501331029759255
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-05 04:57:29
success: True
trace_id: 9692501331029759255

Scan 161462156

duration: 0:00:11.823876

exit_message:

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

id: 161462156

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_imsclosed_dates/2026-04-04/1775296469",
        "key": "raw/stellar_imsclosed_dates/2026-04-04/1775296469/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10820508309352490888,
        "service_name": "drive-thru",
        "span_id": 10383491064878616100,
        "trace_id": 6206211632983604940
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-04 04:57:25
success: True
trace_id: 6206211632983604940

Scan 161404831

duration: 0:00:11.929527

exit_message:

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

id: 161404831

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_imsclosed_dates/2026-04-03/1775211036",
        "key": "raw/stellar_imsclosed_dates/2026-04-03/1775211036/closed_dates.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsclosed_dates",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1012398931653575854,
        "service_name": "drive-thru",
        "span_id": 3694330484079659757,
        "trace_id": 17121238660278351460
    }
}

running: False
schema_name_id: 1479
start_time: 2026-04-03 05:12:32
success: True
trace_id: 17121238660278351460

Partitions:

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

Schema:

attributes:

{
    "allow_backend_departures": "string",
    "allow_backend_returns": "string",
    "allow_frontend_departures": "string",
    "allow_frontend_returns": "string",
    "closed_date": "string",
    "created_at": "string",
    "id": "string",
    "location_id": "string",
    "tenant": "string",
    "updated_at": "string"
}

created: 2026-04-17 04:58:14

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:47:26",
        "disabled": false,
        "format": "raw",
        "id": 1479,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsclosed_dates"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "allow_backend_departures": "string",
            "allow_backend_returns": "string",
            "allow_frontend_departures": "string",
            "allow_frontend_returns": "string",
            "closed_date": "string",
            "created_at": "string",
            "id": "string",
            "location_id": "string",
            "tenant": "string",
            "updated_at": "string"
        },
        "created": "2026-04-17 04:58:14",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsclosed_dates`\n(\n `tenant`  string , `id`  string , `location_id`  string , `closed_date`  string , `allow_backend_departures`  string , `allow_backend_returns`  string , `allow_frontend_departures`  string , `allow_frontend_returns`  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_imsclosed_dates/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsclosed_dates`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsclosed_dates"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}