Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsstyle_amenities

created: 2023-02-07 01:45:16
disabled: False
format: raw
id: 1435
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717996

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

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

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 162169336
updated: 2026-04-17 04:58:08

Version 1716752

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-16/1776334553'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

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

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 162114421
updated: 2026-04-16 05:18:28

Version 1715545

created: 2026-04-15 03:43:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-15/1776242366'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-15/1776242366
id: 1715545
processed: 1

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 162056434
updated: 2026-04-15 03:43:40

Version 1714406

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-14/1776160761'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-14/1776160761
id: 1714406
processed: 1

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 162003145
updated: 2026-04-14 05:05:12

Version 1713173

created: 2026-04-13 05:11:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-13/1776074807'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

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

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161945385
updated: 2026-04-13 05:11:27

Version 1711953

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-12/1775988164'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-12/1775988164
id: 1711953
processed: 1

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161896407
updated: 2026-04-12 05:07:03

Version 1710712

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-11/1775902579'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

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

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161843932
updated: 2026-04-11 05:18:07

Version 1709598

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

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

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161788650
updated: 2026-04-10 05:04:31

Version 1708432

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-09/1775728842'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

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

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161732991
updated: 2026-04-09 05:03:48

Version 1707191

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-08/1775642994'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-08/1775642994
id: 1707191
processed: 1

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161678350
updated: 2026-04-08 05:12:13

Version 1706056

created: 2026-04-07 05:17:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-07/1775556861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-07/1775556861
id: 1706056
processed: 1

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161622134
updated: 2026-04-07 05:17:54

Version 1704779

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-06/1775470536'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-06/1775470536
id: 1704779
processed: 1

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161564250
updated: 2026-04-06 05:17:15

Version 1703553

created: 2026-04-05 04:56:47

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-05/1775382949'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-05/1775382949
id: 1703553
processed: 1

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161516530
updated: 2026-04-05 04:57:00

Version 1702430

created: 2026-04-04 04:56:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-04/1775296466'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

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

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161462131
updated: 2026-04-04 04:56:45

Version 1701297

created: 2026-04-03 05:15:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-03/1775211039'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-03/1775211039
id: 1701297
processed: 1

raw_data:

{
    "amenity_id": 2,
    "style_id": 1,
    "tenant": 0,
    "value": 3
}

schema_attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

schema_name_id: 1435
schema_scan_id: 161404896
updated: 2026-04-03 05:15:15

Schema Scans: 15

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

Scan 162169336

duration: 0:00:11.823237

exit_message:

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

id: 162169336

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-17/1776419652",
        "key": "raw/stellar_imsstyle_amenities/2026-04-17/1776419652/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15180079329461498428,
        "service_name": "drive-thru",
        "span_id": 4912343478878467511,
        "trace_id": 16699336089839910714
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-17 04:57:56
success: True
trace_id: 16699336089839910714

Scan 162114421

duration: 0:00:14.457501

exit_message:

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

id: 162114421

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-16/1776334553",
        "key": "raw/stellar_imsstyle_amenities/2026-04-16/1776334553/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1841252662373390271,
        "service_name": "drive-thru",
        "span_id": 13892832986633690799,
        "trace_id": 2960680297232606986
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-16 05:18:14
success: True
trace_id: 2960680297232606986

Scan 162056434

duration: 0:00:11.844075

exit_message:

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

id: 162056434

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-15/1776242366",
        "key": "raw/stellar_imsstyle_amenities/2026-04-15/1776242366/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9574492704982206297,
        "service_name": "drive-thru",
        "span_id": 4124231452034768978,
        "trace_id": 10736844148016623643
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-15 03:43:28
success: True
trace_id: 10736844148016623643

Scan 162003145

duration: 0:00:12.029182

exit_message:

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

id: 162003145

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-14/1776160761",
        "key": "raw/stellar_imsstyle_amenities/2026-04-14/1776160761/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1428176164079064542,
        "service_name": "drive-thru",
        "span_id": 16756069623908652091,
        "trace_id": 966435864786249821
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-14 05:05:00
success: True
trace_id: 966435864786249821

Scan 161945385

duration: 0:00:12.031984

exit_message:

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

id: 161945385

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-13/1776074807",
        "key": "raw/stellar_imsstyle_amenities/2026-04-13/1776074807/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15668397378004667832,
        "service_name": "drive-thru",
        "span_id": 1063181543985006588,
        "trace_id": 11946783918395347691
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-13 05:11:15
success: True
trace_id: 11946783918395347691

Scan 161896407

duration: 0:00:14.386103

exit_message:

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

id: 161896407

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-12/1775988164",
        "key": "raw/stellar_imsstyle_amenities/2026-04-12/1775988164/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12611585664407911872,
        "service_name": "drive-thru",
        "span_id": 7188301760953169480,
        "trace_id": 14743091056705076857
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-12 05:06:49
success: True
trace_id: 14743091056705076857

Scan 161843932

duration: 0:00:14.298021

