Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsstyle_groups

created: 2023-02-07 01:48:38
disabled: False
format: raw
id: 1501
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717992

created: 2026-04-17 04:57:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-17/1776419652
id: 1717992
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 162169331
updated: 2026-04-17 04:57:59

Version 1716759

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-16/1776334553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-16/1776334553
id: 1716759
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 162114428
updated: 2026-04-16 05:18:45

Version 1715558

created: 2026-04-15 03:44:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-15/1776242367'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-15/1776242367
id: 1715558
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 162056446
updated: 2026-04-15 03:44:15

Version 1714409

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-14/1776160762'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-14/1776160762
id: 1714409
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 162003150
updated: 2026-04-14 05:05:22

Version 1713153

created: 2026-04-13 05:10:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-13/1776074807'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-13/1776074807
id: 1713153
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161945361
updated: 2026-04-13 05:10:29

Version 1711915

created: 2026-04-12 05:04:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-12/1775988165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-12/1775988165
id: 1711915
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161896364
updated: 2026-04-12 05:05:09

Version 1710749

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-11/1775902580'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-11/1775902580
id: 1710749
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161843968
updated: 2026-04-11 05:19:28

Version 1709563

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

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

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161788604
updated: 2026-04-10 05:03:04

Version 1708460

created: 2026-04-09 05:04:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-09/1775728842'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-09/1775728842
id: 1708460
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161733024
updated: 2026-04-09 05:04:57

Version 1707230

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

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

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161678389
updated: 2026-04-08 05:14:11

Version 1706032

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-07/1775556862'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-07/1775556862
id: 1706032
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161622110
updated: 2026-04-07 05:16:52

Version 1704829

created: 2026-04-06 05:18:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-06/1775470537'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-06/1775470537
id: 1704829
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161564304
updated: 2026-04-06 05:19:07

Version 1703607

created: 2026-04-05 04:58:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-05/1775382950'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-05/1775382950
id: 1703607
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161516612
updated: 2026-04-05 04:59:03

Version 1702400

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-04/1775296464'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-04/1775296464
id: 1702400
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161462101
updated: 2026-04-04 04:55:42

Version 1701269

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-03/1775211040'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_groups/2026-04-03/1775211040
id: 1701269
processed: 1

raw_data:

