Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsmodel_has_permissions
- created: 2024-12-21 03:21:42
- disabled: False
- format: raw
- id: 3444
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsmodel_has_permissions" } - type: drivethrucsv
Schema Versions: 15
-
Version 1717914
- created: 2026-04-17 04:54:32
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-17/1776419648
- id: 1717914
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 162169250
- updated: 2026-04-17 04:54:43
-
Version 1716724
- created: 2026-04-16 05:17:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-16/1776334549'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-16/1776334549
- id: 1716724
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 162114393
- updated: 2026-04-16 05:17:22
-
Version 1715520
- created: 2026-04-15 03:42:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-15/1776242363'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-15/1776242363
- id: 1715520
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 162056405
- updated: 2026-04-15 03:42:41
-
Version 1714367
- created: 2026-04-14 05:03:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-14/1776160758'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-14/1776160758
- id: 1714367
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 162003086
- updated: 2026-04-14 05:03:40
-
Version 1713105
- created: 2026-04-13 05:08:30
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-13/1776074803'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-13/1776074803
- id: 1713105
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161945311
- updated: 2026-04-13 05:08:41
-
Version 1711933
- created: 2026-04-12 05:05:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-12/1775988161'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-12/1775988161
- id: 1711933
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161896382
- updated: 2026-04-12 05:06:04
-
Version 1710718
- created: 2026-04-11 05:18:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-11/1775902576'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-11/1775902576
- id: 1710718
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161843937
- updated: 2026-04-11 05:18:21
-
Version 1709615
- created: 2026-04-10 05:05:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-10/1775815220
- id: 1709615
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161788696
- updated: 2026-04-10 05:05:21
-
Version 1708414
- created: 2026-04-09 05:02:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-09/1775728842'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-09/1775728842
- id: 1708414
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161732973
- updated: 2026-04-09 05:03:04
-
Version 1707172
- created: 2026-04-08 05:10:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-08/1775642988'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-08/1775642988
- id: 1707172
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161678331
- updated: 2026-04-08 05:10:59
-
Version 1706036
- created: 2026-04-07 05:16:53
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-07/1775556858'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-07/1775556858
- id: 1706036
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161622115
- updated: 2026-04-07 05:17:04
-
Version 1704816
- created: 2026-04-06 05:18:27
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-06/1775470533'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-06/1775470533
- id: 1704816
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161564291
- updated: 2026-04-06 05:18:41
-
Version 1703532
- created: 2026-04-05 04:55:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-05/1775382946
- id: 1703532
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161516490
- updated: 2026-04-05 04:56:07
-
Version 1702383
- created: 2026-04-04 04:54:51
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-04/1775296459'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-04/1775296459
- id: 1702383
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161462084
- updated: 2026-04-04 04:55:02
-
Version 1701276
- created: 2026-04-03 05:14:13
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-03/1775211037'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_permissions/2026-04-03/1775211037
- id: 1701276
- processed: 1
- raw_data:
{ "model_id": 2, "model_type": 3, "permission_id": 1, "tenant": 0 } - schema_attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - schema_name_id: 3444
- schema_scan_id: 161404876
- updated: 2026-04-03 05:14:26
Schema Scans: 15
Last at 2026-04-17 04:54:32
-
Scan 162169250
- duration: 0:00:11.568801
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169250
- 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_imsmodel_has_permissions/2026-04-17/1776419648", "key": "raw/stellar_imsmodel_has_permissions/2026-04-17/1776419648/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12936428425774108790, "service_name": "drive-thru", "span_id": 14950627281315407135, "trace_id": 8713086767359500685 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-17 04:54:32
- success: True
- trace_id: 8713086767359500685
-
Scan 162114393
- duration: 0:00:11.760632
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114393
- 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_imsmodel_has_permissions/2026-04-16/1776334549", "key": "raw/stellar_imsmodel_has_permissions/2026-04-16/1776334549/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12070271650095377078, "service_name": "drive-thru", "span_id": 15470785794415685756, "trace_id": 4889591062674699646 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-16 05:17:10
- success: True
- trace_id: 4889591062674699646
-
Scan 162056405
- duration: 0:00:11.569954
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056405
- 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_imsmodel_has_permissions/2026-04-15/1776242363", "key": "raw/stellar_imsmodel_has_permissions/2026-04-15/1776242363/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6096564274922247517, "service_name": "drive-thru", "span_id": 7745876062977024736, "trace_id": 13758300080552425799 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-15 03:42:30
- success: True
- trace_id: 13758300080552425799
-
Scan 162003086
- duration: 0:00:14.127471
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003086
- 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_imsmodel_has_permissions/2026-04-14/1776160758", "key": "raw/stellar_imsmodel_has_permissions/2026-04-14/1776160758/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12608697338627926848, "service_name": "drive-thru", "span_id": 16613177441505359095, "trace_id": 16658300634688016737 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-14 05:03:26
- success: True
- trace_id: 16658300634688016737
-
Scan 161945311
- duration: 0:00:11.623662
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945311
- 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_imsmodel_has_permissions/2026-04-13/1776074803", "key": "raw/stellar_imsmodel_has_permissions/2026-04-13/1776074803/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14756150064517592099, "service_name": "drive-thru", "span_id": 7091623271966484088, "trace_id": 11759194917725378750 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-13 05:08:29
- success: True
- trace_id: 11759194917725378750
-
Scan 161896382
- duration: 0:00:14.111038
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896382
- 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_imsmodel_has_permissions/2026-04-12/1775988161", "key": "raw/stellar_imsmodel_has_permissions/2026-04-12/1775988161/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 7633083935941802684, "service_name": "drive-thru", "span_id": 5372557793879667820, "trace_id": 4744801178210246872 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-12 05:05:50
- success: True
- trace_id: 4744801178210246872
-
Scan 161843937
- duration: 0:00:14.028843
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843937
- 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_imsmodel_has_permissions/2026-04-11/1775902576", "key": "raw/stellar_imsmodel_has_permissions/2026-04-11/1775902576/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 18380715302596086525, "service_name": "drive-thru", "span_id": 11881782844232032988, "trace_id": 16284947337958271942 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-11 05:18:07
- success: True
- trace_id: 16284947337958271942
-
Scan 161788696
- duration: 0:00:11.764822
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788696
- 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_imsmodel_has_permissions/2026-04-10/1775815220", "key": "raw/stellar_imsmodel_has_permissions/2026-04-10/1775815220/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4017434561823820945, "service_name": "drive-thru", "span_id": 5375731313408041877, "trace_id": 11517531099879490992 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-10 05:05:09
- success: True
- trace_id: 11517531099879490992
-
Scan 161732973
- duration: 0:00:11.560656
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161732973
- 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_imsmodel_has_permissions/2026-04-09/1775728842", "key": "raw/stellar_imsmodel_has_permissions/2026-04-09/1775728842/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1551542955087526198, "service_name": "drive-thru", "span_id": 1427727177859560593, "trace_id": 2306679531689358913 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-09 05:02:53
- success: True
- trace_id: 2306679531689358913
-
Scan 161678331
- duration: 0:00:14.185730
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678331
- 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_imsmodel_has_permissions/2026-04-08/1775642988", "key": "raw/stellar_imsmodel_has_permissions/2026-04-08/1775642988/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5194520208341335752, "service_name": "drive-thru", "span_id": 13747621127111658085, "trace_id": 13584275102851541814 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-08 05:10:45
- success: True
- trace_id: 13584275102851541814
-
Scan 161622115
- duration: 0:00:11.592435
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622115
- 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_imsmodel_has_permissions/2026-04-07/1775556858", "key": "raw/stellar_imsmodel_has_permissions/2026-04-07/1775556858/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2239142835488580979, "service_name": "drive-thru", "span_id": 16849207580129234684, "trace_id": 4042340421392244206 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-07 05:16:52
- success: True
- trace_id: 4042340421392244206
-
Scan 161564291
- duration: 0:00:14.074041
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564291
- 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_imsmodel_has_permissions/2026-04-06/1775470533", "key": "raw/stellar_imsmodel_has_permissions/2026-04-06/1775470533/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6960700873109262966, "service_name": "drive-thru", "span_id": 8291714167802828488, "trace_id": 17281060345957567980 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-06 05:18:27
- success: True
- trace_id: 17281060345957567980
-
Scan 161516490
- duration: 0:00:11.576892
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516490
- 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_imsmodel_has_permissions/2026-04-05/1775382946", "key": "raw/stellar_imsmodel_has_permissions/2026-04-05/1775382946/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 4193895251547787289, "service_name": "drive-thru", "span_id": 18246401441353891475, "trace_id": 4708171287976922939 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-05 04:55:55
- success: True
- trace_id: 4708171287976922939
-
Scan 161462084
- duration: 0:00:11.564719
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462084
- 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_imsmodel_has_permissions/2026-04-04/1775296459", "key": "raw/stellar_imsmodel_has_permissions/2026-04-04/1775296459/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15528339470439070354, "service_name": "drive-thru", "span_id": 429169253711551270, "trace_id": 499971924426620944 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-04 04:54:50
- success: True
- trace_id: 499971924426620944
-
Scan 161404876
- duration: 0:00:14.069832
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404876
- 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_imsmodel_has_permissions/2026-04-03/1775211037", "key": "raw/stellar_imsmodel_has_permissions/2026-04-03/1775211037/model_has_permissions.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmodel_has_permissions", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3085460831372236506, "service_name": "drive-thru", "span_id": 10906484388741245968, "trace_id": 13944940533508245032 } } - running: False
- schema_name_id: 3444
- start_time: 2026-04-03 05:14:12
- success: True
- trace_id: 13944940533508245032
- attributes:
{ "model_id": "string", "model_type": "string", "permission_id": "string", "tenant": "string" } - created: 2026-04-17 04:54:32
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2024-12-21 03:21:42",
"disabled": false,
"format": "raw",
"id": 3444,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsmodel_has_permissions"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"model_id": "string",
"model_type": "string",
"permission_id": "string",
"tenant": "string"
},
"created": "2026-04-17 04:54:32",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmodel_has_permissions`\n(\n `tenant` string , `permission_id` string , `model_id` string , `model_type` 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_imsmodel_has_permissions/2026-04-17/1776419648'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_permissions`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_permissions"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}