Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsuser_style_groups

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717989

created: 2026-04-17 04:57:41

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-17/1776419655
id: 1717989
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 162169328
updated: 2026-04-17 04:57:52

Version 1716807

created: 2026-04-16 05:20:47

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-16/1776334556
id: 1716807
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 162114489
updated: 2026-04-16 05:20:58

Version 1715522

created: 2026-04-15 03:42:35

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-15/1776242369
id: 1715522
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 162056409
updated: 2026-04-15 03:42:46

Version 1714344

created: 2026-04-14 05:02:15

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-14/1776160765
id: 1714344
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 162003023
updated: 2026-04-14 05:02:26

Version 1713165

created: 2026-04-13 05:10:46

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-13/1776074810
id: 1713165
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161945374
updated: 2026-04-13 05:11:00

Version 1711990

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-12/1775988168
id: 1711990
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161896453
updated: 2026-04-12 05:09:24

Version 1710752

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-11/1775902582
id: 1710752
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161843972
updated: 2026-04-11 05:19:38

Version 1709595

created: 2026-04-10 05:04:09

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-10/1775815224
id: 1709595
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161788645
updated: 2026-04-10 05:04:23

Version 1708462

created: 2026-04-09 05:04:45

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-09/1775728845
id: 1708462
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161733027
updated: 2026-04-09 05:04:56

Version 1707193

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

ddl:

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

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

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161678352
updated: 2026-04-08 05:12:25

Version 1706059

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-07/1775556864
id: 1706059
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161622140
updated: 2026-04-07 05:18:04

Version 1704849

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-06/1775470541
id: 1704849
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161564327
updated: 2026-04-06 05:19:55

Version 1703645

created: 2026-04-05 04:59:57

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-05/1775382952
id: 1703645
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161516710
updated: 2026-04-05 05:00:10

Version 1702483

created: 2026-04-04 04:58:32

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-04/1775296475
id: 1702483
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161462232
updated: 2026-04-04 04:58:46

Version 1701277

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_style_groups/2026-04-03/1775211042
id: 1701277
processed: 1

raw_data:

{
    "style_group_id": 2,
    "tenant": 0,
    "user_id": 1
}

schema_attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

schema_name_id: 1478
schema_scan_id: 161404877
updated: 2026-04-03 05:14:25

Schema Scans: 15

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

Scan 162169328

duration: 0:00:11.531115

exit_message:

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

id: 162169328

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_imsuser_style_groups/2026-04-17/1776419655",
        "key": "raw/stellar_imsuser_style_groups/2026-04-17/1776419655/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3691534653819272724,
        "service_name": "drive-thru",
        "span_id": 5122848764136795953,
        "trace_id": 5817597579867356569
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-17 04:57:40
success: True
trace_id: 5817597579867356569

Scan 162114489

duration: 0:00:11.626931

exit_message:

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

id: 162114489

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_imsuser_style_groups/2026-04-16/1776334556",
        "key": "raw/stellar_imsuser_style_groups/2026-04-16/1776334556/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4020152741721308400,
        "service_name": "drive-thru",
        "span_id": 16395068010658762348,
        "trace_id": 14763958320244701285
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-16 05:20:47
success: True
trace_id: 14763958320244701285

Scan 162056409

duration: 0:00:11.520953

exit_message:

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

id: 162056409

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_imsuser_style_groups/2026-04-15/1776242369",
        "key": "raw/stellar_imsuser_style_groups/2026-04-15/1776242369/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8330225071221365644,
        "service_name": "drive-thru",
        "span_id": 14565179077331814814,
        "trace_id": 13381338813239866330
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-15 03:42:34
success: True
trace_id: 13381338813239866330

Scan 162003023

duration: 0:00:11.646177

exit_message:

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

id: 162003023

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_imsuser_style_groups/2026-04-14/1776160765",
        "key": "raw/stellar_imsuser_style_groups/2026-04-14/1776160765/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15026835742375204008,
        "service_name": "drive-thru",
        "span_id": 16223707916750401924,
        "trace_id": 14785593465788085348
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-14 05:02:15
success: True
trace_id: 14785593465788085348

Scan 161945374

duration: 0:00:14.168391

exit_message:

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

id: 161945374

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_imsuser_style_groups/2026-04-13/1776074810",
        "key": "raw/stellar_imsuser_style_groups/2026-04-13/1776074810/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13010044751761381319,
        "service_name": "drive-thru",
        "span_id": 12842987847898465442,
        "trace_id": 14366333707258442352
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-13 05:10:46
success: True
trace_id: 14366333707258442352

Scan 161896453

duration: 0:00:11.590770

exit_message:

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

id: 161896453

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_imsuser_style_groups/2026-04-12/1775988168",
        "key": "raw/stellar_imsuser_style_groups/2026-04-12/1775988168/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6999715668749317450,
        "service_name": "drive-thru",
        "span_id": 5507311413712244865,
        "trace_id": 15405985195200020042
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-12 05:09:12
success: True
trace_id: 15405985195200020042