{
    "created_at": 10,
    "frontend_max_same_departures": 4,
    "group_name": 3,
    "id": 1,
    "location_id": 2,
    "safety_test_enabled": 5,
    "safety_test_expiration_days": 8,
    "safety_test_instructions": 6,
    "safety_test_min_percent_pass": 7,
    "safety_video_link": 9,
    "tenant": 0,
    "updated_at": 11
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1501
schema_scan_id: 161404867
updated: 2026-04-03 05:14:09

Schema Scans: 15

Last at 2026-04-17 04:57:47

Scan 162169331

duration: 0:00:11.975950

exit_message:

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

id: 162169331

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_imsstyle_groups/2026-04-17/1776419652",
        "key": "raw/stellar_imsstyle_groups/2026-04-17/1776419652/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9047165375520456746,
        "service_name": "drive-thru",
        "span_id": 12591912084640303912,
        "trace_id": 11726080186338062425
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-17 04:57:47
success: True
trace_id: 11726080186338062425

Scan 162114428

duration: 0:00:12.149097

exit_message:

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

id: 162114428

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_imsstyle_groups/2026-04-16/1776334553",
        "key": "raw/stellar_imsstyle_groups/2026-04-16/1776334553/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12087778278624304679,
        "service_name": "drive-thru",
        "span_id": 9734650034772245195,
        "trace_id": 19942180083073281
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-16 05:18:33
success: True
trace_id: 19942180083073281

Scan 162056446

duration: 0:00:12.115136

exit_message:

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

id: 162056446

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_imsstyle_groups/2026-04-15/1776242367",
        "key": "raw/stellar_imsstyle_groups/2026-04-15/1776242367/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2062995771198547001,
        "service_name": "drive-thru",
        "span_id": 3734431229361331562,
        "trace_id": 6114475647706783470
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-15 03:44:03
success: True
trace_id: 6114475647706783470

Scan 162003150

duration: 0:00:12.095847

exit_message:

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

id: 162003150

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_imsstyle_groups/2026-04-14/1776160762",
        "key": "raw/stellar_imsstyle_groups/2026-04-14/1776160762/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10834451091381048292,
        "service_name": "drive-thru",
        "span_id": 9375866988607470105,
        "trace_id": 5254740003127826527
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-14 05:05:10
success: True
trace_id: 5254740003127826527

Scan 161945361

duration: 0:00:12.180739

exit_message:

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

id: 161945361

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_imsstyle_groups/2026-04-13/1776074807",
        "key": "raw/stellar_imsstyle_groups/2026-04-13/1776074807/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12564951559909528493,
        "service_name": "drive-thru",
        "span_id": 15157942600743070428,
        "trace_id": 1866662481675468735
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-13 05:10:17
success: True
trace_id: 1866662481675468735

Scan 161896364

duration: 0:00:12.077562

exit_message:

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

id: 161896364

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_imsstyle_groups/2026-04-12/1775988165",
        "key": "raw/stellar_imsstyle_groups/2026-04-12/1775988165/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16022511091517618039,
        "service_name": "drive-thru",
        "span_id": 473199776920540264,
        "trace_id": 17271095030079985177
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-12 05:04:57
success: True
trace_id: 17271095030079985177

Scan 161843968

duration: 0:00:12.124076

exit_message:

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

id: 161843968

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_imsstyle_groups/2026-04-11/1775902580",
        "key": "raw/stellar_imsstyle_groups/2026-04-11/1775902580/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11206083761858951354,
        "service_name": "drive-thru",
        "span_id": 2170232613955385816,
        "trace_id": 497489531085723957
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-11 05:19:16
success: True
trace_id: 497489531085723957

Scan 161788604

duration: 0:00:14.684803

exit_message:

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

id: 161788604

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_imsstyle_groups/2026-04-10/1775815220",
        "key": "raw/stellar_imsstyle_groups/2026-04-10/1775815220/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6709233656444080373,
        "service_name": "drive-thru",
        "span_id": 11237361682923312539,
        "trace_id": 14570634738264088845
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-10 05:02:49
success: True
trace_id: 14570634738264088845

Scan 161733024

duration: 0:00:14.647564

exit_message:

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

id: 161733024

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_imsstyle_groups/2026-04-09/1775728842",
        "key": "raw/stellar_imsstyle_groups/2026-04-09/1775728842/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15620775415643876100,
        "service_name": "drive-thru",
        "span_id": 6304149816526780283,
        "trace_id": 8220347118956794035
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-09 05:04:42
success: True
trace_id: 8220347118956794035

Scan 161678389

duration: 0:00:14.573104

exit_message:

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

id: 161678389

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_imsstyle_groups/2026-04-08/1775642998",
        "key": "raw/stellar_imsstyle_groups/2026-04-08/1775642998/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5153344671583105755,
        "service_name": "drive-thru",
        "span_id": 17679347572950484679,
        "trace_id": 3707539143982226356
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-08 05:13:56
success: True
trace_id: 3707539143982226356

Scan 161622110

duration: 0:00:12.151491

exit_message:

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

id: 161622110

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_imsstyle_groups/2026-04-07/1775556862",
        "key": "raw/stellar_imsstyle_groups/2026-04-07/1775556862/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14957083535290934909,
        "service_name": "drive-thru",
        "span_id": 17032687263812335028,
        "trace_id": 15929660660490550220
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-07 05:16:40
success: True
trace_id: 15929660660490550220

Scan 161564304

duration: 0:00:11.986820

exit_message:

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

id: 161564304

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_imsstyle_groups/2026-04-06/1775470537",
        "key": "raw/stellar_imsstyle_groups/2026-04-06/1775470537/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17108423484845733577,
        "service_name": "drive-thru",
        "span_id": 6827727636869642434,
        "trace_id": 13132085883882627418
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-06 05:18:56
success: True
trace_id: 13132085883882627418

Scan 161516612

duration: 0:00:12.152320

exit_message:

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

id: 161516612

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_imsstyle_groups/2026-04-05/1775382950",
        "key": "raw/stellar_imsstyle_groups/2026-04-05/1775382950/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8308373297152628381,
        "service_name": "drive-thru",
        "span_id": 6407691715269836017,
        "trace_id": 6188797449368792771
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-05 04:58:51
success: True
trace_id: 6188797449368792771

Scan 161462101

duration: 0:00:14.626762

exit_message:

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

id: 161462101

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_imsstyle_groups/2026-04-04/1775296464",
        "key": "raw/stellar_imsstyle_groups/2026-04-04/1775296464/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 418183867115255638,
        "service_name": "drive-thru",
        "span_id": 9030747108477649342,
        "trace_id": 268230326424237674
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-04 04:55:27
success: True
trace_id: 268230326424237674

Scan 161404867

duration: 0:00:14.523398

exit_message:

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

id: 161404867

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_imsstyle_groups/2026-04-03/1775211040",
        "key": "raw/stellar_imsstyle_groups/2026-04-03/1775211040/style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11613170538122758876,
        "service_name": "drive-thru",
        "span_id": 11832152959296338522,
        "trace_id": 16872077917306252728
    }
}

