Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imscategory_styles

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717934

created: 2026-04-17 04:55:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategory_styles/2026-04-17/1776419649
id: 1717934
processed: 1

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 162169270
updated: 2026-04-17 04:55:43

Version 1716691

created: 2026-04-16 05:16:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-16/1776334545'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

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

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 162114360
updated: 2026-04-16 05:16:12

Version 1715488

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-15/1776242357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

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

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 162056372
updated: 2026-04-15 03:41:29

Version 1714313

created: 2026-04-14 05:00:53

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-14/1776160755'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategory_styles/2026-04-14/1776160755
id: 1714313
processed: 1

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 162002954
updated: 2026-04-14 05:01:07

Version 1713102

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-13/1776074798'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

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

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161945308
updated: 2026-04-13 05:08:37

Version 1711934

created: 2026-04-12 05:05:51

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-12/1775988157'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategory_styles/2026-04-12/1775988157
id: 1711934
processed: 1

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161896383
updated: 2026-04-12 05:06:04

Version 1710739

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategory_styles/2026-04-11/1775902576
id: 1710739
processed: 1

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161843958
updated: 2026-04-11 05:19:09

Version 1709514

created: 2026-04-10 05:00:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-10/1775815218'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategory_styles/2026-04-10/1775815218
id: 1709514
processed: 1

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161788552
updated: 2026-04-10 05:01:09

Version 1708402

created: 2026-04-09 05:02:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-09/1775728837'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategory_styles/2026-04-09/1775728837
id: 1708402
processed: 1

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161732961
updated: 2026-04-09 05:02:41

Version 1707271

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

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

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161678431
updated: 2026-04-08 05:15:46

Version 1705989

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-07/1775556859'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imscategory_styles/2026-04-07/1775556859
id: 1705989
processed: 1

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161622067
updated: 2026-04-07 05:15:18

Version 1704767

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-06/1775470527'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

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

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161564238
updated: 2026-04-06 05:16:49

Version 1703549

created: 2026-04-05 04:56:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

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

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161516521
updated: 2026-04-05 04:56:48

Version 1702435

created: 2026-04-04 04:56:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-04/1775296468'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

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

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161462136
updated: 2026-04-04 04:56:56

Version 1701258

created: 2026-04-03 05:13:31

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-03/1775211033'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
]

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

raw_data:

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

schema_attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

schema_name_id: 1457
schema_scan_id: 161404856
updated: 2026-04-03 05:13:42

Schema Scans: 15

Last at 2026-04-17 04:55:31

Scan 162169270

duration: 0:00:11.754305

exit_message:

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

id: 162169270

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_imscategory_styles/2026-04-17/1776419649",
        "key": "raw/stellar_imscategory_styles/2026-04-17/1776419649/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7009167992879610311,
        "service_name": "drive-thru",
        "span_id": 10534453789852632966,
        "trace_id": 1767623605239159971
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-17 04:55:31
success: True
trace_id: 1767623605239159971

Scan 162114360

duration: 0:00:11.766292

exit_message:

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

id: 162114360

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_imscategory_styles/2026-04-16/1776334545",
        "key": "raw/stellar_imscategory_styles/2026-04-16/1776334545/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6125734891118211137,
        "service_name": "drive-thru",
        "span_id": 5742827454011071713,
        "trace_id": 16528089611805016958
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-16 05:16:00
success: True
trace_id: 16528089611805016958

Scan 162056372

duration: 0:00:14.239102

exit_message:

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

id: 162056372

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_imscategory_styles/2026-04-15/1776242357",
        "key": "raw/stellar_imscategory_styles/2026-04-15/1776242357/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10570677199631757557,
        "service_name": "drive-thru",
        "span_id": 5321776114400452653,
        "trace_id": 9939087145880304568
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-15 03:41:14
success: True
trace_id: 9939087145880304568

Scan 162002954

duration: 0:00:14.293694

exit_message:

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

id: 162002954

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_imscategory_styles/2026-04-14/1776160755",
        "key": "raw/stellar_imscategory_styles/2026-04-14/1776160755/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5377324231749128095,
        "service_name": "drive-thru",
        "span_id": 876216688517377855,
        "trace_id": 5984263143475375910
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-14 05:00:53
success: True
trace_id: 5984263143475375910

Scan 161945308

duration: 0:00:11.824525

exit_message:

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

id: 161945308

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_imscategory_styles/2026-04-13/1776074798",
        "key": "raw/stellar_imscategory_styles/2026-04-13/1776074798/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 2306537089596052306,
        "service_name": "drive-thru",
        "span_id": 13720417102516554460,
        "trace_id": 10350257393929233145
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-13 05:08:26
success: True
trace_id: 10350257393929233145

Scan 161896383

duration: 0:00:14.270012

exit_message:

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

id: 161896383

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_imscategory_styles/2026-04-12/1775988157",
        "key": "raw/stellar_imscategory_styles/2026-04-12/1775988157/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4334811826636848080,
        "service_name": "drive-thru",
        "span_id": 1515117322131877108,
        "trace_id": 12949348493444258913
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-12 05:05:50
success: True
trace_id: 12949348493444258913