exit_message:

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

id: 161843932

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-11/1775902579",
        "key": "raw/stellar_imsstyle_amenities/2026-04-11/1775902579/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2854264016422132570,
        "service_name": "drive-thru",
        "span_id": 11599015048730124059,
        "trace_id": 5866055075947545147
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-11 05:17:53
success: True
trace_id: 5866055075947545147

Scan 161788650

duration: 0:00:14.397398

exit_message:

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

id: 161788650

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-10/1775815220",
        "key": "raw/stellar_imsstyle_amenities/2026-04-10/1775815220/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2361413549390236187,
        "service_name": "drive-thru",
        "span_id": 4639961064915251027,
        "trace_id": 10925360499673367179
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-10 05:04:17
success: True
trace_id: 10925360499673367179

Scan 161732991

duration: 0:00:14.621833

exit_message:

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

id: 161732991

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-09/1775728842",
        "key": "raw/stellar_imsstyle_amenities/2026-04-09/1775728842/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13740742786701203763,
        "service_name": "drive-thru",
        "span_id": 3450388616414343393,
        "trace_id": 3902606274016161715
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-09 05:03:33
success: True
trace_id: 3902606274016161715

Scan 161678350

duration: 0:00:11.817202

exit_message:

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

id: 161678350

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-08/1775642994",
        "key": "raw/stellar_imsstyle_amenities/2026-04-08/1775642994/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15245625994290885951,
        "service_name": "drive-thru",
        "span_id": 7488677627298576844,
        "trace_id": 11394069603725232339
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-08 05:12:02
success: True
trace_id: 11394069603725232339

Scan 161622134

duration: 0:00:14.426834

exit_message:

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

id: 161622134

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-07/1775556861",
        "key": "raw/stellar_imsstyle_amenities/2026-04-07/1775556861/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18343978045124274534,
        "service_name": "drive-thru",
        "span_id": 4352729329186830392,
        "trace_id": 4972191469746640804
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-07 05:17:40
success: True
trace_id: 4972191469746640804

Scan 161564250

duration: 0:00:14.367439

exit_message:

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

id: 161564250

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-06/1775470536",
        "key": "raw/stellar_imsstyle_amenities/2026-04-06/1775470536/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15353972497288813920,
        "service_name": "drive-thru",
        "span_id": 2279431124114548923,
        "trace_id": 4431198152345048857
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-06 05:17:01
success: True
trace_id: 4431198152345048857

Scan 161516530

duration: 0:00:14.261076

exit_message:

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

id: 161516530

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-05/1775382949",
        "key": "raw/stellar_imsstyle_amenities/2026-04-05/1775382949/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11218768339513335530,
        "service_name": "drive-thru",
        "span_id": 12586796589945013216,
        "trace_id": 16595291972899536806
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-05 04:56:46
success: True
trace_id: 16595291972899536806

Scan 161462131

duration: 0:00:11.806207

exit_message:

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

id: 161462131

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-04/1775296466",
        "key": "raw/stellar_imsstyle_amenities/2026-04-04/1775296466/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17670525039699345391,
        "service_name": "drive-thru",
        "span_id": 15878624127164507028,
        "trace_id": 11342916041617845034
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-04 04:56:33
success: True
trace_id: 11342916041617845034

Scan 161404896

duration: 0:00:11.881437

exit_message:

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

id: 161404896

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-03/1775211039",
        "key": "raw/stellar_imsstyle_amenities/2026-04-03/1775211039/style_amenities.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_amenities",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 108330084311311383,
        "service_name": "drive-thru",
        "span_id": 756997922998219774,
        "trace_id": 9271578806831274919
    }
}

running: False
schema_name_id: 1435
start_time: 2026-04-03 05:15:03
success: True
trace_id: 9271578806831274919

Partitions:

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

Schema:

attributes:

{
    "1": "string",
    "11_Max_3": "string",
    "12_Max_1": "string",
    "2": "string",
    "20_2": "string",
    "21_1": "string",
    "22_3": "string",
    "250_3": "string",
    "3": "string",
    "350_2": "string",
    "75": "string",
    "8_Max_2": "string",
    "amenity_id": "string",
    "style_id": "string",
    "tenant": "string",
    "value": "string",
    "value_1": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
}

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:45:16",
        "disabled": false,
        "format": "raw",
        "id": 1435,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsstyle_amenities"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "1": "string",
            "11_Max_3": "string",
            "12_Max_1": "string",
            "2": "string",
            "20_2": "string",
            "21_1": "string",
            "22_3": "string",
            "250_3": "string",
            "3": "string",
            "350_2": "string",
            "75": "string",
            "8_Max_2": "string",
            "amenity_id": "string",
            "style_id": "string",
            "tenant": "string",
            "value": "string",
            "value_1": "string"
        },
        "created": "2026-04-17 04:57:56",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_amenities`\n(\n `tenant`  string , `style_id`  string , `amenity_id`  string , `value`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_amenities/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_amenities`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_amenities"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}