Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsamenities

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717997

created: 2026-04-17 04:58:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-17/1776419644'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsamenities/2026-04-17/1776419644
id: 1717997
processed: 1

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 162169338
updated: 2026-04-17 04:58:14

Version 1716710

created: 2026-04-16 05:16:42

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

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

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 162114380
updated: 2026-04-16 05:16:56

Version 1715502

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-15/1776242356'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

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

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 162056384
updated: 2026-04-15 03:41:59

Version 1714362

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-14/1776160753'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsamenities/2026-04-14/1776160753
id: 1714362
processed: 1

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 162003072
updated: 2026-04-14 05:03:25

Version 1713071

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-13/1776074796'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsamenities/2026-04-13/1776074796
id: 1713071
processed: 1

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161945277
updated: 2026-04-13 05:07:22

Version 1711968

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-12/1775988153'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsamenities/2026-04-12/1775988153
id: 1711968
processed: 1

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161896426
updated: 2026-04-12 05:07:45

Version 1710720

created: 2026-04-11 05:18:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-11/1775902574'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

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

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161843938
updated: 2026-04-11 05:18:22

Version 1709607

created: 2026-04-10 05:04:44

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-10/1775815219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsamenities/2026-04-10/1775815219
id: 1709607
processed: 1

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161788670
updated: 2026-04-10 05:04:58

Version 1708367

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-09/1775728835'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsamenities/2026-04-09/1775728835
id: 1708367
processed: 1

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161732921
updated: 2026-04-09 05:01:19

Version 1707208

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

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

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161678367
updated: 2026-04-08 05:13:08

Version 1706008

created: 2026-04-07 05:15:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-07/1775556856'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

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

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161622086
updated: 2026-04-07 05:15:58

Version 1704783

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-06/1775470527'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

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

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161564254
updated: 2026-04-06 05:17:21

Version 1703564

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-05/1775382945'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

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

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161516546
updated: 2026-04-05 04:57:24

Version 1702472

created: 2026-04-04 04:58:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsamenities/2026-04-04/1775296466
id: 1702472
processed: 1

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161462198
updated: 2026-04-04 04:58:22

Version 1701208

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-03/1775211034'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsamenities/2026-04-03/1775211034
id: 1701208
processed: 1

raw_data:

{
    "amenity_name": 3,
    "created_at": 15,
    "description": 14,
    "featured": 7,
    "filterable": 8,
    "frontend_display": 4,
    "frontend_name": 5,
    "frontend_position": 6,
    "icon": 9,
    "id": 1,
    "location_id": 2,
    "options": 11,
    "prefix": 12,
    "suffix": 13,
    "tenant": 0,
    "type": 10,
    "updated_at": 16
}

schema_attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

schema_name_id: 1483
schema_scan_id: 161404806
updated: 2026-04-03 05:11:50

Schema Scans: 15

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

Scan 162169338

duration: 0:00:14.915617

exit_message:

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

id: 162169338

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_imsamenities/2026-04-17/1776419644",
        "key": "raw/stellar_imsamenities/2026-04-17/1776419644/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11123263965775346672,
        "service_name": "drive-thru",
        "span_id": 15129964817920836957,
        "trace_id": 10962351486669763262
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-17 04:58:00
success: True
trace_id: 10962351486669763262

Scan 162114380

duration: 0:00:14.894282

exit_message:

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

id: 162114380

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_imsamenities/2026-04-16/1776334545",
        "key": "raw/stellar_imsamenities/2026-04-16/1776334545/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8677328918472199032,
        "service_name": "drive-thru",
        "span_id": 5851263893903156643,
        "trace_id": 7792384165005897081
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-16 05:16:41
success: True
trace_id: 7792384165005897081

Scan 162056384

duration: 0:00:14.788107

exit_message:

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

id: 162056384

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_imsamenities/2026-04-15/1776242356",
        "key": "raw/stellar_imsamenities/2026-04-15/1776242356/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1256667039802464014,
        "service_name": "drive-thru",
        "span_id": 16180171039278958977,
        "trace_id": 2784720231253724380
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-15 03:41:44
success: True
trace_id: 2784720231253724380

