Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsstyle_policies
- created: 2023-02-07 01:48:02
- disabled: False
- format: raw
- id: 1490
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsstyle_policies" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717995
- created: 2026-04-17 04:57:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-17/1776419653
- id: 1717995
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 162169335
- updated: 2026-04-17 04:58:06
-
Version 1716745
- created: 2026-04-16 05:18:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-16/1776334554'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-16/1776334554
- id: 1716745
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 162114414
- updated: 2026-04-16 05:18:14
-
Version 1715481
- created: 2026-04-15 03:40:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-15/1776242367'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-15/1776242367
- id: 1715481
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 162056364
- updated: 2026-04-15 03:41:08
-
Version 1714348
- created: 2026-04-14 05:02:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-14/1776160762'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-14/1776160762
- id: 1714348
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 162003030
- updated: 2026-04-14 05:02:42
-
Version 1713154
- created: 2026-04-13 05:10:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-13/1776074808'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-13/1776074808
- id: 1713154
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161945364
- updated: 2026-04-13 05:10:38
-
Version 1711958
- created: 2026-04-12 05:07:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-12/1775988166'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-12/1775988166
- id: 1711958
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161896413
- updated: 2026-04-12 05:07:15
-
Version 1710721
- created: 2026-04-11 05:18:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-11/1775902580'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-11/1775902580
- id: 1710721
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161843940
- updated: 2026-04-11 05:18:24
-
Version 1709549
- created: 2026-04-10 05:02:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-10/1775815221'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-10/1775815221
- id: 1709549
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161788589
- updated: 2026-04-10 05:02:29
-
Version 1708416
- created: 2026-04-09 05:02:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-09/1775728843'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-09/1775728843
- id: 1708416
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161732975
- updated: 2026-04-09 05:03:08
-
Version 1707267
- created: 2026-04-08 05:15:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-08/1775642999'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-08/1775642999
- id: 1707267
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161678427
- updated: 2026-04-08 05:15:40
-
Version 1706044
- created: 2026-04-07 05:17:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-07/1775556862'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-07/1775556862
- id: 1706044
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161622122
- updated: 2026-04-07 05:17:29
-
Version 1704841
- created: 2026-04-06 05:19:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-06/1775470538'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-06/1775470538
- id: 1704841
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161564316
- updated: 2026-04-06 05:19:34
-
Version 1703628
- created: 2026-04-05 04:59:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-05/1775382950'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-05/1775382950
- id: 1703628
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161516649
- updated: 2026-04-05 04:59:41
-
Version 1702396
- created: 2026-04-04 04:55:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-04/1775296464'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-04/1775296464
- id: 1702396
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161462097
- updated: 2026-04-04 04:55:27
-
Version 1701265
- created: 2026-04-03 05:13:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsstyle_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-03/1775211040'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsstyle_policies/2026-04-03/1775211040
- id: 1701265
- processed: 1
- raw_data:
{ "created_at": 5, "html": 4, "id": 1, "policy_type": 3, "style_id": 2, "tenant": 0, "updated_at": 6 } - schema_attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - schema_name_id: 1490
- schema_scan_id: 161404863
- updated: 2026-04-03 05:13:57
Schema Scans: 15
Last at 2026-04-17 04:57:54
-
Scan 162169335
- duration: 0:00:11.802046
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169335
- 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_policies/2026-04-17/1776419653", "key": "raw/stellar_imsstyle_policies/2026-04-17/1776419653/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 112283798738941426, "service_name": "drive-thru", "span_id": 16789704590079714651, "trace_id": 12292438737820528171 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-17 04:57:54
- success: True
- trace_id: 12292438737820528171
-
Scan 162114414
- duration: 0:00:14.405422
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114414
- 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_policies/2026-04-16/1776334554", "key": "raw/stellar_imsstyle_policies/2026-04-16/1776334554/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15164751265652879864, "service_name": "drive-thru", "span_id": 5268013837296971451, "trace_id": 5335755537069398271 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-16 05:17:59
- success: True
- trace_id: 5335755537069398271
-
Scan 162056364
- duration: 0:00:11.811982
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056364
- 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_policies/2026-04-15/1776242367", "key": "raw/stellar_imsstyle_policies/2026-04-15/1776242367/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6544265181542924110, "service_name": "drive-thru", "span_id": 8855401229606638733, "trace_id": 12418896934679756889 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-15 03:40:57
- success: True
- trace_id: 12418896934679756889
-
Scan 162003030
- duration: 0:00:14.297225
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003030
- 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_policies/2026-04-14/1776160762", "key": "raw/stellar_imsstyle_policies/2026-04-14/1776160762/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1442791815798151610, "service_name": "drive-thru", "span_id": 13700993326035180720, "trace_id": 13576086219078595151 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-14 05:02:28
- success: True
- trace_id: 13576086219078595151
-
Scan 161945364
- duration: 0:00:14.427185
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945364
- 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_policies/2026-04-13/1776074808", "key": "raw/stellar_imsstyle_policies/2026-04-13/1776074808/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5760171315825942888, "service_name": "drive-thru", "span_id": 15910542997908410668, "trace_id": 17624892998498152592 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-13 05:10:23
- success: True
- trace_id: 17624892998498152592
-
Scan 161896413
- duration: 0:00:11.805030
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896413
- 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_policies/2026-04-12/1775988166", "key": "raw/stellar_imsstyle_policies/2026-04-12/1775988166/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8403804788739850241, "service_name": "drive-thru", "span_id": 5285357300027044245, "trace_id": 8058014603550015528 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-12 05:07:03
- success: True
- trace_id: 8058014603550015528
-
Scan 161843940
- duration: 0:00:11.689388
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843940
- 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_policies/2026-04-11/1775902580", "key": "raw/stellar_imsstyle_policies/2026-04-11/1775902580/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 760651455686465213, "service_name": "drive-thru", "span_id": 11278310499543581893, "trace_id": 10012258685441922045 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-11 05:18:12
- success: True
- trace_id: 10012258685441922045
-
Scan 161788589
- duration: 0:00:11.795319
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788589
- 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_policies/2026-04-10/1775815221", "key": "raw/stellar_imsstyle_policies/2026-04-10/1775815221/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15402502709463885619, "service_name": "drive-thru", "span_id": 17647848024979878070, "trace_id": 11812106112469693114 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-10 05:02:17
- success: True
- trace_id: 11812106112469693114
-
Scan 161732975
- duration: 0:00:11.830481
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161732975
- 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_policies/2026-04-09/1775728843", "key": "raw/stellar_imsstyle_policies/2026-04-09/1775728843/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2274490466191380391, "service_name": "drive-thru", "span_id": 11091310090589815358, "trace_id": 12753917608128735409 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-09 05:02:57
- success: True
- trace_id: 12753917608128735409
-
Scan 161678427
- duration: 0:00:11.824707
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678427
- 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_policies/2026-04-08/1775642999", "key": "raw/stellar_imsstyle_policies/2026-04-08/1775642999/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14261171175014904682, "service_name": "drive-thru", "span_id": 14022919811438607726, "trace_id": 4087378659231303768 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-08 05:15:29
- success: True
- trace_id: 4087378659231303768
-
Scan 161622122
- duration: 0:00:14.344853
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622122
- 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_policies/2026-04-07/1775556862", "key": "raw/stellar_imsstyle_policies/2026-04-07/1775556862/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17824748232698973373, "service_name": "drive-thru", "span_id": 18010395566345153620, "trace_id": 17925210446339415986 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-07 05:17:15
- success: True
- trace_id: 17925210446339415986
-
Scan 161564316
- duration: 0:00:11.779060
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564316
- 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_policies/2026-04-06/1775470538", "key": "raw/stellar_imsstyle_policies/2026-04-06/1775470538/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2528997883985264407, "service_name": "drive-thru", "span_id": 13474547083764101970, "trace_id": 12003552957864981642 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-06 05:19:22
- success: True
- trace_id: 12003552957864981642
-
Scan 161516649
- duration: 0:00:14.327465
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516649
- 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_policies/2026-04-05/1775382950", "key": "raw/stellar_imsstyle_policies/2026-04-05/1775382950/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7143502050199596230, "service_name": "drive-thru", "span_id": 10171974336960342311, "trace_id": 13446234638495791846 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-05 04:59:26
- success: True
- trace_id: 13446234638495791846
-
Scan 161462097
- duration: 0:00:11.794029
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462097
- 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_policies/2026-04-04/1775296464", "key": "raw/stellar_imsstyle_policies/2026-04-04/1775296464/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3547231692381552713, "service_name": "drive-thru", "span_id": 1388696643088028183, "trace_id": 7322687608245923026 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-04 04:55:15
- success: True
- trace_id: 7322687608245923026
-
Scan 161404863
- duration: 0:00:11.687810
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404863
- 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_policies/2026-04-03/1775211040", "key": "raw/stellar_imsstyle_policies/2026-04-03/1775211040/style_policies.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsstyle_policies", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15041507877609984346, "service_name": "drive-thru", "span_id": 10109682193091260083, "trace_id": 1432141039567943608 } } - running: False
- schema_name_id: 1490
- start_time: 2026-04-03 05:13:45
- success: True
- trace_id: 1432141039567943608
- attributes:
{ "created_at": "string", "html": "string", "id": "string", "policy_type": "string", "style_id": "string", "tenant": "string", "updated_at": "string" } - created: 2026-04-17 04:57:54
- 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_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-02-07 01:48:02",
"disabled": false,
"format": "raw",
"id": 1490,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsstyle_policies"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"created_at": "string",
"html": "string",
"id": "string",
"policy_type": "string",
"style_id": "string",
"tenant": "string",
"updated_at": "string"
},
"created": "2026-04-17 04:57:54",
"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_policies`\n(\n `tenant` string , `id` string , `style_id` string , `policy_type` string , `html` string , `created_at` string , `updated_at` 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_policies/2026-04-17/1776419653'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsstyle_policies`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsstyle_policies"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}