Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imscategories

created: 2023-02-07 01:46:25
disabled: False
format: raw
id: 1458
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717971

created: 2026-04-17 04:57:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 162169309
updated: 2026-04-17 04:57:12

Version 1716695

created: 2026-04-16 05:16:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 162114364
updated: 2026-04-16 05:16:22

Version 1715489

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-15/1776242357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategories/2026-04-15/1776242357
id: 1715489
processed: 1

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 162056373
updated: 2026-04-15 03:41:28

Version 1714346

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-14/1776160756'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 162003027
updated: 2026-04-14 05:02:36

Version 1713115

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-13/1776074798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161945321
updated: 2026-04-13 05:09:03

Version 1711905

created: 2026-04-12 05:04:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-12/1775988155'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161896352
updated: 2026-04-12 05:04:42

Version 1710777

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-11/1775902578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategories/2026-04-11/1775902578
id: 1710777
processed: 1

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161844001
updated: 2026-04-11 05:20:37

Version 1709592

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161788639
updated: 2026-04-10 05:04:16

Version 1708419

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-09/1775728836'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategories/2026-04-09/1775728836
id: 1708419
processed: 1

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161732977
updated: 2026-04-09 05:03:12

Version 1707266

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161678426
updated: 2026-04-08 05:15:34

Version 1706029

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161622107
updated: 2026-04-07 05:16:50

Version 1704773

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-06/1775470528'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161564244
updated: 2026-04-06 05:17:01

Version 1703605

created: 2026-04-05 04:58:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161516608
updated: 2026-04-05 04:59:00

Version 1702463

created: 2026-04-04 04:57:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-04/1775296468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

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

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161462171
updated: 2026-04-04 04:57:55

Version 1701198

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-03/1775211033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategories/2026-04-03/1775211033
id: 1701198
processed: 1

raw_data:

{
    "calendar_banner_text": 12,
    "category_name": 3,
    "created_at": 16,
    "default_date_toggle": 13,
    "description": 14,
    "filter_unit_type_enabled": 8,
    "filter_unit_type_name": 9,
    "filter_unit_type_position": 10,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 7,
    "frontend_type": 6,
    "icon": 15,
    "id": 1,
    "location_id": 2,
    "min_nights_multi_day": 11,
    "tenant": 0,
    "updated_at": 17
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

schema_name_id: 1458
schema_scan_id: 161404795
updated: 2026-04-03 05:11:23

Schema Scans: 15

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

Scan 162169309

duration: 0:00:12.333955

exit_message:

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

id: 162169309

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_imscategories/2026-04-17/1776419648",
        "key": "raw/stellar_imscategories/2026-04-17/1776419648/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8811986533723822445,
        "service_name": "drive-thru",
        "span_id": 15789380502777806407,
        "trace_id": 7464280196468576394
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-17 04:57:00
success: True
trace_id: 7464280196468576394

Scan 162114364

duration: 0:00:12.474663

exit_message:

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

id: 162114364

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_imscategories/2026-04-16/1776334545",
        "key": "raw/stellar_imscategories/2026-04-16/1776334545/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18416603126936763872,
        "service_name": "drive-thru",
        "span_id": 7687301706879564696,
        "trace_id": 11474912091879467968
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-16 05:16:09
success: True
trace_id: 11474912091879467968

Scan 162056373

duration: 0:00:12.270197

exit_message:

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

id: 162056373

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_imscategories/2026-04-15/1776242357",
        "key": "raw/stellar_imscategories/2026-04-15/1776242357/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12686619795669132648,
        "service_name": "drive-thru",
        "span_id": 5195524966517952937,
        "trace_id": 16274716363285242861
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-15 03:41:16
success: True
trace_id: 16274716363285242861

Scan 162003027

duration: 0:00:14.880036

exit_message:

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

id: 162003027

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_imscategories/2026-04-14/1776160756",
        "key": "raw/stellar_imscategories/2026-04-14/1776160756/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 273242066498713339,
        "service_name": "drive-thru",
        "span_id": 5983737768966718301,
        "trace_id": 1797909679993857851
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-14 05:02:21
success: True
trace_id: 1797909679993857851

Scan 161945321

duration: 0:00:12.189036

exit_message:

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

id: 161945321

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_imscategories/2026-04-13/1776074798",
        "key": "raw/stellar_imscategories/2026-04-13/1776074798/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5814503778250574896,
        "service_name": "drive-thru",
        "span_id": 12634476419575572597,
        "trace_id": 5465046036103320533
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-13 05:08:51
success: True
trace_id: 5465046036103320533

Scan 161896352

duration: 0:00:12.352047

exit_message:

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

id: 161896352

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_imscategories/2026-04-12/1775988155",
        "key": "raw/stellar_imscategories/2026-04-12/1775988155/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13359689186095748405,
        "service_name": "drive-thru",
        "span_id": 17876526709327443500,
        "trace_id": 12561968038966897546
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-12 05:04:30
success: True
trace_id: 12561968038966897546

Scan 161844001

duration: 0:00:12.282741

exit_message:

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

id: 161844001

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_imscategories/2026-04-11/1775902578",
        "key": "raw/stellar_imscategories/2026-04-11/1775902578/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 755114851833144753,
        "service_name": "drive-thru",
        "span_id": 1173167088095809547,
        "trace_id": 6810857924527719555
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-11 05:20:25
success: True
trace_id: 6810857924527719555

Scan 161788639

duration: 0:00:14.887031

exit_message:

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

id: 161788639

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_imscategories/2026-04-10/1775815220",
        "key": "raw/stellar_imscategories/2026-04-10/1775815220/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16734981316352000989,
        "service_name": "drive-thru",
        "span_id": 2782322959814672325,
        "trace_id": 2930938132380590548
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-10 05:04:01
success: True
trace_id: 2930938132380590548

Scan 161732977

duration: 0:00:12.198400

exit_message:

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

id: 161732977

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_imscategories/2026-04-09/1775728836",
        "key": "raw/stellar_imscategories/2026-04-09/1775728836/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7218394654040837044,
        "service_name": "drive-thru",
        "span_id": 9789565185287138254,
        "trace_id": 1470755469100411366
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-09 05:03:00
success: True
trace_id: 1470755469100411366

Scan 161678426

duration: 0:00:12.423679

exit_message:

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

id: 161678426

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_imscategories/2026-04-08/1775642999",
        "key": "raw/stellar_imscategories/2026-04-08/1775642999/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15092561727149715944,
        "service_name": "drive-thru",
        "span_id": 466020332764233984,
        "trace_id": 578204483798502411
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-08 05:15:22
success: True
trace_id: 578204483798502411

Scan 161622107

duration: 0:00:12.171590

exit_message:

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

id: 161622107

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_imscategories/2026-04-07/1775556856",
        "key": "raw/stellar_imscategories/2026-04-07/1775556856/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11742541758654131832,
        "service_name": "drive-thru",
        "span_id": 9067586540329509584,
        "trace_id": 16163455648571956647
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-07 05:16:37
success: True
trace_id: 16163455648571956647

Scan 161564244

duration: 0:00:12.178783

exit_message:

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

id: 161564244

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_imscategories/2026-04-06/1775470528",
        "key": "raw/stellar_imscategories/2026-04-06/1775470528/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6177473012493571700,
        "service_name": "drive-thru",
        "span_id": 12646311763587358356,
        "trace_id": 16561973264758505327
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-06 05:16:49
success: True
trace_id: 16561973264758505327

Scan 161516608

duration: 0:00:14.665495

exit_message:

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

id: 161516608

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_imscategories/2026-04-05/1775382946",
        "key": "raw/stellar_imscategories/2026-04-05/1775382946/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8557134817588986301,
        "service_name": "drive-thru",
        "span_id": 3960884019678889607,
        "trace_id": 15061020475312755098
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-05 04:58:46
success: True
trace_id: 15061020475312755098

Scan 161462171

duration: 0:00:12.096574

exit_message:

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

id: 161462171

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_imscategories/2026-04-04/1775296468",
        "key": "raw/stellar_imscategories/2026-04-04/1775296468/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18019590572156944304,
        "service_name": "drive-thru",
        "span_id": 13809040665172784374,
        "trace_id": 14309265129478761437
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-04 04:57:43
success: True
trace_id: 14309265129478761437

Scan 161404795

duration: 0:00:15.011690

exit_message:

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

id: 161404795

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_imscategories/2026-04-03/1775211033",
        "key": "raw/stellar_imscategories/2026-04-03/1775211033/categories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12290929954848997669,
        "service_name": "drive-thru",
        "span_id": 13517361448394528766,
        "trace_id": 6865894146691854732
    }
}

