Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsstyle_required_accessories

created: 2023-05-09 02:45:04
disabled: False
format: raw
id: 1534
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718026

created: 2026-04-17 04:59:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-17/1776419654
id: 1718026
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 162169400
updated: 2026-04-17 04:59:25

Version 1716753

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-16/1776334554'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-16/1776334554
id: 1716753
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 162114423
updated: 2026-04-16 05:18:33

Version 1715547

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-15/1776242368'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-15/1776242368
id: 1715547
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 162056436
updated: 2026-04-15 03:43:47

Version 1714397

created: 2026-04-14 05:04:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-14/1776160762'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 162003131
updated: 2026-04-14 05:04:53

Version 1713119

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-13/1776074808'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-13/1776074808
id: 1713119
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161945325
updated: 2026-04-13 05:09:09

Version 1711991

created: 2026-04-12 05:09:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-12/1775988165'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161896458
updated: 2026-04-12 05:09:33

Version 1710783

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-11/1775902581'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-11/1775902581
id: 1710783
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161844007
updated: 2026-04-11 05:20:49

Version 1709588

created: 2026-04-10 05:03:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-10/1775815222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-10/1775815222
id: 1709588
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161788635
updated: 2026-04-10 05:04:07

Version 1708423

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-09/1775728843'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-09/1775728843
id: 1708423
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161732982
updated: 2026-04-09 05:03:23

Version 1707189

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-08/1775642992'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-08/1775642992
id: 1707189
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161678348
updated: 2026-04-08 05:12:09

Version 1706074

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-07/1775556862'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161622164
updated: 2026-04-07 05:18:45

Version 1704835

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-06/1775470538'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-06/1775470538
id: 1704835
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161564311
updated: 2026-04-06 05:19:22

Version 1703614

created: 2026-04-05 04:59:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-05/1775382951'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-05/1775382951
id: 1703614
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161516631
updated: 2026-04-05 04:59:22

Version 1702398

created: 2026-04-04 04:55:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-04/1775296467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_required_accessories/2026-04-04/1775296467
id: 1702398
processed: 1

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161462099
updated: 2026-04-04 04:55:35

Version 1701304

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_required_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_required_accessories/2026-04-03/1775211040'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
]

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

raw_data:

