Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsstyle_accessories
- created: 2023-02-07 01:47:22
- disabled: False
- format: raw
- id: 1476
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsstyle_accessories" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717966
- created: 2026-04-17 04:56:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-17/1776419652
- id: 1717966
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 162169304
- updated: 2026-04-17 04:57:00
-
Version 1716739
- created: 2026-04-16 05:17:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-16/1776334552'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-16/1776334552
- id: 1716739
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 162114408
- updated: 2026-04-16 05:17:57
-
Version 1715514
- created: 2026-04-15 03:42:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-15/1776242366'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-15/1776242366
- id: 1715514
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 162056401
- updated: 2026-04-15 03:42:30
-
Version 1714366
- created: 2026-04-14 05:03:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-14/1776160761'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-14/1776160761
- id: 1714366
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 162003083
- updated: 2026-04-14 05:03:36
-
Version 1713172
- created: 2026-04-13 05:11:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-13/1776074807'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-13/1776074807
- id: 1713172
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161945381
- updated: 2026-04-13 05:11:23
-
Version 1711985
- created: 2026-04-12 05:08:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-12/1775988164'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-12/1775988164
- id: 1711985
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161896448
- updated: 2026-04-12 05:09:03
-
Version 1710734
- created: 2026-04-11 05:18:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-11/1775902579'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-11/1775902579
- id: 1710734
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161843953
- updated: 2026-04-11 05:18:56
-
Version 1709573
- created: 2026-04-10 05:03:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-10/1775815220
- id: 1709573
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161788617
- updated: 2026-04-10 05:03:30
-
Version 1708400
- created: 2026-04-09 05:02:22
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-09/1775728841'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-09/1775728841
- id: 1708400
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161732958
- updated: 2026-04-09 05:02:33
-
Version 1707233
- created: 2026-04-08 05:14:05
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-08/1775642998
- id: 1707233
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161678392
- updated: 2026-04-08 05:14:16
-
Version 1706052
- created: 2026-04-07 05:17:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-07/1775556861'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-07/1775556861
- id: 1706052
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161622131
- updated: 2026-04-07 05:17:43
-
Version 1704857
- created: 2026-04-06 05:20:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-06/1775470537'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-06/1775470537
- id: 1704857
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161564342
- updated: 2026-04-06 05:20:18
-
Version 1703584
- created: 2026-04-05 04:58:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-05/1775382949'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-05/1775382949
- id: 1703584
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161516578
- updated: 2026-04-05 04:58:18
-
Version 1702401
- created: 2026-04-04 04:55:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-04/1775296463'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-04/1775296463
- id: 1702401
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161462103
- updated: 2026-04-04 04:55:42
-
Version 1701289
- created: 2026-04-03 05:14:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-03/1775211039'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_accessories/2026-04-03/1775211039
- id: 1701289
- processed: 1
- raw_data:
{ "accessory_id": 2, "style_id": 1, "tenant": 0 } - schema_attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - schema_name_id: 1476
- schema_scan_id: 161404888
- updated: 2026-04-03 05:14:58
Schema Scans: 15
Last at 2026-04-17 04:56:48
-
Scan 162169304
- duration: 0:00:11.915028
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169304
- 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_accessories/2026-04-17/1776419652", "key": "raw/stellar_imsstyle_accessories/2026-04-17/1776419652/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16462391258898824038, "service_name": "drive-thru", "span_id": 6283916895526963661, "trace_id": 3565952063337706728 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-17 04:56:48
- success: True
- trace_id: 3565952063337706728
-
Scan 162114408
- duration: 0:00:12.021858
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114408
- 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_accessories/2026-04-16/1776334552", "key": "raw/stellar_imsstyle_accessories/2026-04-16/1776334552/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18060645124896231400, "service_name": "drive-thru", "span_id": 8170100231929496425, "trace_id": 4940706741293630175 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-16 05:17:45
- success: True
- trace_id: 4940706741293630175
-
Scan 162056401
- duration: 0:00:14.701728
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056401
- 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_accessories/2026-04-15/1776242366", "key": "raw/stellar_imsstyle_accessories/2026-04-15/1776242366/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8594744664362131923, "service_name": "drive-thru", "span_id": 11064245629337362197, "trace_id": 13475519722677433589 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-15 03:42:15
- success: True
- trace_id: 13475519722677433589
-
Scan 162003083
- duration: 0:00:12.280194
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003083
- 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_accessories/2026-04-14/1776160761", "key": "raw/stellar_imsstyle_accessories/2026-04-14/1776160761/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5605834861797673983, "service_name": "drive-thru", "span_id": 17350146721707204579, "trace_id": 10874146090148747535 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-14 05:03:24
- success: True
- trace_id: 10874146090148747535
-
Scan 161945381
- duration: 0:00:14.535621
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945381
- 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_accessories/2026-04-13/1776074807", "key": "raw/stellar_imsstyle_accessories/2026-04-13/1776074807/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13609524096997442195, "service_name": "drive-thru", "span_id": 6331945152272052738, "trace_id": 10461323519260661182 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-13 05:11:08
- success: True
- trace_id: 10461323519260661182
-
Scan 161896448
- duration: 0:00:14.451908
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896448
- 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_accessories/2026-04-12/1775988164", "key": "raw/stellar_imsstyle_accessories/2026-04-12/1775988164/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8809608052943855608, "service_name": "drive-thru", "span_id": 335308917827638768, "trace_id": 9897894259118060201 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-12 05:08:48
- success: True
- trace_id: 9897894259118060201
-
Scan 161843953
- duration: 0:00:12.023923
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843953
- 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_accessories/2026-04-11/1775902579", "key": "raw/stellar_imsstyle_accessories/2026-04-11/1775902579/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 207689744704967843, "service_name": "drive-thru", "span_id": 17062144594636814864, "trace_id": 4760296223834897096 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-11 05:18:44
- success: True
- trace_id: 4760296223834897096
-
Scan 161788617
- duration: 0:00:14.574008
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788617
- 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_accessories/2026-04-10/1775815220", "key": "raw/stellar_imsstyle_accessories/2026-04-10/1775815220/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1975696739007245177, "service_name": "drive-thru", "span_id": 11771005569914165731, "trace_id": 3190866921660862356 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-10 05:03:15
- success: True
- trace_id: 3190866921660862356
-
Scan 161732958
- duration: 0:00:11.961476
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161732958
- 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_accessories/2026-04-09/1775728841", "key": "raw/stellar_imsstyle_accessories/2026-04-09/1775728841/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9512355563017540180, "service_name": "drive-thru", "span_id": 17624305513213657414, "trace_id": 4846951651089753217 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-09 05:02:21
- success: True
- trace_id: 4846951651089753217
-
Scan 161678392
- duration: 0:00:12.079382
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678392
- 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_accessories/2026-04-08/1775642998", "key": "raw/stellar_imsstyle_accessories/2026-04-08/1775642998/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1711665753530301155, "service_name": "drive-thru", "span_id": 8734743533881529861, "trace_id": 11137609540776996318 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-08 05:14:04
- success: True
- trace_id: 11137609540776996318
-
Scan 161622131
- duration: 0:00:12.126409
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622131
- 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_accessories/2026-04-07/1775556861", "key": "raw/stellar_imsstyle_accessories/2026-04-07/1775556861/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7294739639538358128, "service_name": "drive-thru", "span_id": 10976001944307882386, "trace_id": 3066437747084429957 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-07 05:17:31
- success: True
- trace_id: 3066437747084429957
-
Scan 161564342
- duration: 0:00:12.066079
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564342
- 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_accessories/2026-04-06/1775470537", "key": "raw/stellar_imsstyle_accessories/2026-04-06/1775470537/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9425442699280439263, "service_name": "drive-thru", "span_id": 7651196347597514714, "trace_id": 14029650623986474649 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-06 05:20:06
- success: True
- trace_id: 14029650623986474649
-
Scan 161516578
- duration: 0:00:14.723837
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516578
- 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_accessories/2026-04-05/1775382949", "key": "raw/stellar_imsstyle_accessories/2026-04-05/1775382949/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12410183230764607231, "service_name": "drive-thru", "span_id": 8915276176782002591, "trace_id": 7861371138128111613 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-05 04:58:03
- success: True
- trace_id: 7861371138128111613
-
Scan 161462103
- duration: 0:00:12.118269
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462103
- 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_accessories/2026-04-04/1775296463", "key": "raw/stellar_imsstyle_accessories/2026-04-04/1775296463/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4283887140929910241, "service_name": "drive-thru", "span_id": 1457411926339788836, "trace_id": 13947222124185937836 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-04 04:55:30
- success: True
- trace_id: 13947222124185937836
-
Scan 161404888
- duration: 0:00:14.507927
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404888
- 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_accessories/2026-04-03/1775211039", "key": "raw/stellar_imsstyle_accessories/2026-04-03/1775211039/style_accessories.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_accessories", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11745578880523492067, "service_name": "drive-thru", "span_id": 10231504449309071211, "trace_id": 18364687880668545625 } } - running: False
- schema_name_id: 1476
- start_time: 2026-04-03 05:14:44
- success: True
- trace_id: 18364687880668545625
- attributes:
{ "10_1": "string", "10_2": "string", "10_3": "string", "10_4": "string", "11_1": "string", "11_2": "string", "11_3": "string", "11_4": "string", "12_1": "string", "12_2": "string", "12_3": "string", "12_4": "string", "13": "string", "13_2": "string", "13_3": "string", "13_4": "string", "1_1": "string", "1_2": "string", "1_3": "string", "2_1": "string", "2_2": "string", "2_3": "string", "3_1": "string", "3_2": "string", "3_3": "string", "4_2": "string", "4_3": "string", "4_5": "string", "5_5": "string", "6_1": "string", "accessory_id": "string", "accessory_id_1": "string", "style_id": "string", "tenant": "string" } - created: 2026-04-17 04:56:49
- 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_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-02-07 01:47:22",
"disabled": false,
"format": "raw",
"id": 1476,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsstyle_accessories"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"10_1": "string",
"10_2": "string",
"10_3": "string",
"10_4": "string",
"11_1": "string",
"11_2": "string",
"11_3": "string",
"11_4": "string",
"12_1": "string",
"12_2": "string",
"12_3": "string",
"12_4": "string",
"13": "string",
"13_2": "string",
"13_3": "string",
"13_4": "string",
"1_1": "string",
"1_2": "string",
"1_3": "string",
"2_1": "string",
"2_2": "string",
"2_3": "string",
"3_1": "string",
"3_2": "string",
"3_3": "string",
"4_2": "string",
"4_3": "string",
"4_5": "string",
"5_5": "string",
"6_1": "string",
"accessory_id": "string",
"accessory_id_1": "string",
"style_id": "string",
"tenant": "string"
},
"created": "2026-04-17 04:56:49",
"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_accessories`\n(\n `tenant` string , `style_id` string , `accessory_id` 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_accessories/2026-04-17/1776419652'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_accessories`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_accessories"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}