Scan 161843972

duration: 0:00:11.817030

exit_message:

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

id: 161843972

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_imsuser_style_groups/2026-04-11/1775902582",
        "key": "raw/stellar_imsuser_style_groups/2026-04-11/1775902582/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11844847429443748708,
        "service_name": "drive-thru",
        "span_id": 12595850585639652203,
        "trace_id": 37421628054476863
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-11 05:19:26
success: True
trace_id: 37421628054476863

Scan 161788645

duration: 0:00:14.225342

exit_message:

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

id: 161788645

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_imsuser_style_groups/2026-04-10/1775815224",
        "key": "raw/stellar_imsuser_style_groups/2026-04-10/1775815224/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10379538885730423196,
        "service_name": "drive-thru",
        "span_id": 14904787395467717087,
        "trace_id": 3832392599256708736
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-10 05:04:09
success: True
trace_id: 3832392599256708736

Scan 161733027

duration: 0:00:11.517938

exit_message:

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

id: 161733027

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_imsuser_style_groups/2026-04-09/1775728845",
        "key": "raw/stellar_imsuser_style_groups/2026-04-09/1775728845/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15017869724825672536,
        "service_name": "drive-thru",
        "span_id": 17245076738809049734,
        "trace_id": 12666581978751642785
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-09 05:04:44
success: True
trace_id: 12666581978751642785

Scan 161678352

duration: 0:00:14.061001

exit_message:

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

id: 161678352

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_imsuser_style_groups/2026-04-08/1775642999",
        "key": "raw/stellar_imsuser_style_groups/2026-04-08/1775642999/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3071133541231725702,
        "service_name": "drive-thru",
        "span_id": 9532912942467323764,
        "trace_id": 6968850311980842149
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-08 05:12:11
success: True
trace_id: 6968850311980842149

Scan 161622140

duration: 0:00:14.209219

exit_message:

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

id: 161622140

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_imsuser_style_groups/2026-04-07/1775556864",
        "key": "raw/stellar_imsuser_style_groups/2026-04-07/1775556864/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 16426220017824491744,
        "service_name": "drive-thru",
        "span_id": 7079581797134987026,
        "trace_id": 9442389977366596712
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-07 05:17:50
success: True
trace_id: 9442389977366596712

Scan 161564327

duration: 0:00:11.519899

exit_message:

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

id: 161564327

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_imsuser_style_groups/2026-04-06/1775470541",
        "key": "raw/stellar_imsuser_style_groups/2026-04-06/1775470541/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15360860462128783142,
        "service_name": "drive-thru",
        "span_id": 9973163627344395625,
        "trace_id": 6818013210607856536
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-06 05:19:44
success: True
trace_id: 6818013210607856536

Scan 161516710

duration: 0:00:13.976121

exit_message:

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

id: 161516710

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_imsuser_style_groups/2026-04-05/1775382952",
        "key": "raw/stellar_imsuser_style_groups/2026-04-05/1775382952/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15466298370906932449,
        "service_name": "drive-thru",
        "span_id": 8295232134194780847,
        "trace_id": 15871559520690959602
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-05 04:59:56
success: True
trace_id: 15871559520690959602

Scan 161462232

duration: 0:00:14.100120

exit_message:

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

id: 161462232

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_imsuser_style_groups/2026-04-04/1775296475",
        "key": "raw/stellar_imsuser_style_groups/2026-04-04/1775296475/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11501140631698943217,
        "service_name": "drive-thru",
        "span_id": 16371460517958508251,
        "trace_id": 2805919792339609303
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-04 04:58:32
success: True
trace_id: 2805919792339609303

Scan 161404877

duration: 0:00:11.489356

exit_message:

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

id: 161404877

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_imsuser_style_groups/2026-04-03/1775211042",
        "key": "raw/stellar_imsuser_style_groups/2026-04-03/1775211042/user_style_groups.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_style_groups",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5883494680270204793,
        "service_name": "drive-thru",
        "span_id": 10575552275083198416,
        "trace_id": 9919672589851269154
    }
}

running: False
schema_name_id: 1478
start_time: 2026-04-03 05:14:13
success: True
trace_id: 9919672589851269154

Partitions:

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

Schema:

attributes:

{
    "style_group_id": "string",
    "tenant": "string",
    "user_id": "string"
}

created: 2026-04-17 04:57:41

ddl:

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

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:47:25",
        "disabled": false,
        "format": "raw",
        "id": 1478,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsuser_style_groups"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "style_group_id": "string",
            "tenant": "string",
            "user_id": "string"
        },
        "created": "2026-04-17 04:57:41",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_style_groups`\n(\n `tenant`  string , `user_id`  string , `style_group_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_imsuser_style_groups/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_style_groups`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_style_groups"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}