Scan 161843958

duration: 0:00:14.327002

exit_message:

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

id: 161843958

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_imscategory_styles/2026-04-11/1775902576",
        "key": "raw/stellar_imscategory_styles/2026-04-11/1775902576/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10271887102897037885,
        "service_name": "drive-thru",
        "span_id": 3090386512399052101,
        "trace_id": 8529904336935704463
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-11 05:18:55
success: True
trace_id: 8529904336935704463

Scan 161788552

duration: 0:00:11.829216

exit_message:

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

id: 161788552

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_imscategory_styles/2026-04-10/1775815218",
        "key": "raw/stellar_imscategory_styles/2026-04-10/1775815218/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4856850439691890773,
        "service_name": "drive-thru",
        "span_id": 14250602503539887405,
        "trace_id": 1613735936482203769
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-10 05:00:58
success: True
trace_id: 1613735936482203769

Scan 161732961

duration: 0:00:14.334397

exit_message:

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

id: 161732961

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_imscategory_styles/2026-04-09/1775728837",
        "key": "raw/stellar_imscategory_styles/2026-04-09/1775728837/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1925222942596852772,
        "service_name": "drive-thru",
        "span_id": 17372716493690670360,
        "trace_id": 16293633716730275580
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-09 05:02:27
success: True
trace_id: 16293633716730275580

Scan 161678431

duration: 0:00:11.682107

exit_message:

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

id: 161678431

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_imscategory_styles/2026-04-08/1775642999",
        "key": "raw/stellar_imscategory_styles/2026-04-08/1775642999/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9945203115270756909,
        "service_name": "drive-thru",
        "span_id": 10216540515840143093,
        "trace_id": 18025004649703934555
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-08 05:15:34
success: True
trace_id: 18025004649703934555

Scan 161622067

duration: 0:00:11.867906

exit_message:

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

id: 161622067

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_imscategory_styles/2026-04-07/1775556859",
        "key": "raw/stellar_imscategory_styles/2026-04-07/1775556859/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3512211476289856757,
        "service_name": "drive-thru",
        "span_id": 4478028122833585999,
        "trace_id": 1629518450457040951
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-07 05:15:06
success: True
trace_id: 1629518450457040951

Scan 161564238

duration: 0:00:14.253582

exit_message:

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

id: 161564238

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_imscategory_styles/2026-04-06/1775470527",
        "key": "raw/stellar_imscategory_styles/2026-04-06/1775470527/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6594757632972868834,
        "service_name": "drive-thru",
        "span_id": 12618314470664890384,
        "trace_id": 12070542338369893188
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-06 05:16:34
success: True
trace_id: 12070542338369893188

Scan 161516521

duration: 0:00:11.879295

exit_message:

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

id: 161516521

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_imscategory_styles/2026-04-05/1775382946",
        "key": "raw/stellar_imscategory_styles/2026-04-05/1775382946/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13306675442934497042,
        "service_name": "drive-thru",
        "span_id": 7279161636133367195,
        "trace_id": 14385318588733002773
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-05 04:56:36
success: True
trace_id: 14385318588733002773

Scan 161462136

duration: 0:00:11.746034

exit_message:

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

id: 161462136

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_imscategory_styles/2026-04-04/1775296468",
        "key": "raw/stellar_imscategory_styles/2026-04-04/1775296468/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3314357050937925098,
        "service_name": "drive-thru",
        "span_id": 2217552297613438750,
        "trace_id": 3241540156798656694
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-04 04:56:45
success: True
trace_id: 3241540156798656694

Scan 161404856

duration: 0:00:11.693316

exit_message:

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

id: 161404856

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_imscategory_styles/2026-04-03/1775211033",
        "key": "raw/stellar_imscategory_styles/2026-04-03/1775211033/category_styles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imscategory_styles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15595355774358549153,
        "service_name": "drive-thru",
        "span_id": 2483709177846803510,
        "trace_id": 10152530252386303818
    }
}

running: False
schema_name_id: 1457
start_time: 2026-04-03 05:13:30
success: True
trace_id: 10152530252386303818

Partitions:

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

Schema:

attributes:

{
    "10": "string",
    "1_2": "string",
    "2_2": "string",
    "3_3": "string",
    "4_4": "string",
    "5_5": "string",
    "6_5": "string",
    "7_5": "string",
    "8_5": "string",
    "9_5": "string",
    "category_id": "string",
    "style_id": "string",
    "style_id_2": "string",
    "tenant": "string"
}

created: 2026-04-17 04:55:32

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:46:24",
        "disabled": false,
        "format": "raw",
        "id": 1457,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imscategory_styles"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "10": "string",
            "1_2": "string",
            "2_2": "string",
            "3_3": "string",
            "4_4": "string",
            "5_5": "string",
            "6_5": "string",
            "7_5": "string",
            "8_5": "string",
            "9_5": "string",
            "category_id": "string",
            "style_id": "string",
            "style_id_2": "string",
            "tenant": "string"
        },
        "created": "2026-04-17 04:55:32",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imscategory_styles`\n(\n `tenant`  string , `category_id`  string , `style_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_imscategory_styles/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imscategory_styles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imscategory_styles"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}