running: False
schema_name_id: 1501
start_time: 2026-04-03 05:13:54
success: True
trace_id: 16872077917306252728

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "2022_03_10_07_19_02": "string",
    "2022_03_10_07_19_08": "string",
    "2022_03_10_07_19_13": "string",
    "2022_03_10_07_19_13_4": "string",
    "2022_03_10_07_19_20": "string",
    "2022_03_10_07_19_31": "string",
    "2022_03_20_08_00_11_3": "string",
    "2022_03_20_15_18_08_2": "string",
    "Boats": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "No": "string",
    "Watersports": "string",
    "created_at": "string",
    "frontend_max_same_departures": "string",
    "group_name": "string",
    "id": "string",
    "location_id": "string",
    "safety_test_enabled": "string",
    "safety_test_expiration_days": "string",
    "safety_test_instructions": "string",
    "safety_test_min_percent_pass": "string",
    "safety_video_link": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

created: 2026-04-17 04:57:48

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
}

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:48:38",
        "disabled": false,
        "format": "raw",
        "id": 1501,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsstyle_groups"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "2022_03_10_07_19_02": "string",
            "2022_03_10_07_19_08": "string",
            "2022_03_10_07_19_13": "string",
            "2022_03_10_07_19_13_4": "string",
            "2022_03_10_07_19_20": "string",
            "2022_03_10_07_19_31": "string",
            "2022_03_20_08_00_11_3": "string",
            "2022_03_20_15_18_08_2": "string",
            "Boats": "string",
            "Jetskis": "string",
            "Kayaks": "string",
            "No": "string",
            "Watersports": "string",
            "created_at": "string",
            "frontend_max_same_departures": "string",
            "group_name": "string",
            "id": "string",
            "location_id": "string",
            "safety_test_enabled": "string",
            "safety_test_expiration_days": "string",
            "safety_test_instructions": "string",
            "safety_test_min_percent_pass": "string",
            "safety_video_link": "string",
            "tenant": "string",
            "updated_at": "string",
            "updated_at_1": "string"
        },
        "created": "2026-04-17 04:57:48",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_groups`\n(\n `tenant`  string , `id`  string , `location_id`  string , `group_name`  string , `frontend_max_same_departures`  string , `safety_test_enabled`  string , `safety_test_instructions`  string , `safety_test_min_percent_pass`  string , `safety_test_expiration_days`  string , `safety_video_link`  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_imsstyle_groups/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_groups`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_groups"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}