Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imstest_results
- created: 2023-02-07 01:46:01
- disabled: False
- format: raw
- id: 1450
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imstest_results" } - type: drivethrucsv
Schema Versions: 15
-
Version 1718005
- created: 2026-04-17 04:58:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-17/1776419655
- id: 1718005
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 162169352
- updated: 2026-04-17 04:58:31
-
Version 1716802
- created: 2026-04-16 05:20:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-16/1776334555'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-16/1776334555
- id: 1716802
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 162114481
- updated: 2026-04-16 05:20:42
-
Version 1715483
- created: 2026-04-15 03:41:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-15/1776242368'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-15/1776242368
- id: 1715483
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 162056366
- updated: 2026-04-15 03:41:14
-
Version 1714339
- created: 2026-04-14 05:02:02
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-14/1776160764'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-14/1776160764
- id: 1714339
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 162003011
- updated: 2026-04-14 05:02:16
-
Version 1713149
- created: 2026-04-13 05:10:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-13/1776074810'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-13/1776074810
- id: 1713149
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161945358
- updated: 2026-04-13 05:10:22
-
Version 1711932
- created: 2026-04-12 05:05:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-12/1775988166'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-12/1775988166
- id: 1711932
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161896381
- updated: 2026-04-12 05:06:03
-
Version 1710742
- created: 2026-04-11 05:19:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-11/1775902582'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-11/1775902582
- id: 1710742
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161843961
- updated: 2026-04-11 05:19:14
-
Version 1709565
- created: 2026-04-10 05:02:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-10/1775815224'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-10/1775815224
- id: 1709565
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161788607
- updated: 2026-04-10 05:03:13
-
Version 1708469
- created: 2026-04-09 05:05:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-09/1775728844'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-09/1775728844
- id: 1708469
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161733040
- updated: 2026-04-09 05:05:22
-
Version 1707197
- created: 2026-04-08 05:12:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-08/1775642995'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-08/1775642995
- id: 1707197
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161678357
- updated: 2026-04-08 05:12:37
-
Version 1706045
- created: 2026-04-07 05:17:17
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-07/1775556863'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-07/1775556863
- id: 1706045
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161622123
- updated: 2026-04-07 05:17:28
-
Version 1704794
- created: 2026-04-06 05:17:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-06/1775470539'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-06/1775470539
- id: 1704794
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161564266
- updated: 2026-04-06 05:17:47
-
Version 1703638
- created: 2026-04-05 04:59:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-05/1775382951'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-05/1775382951
- id: 1703638
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161516681
- updated: 2026-04-05 04:59:56
-
Version 1702493
- created: 2026-04-04 04:58:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-04/1775296475'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-04/1775296475
- id: 1702493
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161462265
- updated: 2026-04-04 04:59:02
-
Version 1701272
- created: 2026-04-03 05:14:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-03/1775211041'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imstest_results/2026-04-03/1775211041
- id: 1701272
- processed: 1
- raw_data:
{ "created_at": 5, "expires": 4, "score": 3, "style_group_id": 2, "tenant": 0, "updated_at": 6, "user_id": 1 } - schema_attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - schema_name_id: 1450
- schema_scan_id: 161404870
- updated: 2026-04-03 05:14:15
Schema Scans: 15
Last at 2026-04-17 04:58:20
-
Scan 162169352
- duration: 0:00:11.851119
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169352
- 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_imstest_results/2026-04-17/1776419655", "key": "raw/stellar_imstest_results/2026-04-17/1776419655/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8677409421943772172, "service_name": "drive-thru", "span_id": 8325812072245390818, "trace_id": 16541244566120633687 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-17 04:58:20
- success: True
- trace_id: 16541244566120633687
-
Scan 162114481
- duration: 0:00:11.913671
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114481
- 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_imstest_results/2026-04-16/1776334555", "key": "raw/stellar_imstest_results/2026-04-16/1776334555/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5418910544433122328, "service_name": "drive-thru", "span_id": 6652723057855676260, "trace_id": 2823716112231028504 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-16 05:20:30
- success: True
- trace_id: 2823716112231028504
-
Scan 162056366
- duration: 0:00:14.408561
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056366
- 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_imstest_results/2026-04-15/1776242368", "key": "raw/stellar_imstest_results/2026-04-15/1776242368/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4360074031862598250, "service_name": "drive-thru", "span_id": 15447747594945110961, "trace_id": 7286733887209011215 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-15 03:41:00
- success: True
- trace_id: 7286733887209011215
-
Scan 162003011
- duration: 0:00:14.422897
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003011
- 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_imstest_results/2026-04-14/1776160764", "key": "raw/stellar_imstest_results/2026-04-14/1776160764/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16743569294231239854, "service_name": "drive-thru", "span_id": 18019612397048143292, "trace_id": 789012097815754156 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-14 05:02:01
- success: True
- trace_id: 789012097815754156
-
Scan 161945358
- duration: 0:00:11.745981
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945358
- 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_imstest_results/2026-04-13/1776074810", "key": "raw/stellar_imstest_results/2026-04-13/1776074810/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18142080597586626818, "service_name": "drive-thru", "span_id": 17772208392738220351, "trace_id": 358956901426494610 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-13 05:10:10
- success: True
- trace_id: 358956901426494610
-
Scan 161896381
- duration: 0:00:14.234505
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896381
- 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_imstest_results/2026-04-12/1775988166", "key": "raw/stellar_imstest_results/2026-04-12/1775988166/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13085574805349929079, "service_name": "drive-thru", "span_id": 4286666766235646955, "trace_id": 5093405554253577313 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-12 05:05:49
- success: True
- trace_id: 5093405554253577313
-
Scan 161843961
- duration: 0:00:11.906641
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843961
- 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_imstest_results/2026-04-11/1775902582", "key": "raw/stellar_imstest_results/2026-04-11/1775902582/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11828212006357763996, "service_name": "drive-thru", "span_id": 16324259462060603668, "trace_id": 13350661211383496419 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-11 05:19:02
- success: True
- trace_id: 13350661211383496419
-
Scan 161788607
- duration: 0:00:14.458751
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788607
- 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_imstest_results/2026-04-10/1775815224", "key": "raw/stellar_imstest_results/2026-04-10/1775815224/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10952186483786234756, "service_name": "drive-thru", "span_id": 5967801748045812349, "trace_id": 5458461430760563975 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-10 05:02:59
- success: True
- trace_id: 5458461430760563975
-
Scan 161733040
- duration: 0:00:14.363002
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161733040
- 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_imstest_results/2026-04-09/1775728844", "key": "raw/stellar_imstest_results/2026-04-09/1775728844/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7127977490579236489, "service_name": "drive-thru", "span_id": 18269742017581573468, "trace_id": 2057686408769999237 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-09 05:05:07
- success: True
- trace_id: 2057686408769999237
-
Scan 161678357
- duration: 0:00:11.785457
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678357
- 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_imstest_results/2026-04-08/1775642995", "key": "raw/stellar_imstest_results/2026-04-08/1775642995/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 807584249195158583, "service_name": "drive-thru", "span_id": 4519350596213762317, "trace_id": 14892150339078058052 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-08 05:12:25
- success: True
- trace_id: 14892150339078058052
-
Scan 161622123
- duration: 0:00:11.878297
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622123
- 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_imstest_results/2026-04-07/1775556863", "key": "raw/stellar_imstest_results/2026-04-07/1775556863/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16992229878347484327, "service_name": "drive-thru", "span_id": 1037689942642587784, "trace_id": 9013225043983187090 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-07 05:17:16
- success: True
- trace_id: 9013225043983187090
-
Scan 161564266
- duration: 0:00:11.762929
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564266
- 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_imstest_results/2026-04-06/1775470539", "key": "raw/stellar_imstest_results/2026-04-06/1775470539/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16522091814601880608, "service_name": "drive-thru", "span_id": 13236760561660258939, "trace_id": 169432495203040886 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-06 05:17:36
- success: True
- trace_id: 169432495203040886
-
Scan 161516681
- duration: 0:00:11.800437
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516681
- 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_imstest_results/2026-04-05/1775382951", "key": "raw/stellar_imstest_results/2026-04-05/1775382951/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1095893684878758799, "service_name": "drive-thru", "span_id": 11768361946648072183, "trace_id": 14278966818233740843 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-05 04:59:45
- success: True
- trace_id: 14278966818233740843
-
Scan 161462265
- duration: 0:00:11.735764
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462265
- 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_imstest_results/2026-04-04/1775296475", "key": "raw/stellar_imstest_results/2026-04-04/1775296475/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12930290598067274268, "service_name": "drive-thru", "span_id": 2180599580584020511, "trace_id": 12984363097989136343 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-04 04:58:50
- success: True
- trace_id: 12984363097989136343
-
Scan 161404870
- duration: 0:00:14.498744
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404870
- 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_imstest_results/2026-04-03/1775211041", "key": "raw/stellar_imstest_results/2026-04-03/1775211041/test_results.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imstest_results", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16821390398559358003, "service_name": "drive-thru", "span_id": 13980007020234290690, "trace_id": 17258396606435267278 } } - running: False
- schema_name_id: 1450
- start_time: 2026-04-03 05:14:00
- success: True
- trace_id: 17258396606435267278
- attributes:
{ "created_at": "string", "expires": "string", "score": "string", "style_group_id": "string", "tenant": "string", "updated_at": "string", "user_id": "string" } - created: 2026-04-17 04:58:20
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results" }
- 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:46:01",
"disabled": false,
"format": "raw",
"id": 1450,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imstest_results"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"created_at": "string",
"expires": "string",
"score": "string",
"style_group_id": "string",
"tenant": "string",
"updated_at": "string",
"user_id": "string"
},
"created": "2026-04-17 04:58:20",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imstest_results`\n(\n `tenant` string , `user_id` string , `style_group_id` string , `score` string , `expires` 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_imstest_results/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imstest_results`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imstest_results"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}