{
    "accessory_id": 2,
    "style_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

schema_name_id: 1534
schema_scan_id: 161404904
updated: 2026-04-03 05:15:38

Schema Scans: 15

Last at 2026-04-17 04:59:11

Scan 162169400

duration: 0:00:14.152105

exit_message:

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

id: 162169400

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_required_accessories/2026-04-17/1776419654",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-17/1776419654/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3141302034967126887,
        "service_name": "drive-thru",
        "span_id": 2624319054216551,
        "trace_id": 2977131361439548911
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-17 04:59:11
success: True
trace_id: 2977131361439548911

Scan 162114423

duration: 0:00:14.071548

exit_message:

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

id: 162114423

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_required_accessories/2026-04-16/1776334554",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-16/1776334554/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 18129917757359563789,
        "service_name": "drive-thru",
        "span_id": 12011004544872815300,
        "trace_id": 17964895559161335388
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-16 05:18:19
success: True
trace_id: 17964895559161335388

Scan 162056436

duration: 0:00:11.518915

exit_message:

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

id: 162056436

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_required_accessories/2026-04-15/1776242368",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-15/1776242368/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6529019332460336645,
        "service_name": "drive-thru",
        "span_id": 12421196535847380049,
        "trace_id": 12117147355013593868
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-15 03:43:36
success: True
trace_id: 12117147355013593868

Scan 162003131

duration: 0:00:14.310058

exit_message:

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

id: 162003131

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_required_accessories/2026-04-14/1776160762",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-14/1776160762/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3934652564424501804,
        "service_name": "drive-thru",
        "span_id": 16701663524929935525,
        "trace_id": 7946423717129688273
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-14 05:04:39
success: True
trace_id: 7946423717129688273

Scan 161945325

duration: 0:00:14.036472

exit_message:

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

id: 161945325

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_required_accessories/2026-04-13/1776074808",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-13/1776074808/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 225926421298606222,
        "service_name": "drive-thru",
        "span_id": 10061420846207002123,
        "trace_id": 3611135420323116888
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-13 05:08:55
success: True
trace_id: 3611135420323116888

Scan 161896458

duration: 0:00:11.596295

exit_message:

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

id: 161896458

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_required_accessories/2026-04-12/1775988165",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-12/1775988165/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13490614344441746777,
        "service_name": "drive-thru",
        "span_id": 12001195288894054209,
        "trace_id": 6127638510496660900
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-12 05:09:21
success: True
trace_id: 6127638510496660900

Scan 161844007

duration: 0:00:11.539989

exit_message:

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

id: 161844007

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_required_accessories/2026-04-11/1775902581",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-11/1775902581/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9587173883542887604,
        "service_name": "drive-thru",
        "span_id": 13799373153312825586,
        "trace_id": 4739769296774307473
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-11 05:20:37
success: True
trace_id: 4739769296774307473

Scan 161788635

duration: 0:00:14.217139

exit_message:

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

id: 161788635

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_required_accessories/2026-04-10/1775815222",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-10/1775815222/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16833960758230326768,
        "service_name": "drive-thru",
        "span_id": 2399673393339405338,
        "trace_id": 11782797917787381959
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-10 05:03:53
success: True
trace_id: 11782797917787381959

Scan 161732982

duration: 0:00:11.497831

exit_message:

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

id: 161732982

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_required_accessories/2026-04-09/1775728843",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-09/1775728843/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1251392513612809585,
        "service_name": "drive-thru",
        "span_id": 6924883834938917479,
        "trace_id": 17597653793546864755
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-09 05:03:12
success: True
trace_id: 17597653793546864755

Scan 161678348

duration: 0:00:11.503503

exit_message:

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

id: 161678348

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_required_accessories/2026-04-08/1775642992",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-08/1775642992/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5682361934253547578,
        "service_name": "drive-thru",
        "span_id": 6282955459692643929,
        "trace_id": 15314214047489414633
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-08 05:11:57
success: True
trace_id: 15314214047489414633

Scan 161622164

duration: 0:00:11.466880

exit_message:

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

id: 161622164

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_required_accessories/2026-04-07/1775556862",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-07/1775556862/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14037224464769243514,
        "service_name": "drive-thru",
        "span_id": 3261554668421919013,
        "trace_id": 11667192987004766806
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-07 05:18:34
success: True
trace_id: 11667192987004766806

Scan 161564311

duration: 0:00:11.577888

exit_message:

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

id: 161564311

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_required_accessories/2026-04-06/1775470538",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-06/1775470538/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7463448568437287104,
        "service_name": "drive-thru",
        "span_id": 12298892244843702589,
        "trace_id": 10106244528736280713
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-06 05:19:10
success: True
trace_id: 10106244528736280713

Scan 161516631

duration: 0:00:14.017646

exit_message:

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

id: 161516631

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_required_accessories/2026-04-05/1775382951",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-05/1775382951/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 744173519609064343,
        "service_name": "drive-thru",
        "span_id": 6329795848325023794,
        "trace_id": 6834071618839778260
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-05 04:59:08
success: True
trace_id: 6834071618839778260

Scan 161462099

duration: 0:00:14.182598

exit_message:

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

id: 161462099

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_required_accessories/2026-04-04/1775296467",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-04/1775296467/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13104646869233478374,
        "service_name": "drive-thru",
        "span_id": 11535267855775809506,
        "trace_id": 7833663750302203723
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-04 04:55:20
success: True
trace_id: 7833663750302203723

Scan 161404904

duration: 0:00:14.194569

exit_message:

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

id: 161404904

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_required_accessories/2026-04-03/1775211040",
        "key": "raw/stellar_imsstyle_required_accessories/2026-04-03/1775211040/style_required_accessories.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsstyle_required_accessories",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16791609340042044051,
        "service_name": "drive-thru",
        "span_id": 17837848768974228539,
        "trace_id": 541005695113357440
    }
}

running: False
schema_name_id: 1534
start_time: 2026-04-03 05:15:24
success: True
trace_id: 541005695113357440

Partitions:

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

Schema:

attributes:

{
    "accessory_id": "string",
    "style_id": "string",
    "tenant": "string"
}

created: 2026-04-17 04:59:12

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_required_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_required_accessories/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
}

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-05-09 02:45:04",
        "disabled": false,
        "format": "raw",
        "id": 1534,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsstyle_required_accessories"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "accessory_id": "string",
            "style_id": "string",
            "tenant": "string"
        },
        "created": "2026-04-17 04:59:12",
        "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_required_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_required_accessories/2026-04-17/1776419654'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_required_accessories`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_required_accessories"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}