Scan 162003072

duration: 0:00:14.752004

exit_message:

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

id: 162003072

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_imsamenities/2026-04-14/1776160753",
        "key": "raw/stellar_imsamenities/2026-04-14/1776160753/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17608076031645729059,
        "service_name": "drive-thru",
        "span_id": 13674854316413208932,
        "trace_id": 12333731563976877054
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-14 05:03:11
success: True
trace_id: 12333731563976877054

Scan 161945277

duration: 0:00:14.733870

exit_message:

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

id: 161945277

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_imsamenities/2026-04-13/1776074796",
        "key": "raw/stellar_imsamenities/2026-04-13/1776074796/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7571516614207790642,
        "service_name": "drive-thru",
        "span_id": 13050904973316548031,
        "trace_id": 8532202389142069560
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-13 05:07:08
success: True
trace_id: 8532202389142069560

Scan 161896426

duration: 0:00:14.833835

exit_message:

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

id: 161896426

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_imsamenities/2026-04-12/1775988153",
        "key": "raw/stellar_imsamenities/2026-04-12/1775988153/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12555995050500225547,
        "service_name": "drive-thru",
        "span_id": 6970007178452023050,
        "trace_id": 5601211418834642770
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-12 05:07:30
success: True
trace_id: 5601211418834642770

Scan 161843938

duration: 0:00:14.638561

exit_message:

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

id: 161843938

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_imsamenities/2026-04-11/1775902574",
        "key": "raw/stellar_imsamenities/2026-04-11/1775902574/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4034114486411176847,
        "service_name": "drive-thru",
        "span_id": 6227409195991201515,
        "trace_id": 3272045420456523086
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-11 05:18:07
success: True
trace_id: 3272045420456523086

Scan 161788670

duration: 0:00:14.824412

exit_message:

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

id: 161788670

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_imsamenities/2026-04-10/1775815219",
        "key": "raw/stellar_imsamenities/2026-04-10/1775815219/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4575068050136667404,
        "service_name": "drive-thru",
        "span_id": 2947319648392000069,
        "trace_id": 470328233140936813
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-10 05:04:43
success: True
trace_id: 470328233140936813

Scan 161732921

duration: 0:00:14.787441

exit_message:

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

id: 161732921

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_imsamenities/2026-04-09/1775728835",
        "key": "raw/stellar_imsamenities/2026-04-09/1775728835/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3999585586521294418,
        "service_name": "drive-thru",
        "span_id": 9204983467534681754,
        "trace_id": 13415998446513599173
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-09 05:01:04
success: True
trace_id: 13415998446513599173

Scan 161678367

duration: 0:00:12.422551

exit_message:

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

id: 161678367

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_imsamenities/2026-04-08/1775642999",
        "key": "raw/stellar_imsamenities/2026-04-08/1775642999/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 344343645732074610,
        "service_name": "drive-thru",
        "span_id": 13884858092831150087,
        "trace_id": 14501251308985835639
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-08 05:12:56
success: True
trace_id: 14501251308985835639

Scan 161622086

duration: 0:00:12.247868

exit_message:

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

id: 161622086

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_imsamenities/2026-04-07/1775556856",
        "key": "raw/stellar_imsamenities/2026-04-07/1775556856/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9210555742443735389,
        "service_name": "drive-thru",
        "span_id": 6917414904025853439,
        "trace_id": 2492360820827298527
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-07 05:15:46
success: True
trace_id: 2492360820827298527

Scan 161564254

duration: 0:00:12.155752

exit_message:

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

id: 161564254

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_imsamenities/2026-04-06/1775470527",
        "key": "raw/stellar_imsamenities/2026-04-06/1775470527/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5055243010050716417,
        "service_name": "drive-thru",
        "span_id": 10870747065453628043,
        "trace_id": 12100902464686803430
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-06 05:17:09
success: True
trace_id: 12100902464686803430

Scan 161516546

duration: 0:00:12.145868