running: False
schema_name_id: 1458
start_time: 2026-04-03 05:11:08
success: True
trace_id: 6865894146691854732

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "2022_03_10_07_17_39": "string",
    "2022_03_10_07_17_39_3": "string",
    "2022_03_10_07_17_48": "string",
    "2022_03_10_07_17_48_4": "string",
    "2022_03_10_07_17_58": "string",
    "2022_03_10_07_17_58_5": "string",
    "2022_03_10_07_18_49": "string",
    "Boats": "string",
    "First": "string",
    "Jetskis": "string",
    "Kayaks": "string",
    "Same_and_Multi_Day": "string",
    "Watersports": "string",
    "Yes": "string",
    "calendar_banner_text": "string",
    "category_name": "string",
    "created_at": "string",
    "default_date_toggle": "string",
    "description": "string",
    "filter_unit_type_enabled": "string",
    "filter_unit_type_name": "string",
    "filter_unit_type_position": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "frontend_type": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "min_nights_multi_day": "string",
    "tenant": "string",
    "updated_at": "string",
    "updated_at_2": "string"
}

created: 2026-04-17 04:57:01

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
}

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:46:25",
        "disabled": false,
        "format": "raw",
        "id": 1458,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imscategories"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "2022_03_10_07_17_39": "string",
            "2022_03_10_07_17_39_3": "string",
            "2022_03_10_07_17_48": "string",
            "2022_03_10_07_17_48_4": "string",
            "2022_03_10_07_17_58": "string",
            "2022_03_10_07_17_58_5": "string",
            "2022_03_10_07_18_49": "string",
            "Boats": "string",
            "First": "string",
            "Jetskis": "string",
            "Kayaks": "string",
            "Same_and_Multi_Day": "string",
            "Watersports": "string",
            "Yes": "string",
            "calendar_banner_text": "string",
            "category_name": "string",
            "created_at": "string",
            "default_date_toggle": "string",
            "description": "string",
            "filter_unit_type_enabled": "string",
            "filter_unit_type_name": "string",
            "filter_unit_type_position": "string",
            "frontend_display": "string",
            "frontend_name": "string",
            "frontend_position": "string",
            "frontend_type": "string",
            "icon": "string",
            "id": "string",
            "location_id": "string",
            "min_nights_multi_day": "string",
            "tenant": "string",
            "updated_at": "string",
            "updated_at_2": "string"
        },
        "created": "2026-04-17 04:57:01",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategories`\n(\n `tenant`  string , `id`  string , `location_id`  string , `category_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_type`  string , `frontend_position`  string , `filter_unit_type_enabled`  string , `filter_unit_type_name`  string , `filter_unit_type_position`  string , `min_nights_multi_day`  string , `calendar_banner_text`  string , `default_date_toggle`  string , `description`  string , `icon`  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_imscategories/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}