exit_message:

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

id: 161516546

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_imsamenities/2026-04-05/1775382945",
        "key": "raw/stellar_imsamenities/2026-04-05/1775382945/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13036482843636033779,
        "service_name": "drive-thru",
        "span_id": 6454049910924006278,
        "trace_id": 16288591190972938246
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-05 04:57:12
success: True
trace_id: 16288591190972938246

Scan 161462198

duration: 0:00:14.671114

exit_message:

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

id: 161462198

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_imsamenities/2026-04-04/1775296466",
        "key": "raw/stellar_imsamenities/2026-04-04/1775296466/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4440017553205735944,
        "service_name": "drive-thru",
        "span_id": 16854979012358983532,
        "trace_id": 4491037727896995487
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-04 04:58:08
success: True
trace_id: 4491037727896995487

Scan 161404806

duration: 0:00:14.967656

exit_message:

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

id: 161404806

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_imsamenities/2026-04-03/1775211034",
        "key": "raw/stellar_imsamenities/2026-04-03/1775211034/amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsamenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11278656640740250466,
        "service_name": "drive-thru",
        "span_id": 490739095810482534,
        "trace_id": 1327342305960602039
    }
}

running: False
schema_name_id: 1483
start_time: 2026-04-03 05:11:35
success: True
trace_id: 1327342305960602039

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "2022_03_10_07_51_17": "string",
    "2022_03_10_07_51_17_2": "string",
    "2022_03_10_07_51_36": "string",
    "2022_03_10_07_52_16": "string",
    "2022_03_10_07_52_25": "string",
    "2022_03_10_07_52_30_3": "string",
    "HP": "string",
    "Horsepower": "string",
    "Length": "string",
    "Passengers": "string",
    "Text": "string",
    "Yes": "string",
    "_": "string",
    "amenity_name": "string",
    "created_at": "string",
    "description": "string",
    "fa_fa_arrows_h": "string",
    "fa_fa_tachometer": "string",
    "fa_fa_users": "string",
    "featured": "string",
    "filterable": "string",
    "frontend_display": "string",
    "frontend_name": "string",
    "frontend_position": "string",
    "icon": "string",
    "id": "string",
    "location_id": "string",
    "options": "string",
    "prefix": "string",
    "suffix": "string",
    "tenant": "string",
    "type": "string",
    "updated_at": "string",
    "updated_at_1": "string"
}

created: 2026-04-17 04:58: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_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-17/1776419644'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:47:38",
        "disabled": false,
        "format": "raw",
        "id": 1483,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsamenities"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "2022_03_10_07_51_17": "string",
            "2022_03_10_07_51_17_2": "string",
            "2022_03_10_07_51_36": "string",
            "2022_03_10_07_52_16": "string",
            "2022_03_10_07_52_25": "string",
            "2022_03_10_07_52_30_3": "string",
            "HP": "string",
            "Horsepower": "string",
            "Length": "string",
            "Passengers": "string",
            "Text": "string",
            "Yes": "string",
            "_": "string",
            "amenity_name": "string",
            "created_at": "string",
            "description": "string",
            "fa_fa_arrows_h": "string",
            "fa_fa_tachometer": "string",
            "fa_fa_users": "string",
            "featured": "string",
            "filterable": "string",
            "frontend_display": "string",
            "frontend_name": "string",
            "frontend_position": "string",
            "icon": "string",
            "id": "string",
            "location_id": "string",
            "options": "string",
            "prefix": "string",
            "suffix": "string",
            "tenant": "string",
            "type": "string",
            "updated_at": "string",
            "updated_at_1": "string"
        },
        "created": "2026-04-17 04:58: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_imsamenities`\n(\n `tenant`  string , `id`  string , `location_id`  string , `amenity_name`  string , `frontend_display`  string , `frontend_name`  string , `frontend_position`  string , `featured`  string , `filterable`  string , `icon`  string , `type`  string , `options`  string , `prefix`  string , `suffix`  string , `description`  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_imsamenities/2026-04-17/1776419644'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsamenities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsamenities"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}