Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsmodel_has_roles

created: 2024-12-21 03:21:54
disabled: False
format: raw
id: 3445
is_partitioned: False
is_schema_datatyped: True

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1717958

created: 2026-04-17 04:56:33

ddl:

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

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

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 162169296
updated: 2026-04-17 04:56:47

Version 1716705

created: 2026-04-16 05:16:28

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-16/1776334549
id: 1716705
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 162114374
updated: 2026-04-16 05:16:39

Version 1715469

created: 2026-04-15 03:40:31

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-15/1776242363
id: 1715469
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 162056352
updated: 2026-04-15 03:40:42

Version 1714415

created: 2026-04-14 05:05:30

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-14/1776160758
id: 1714415
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 162003171
updated: 2026-04-14 05:05:44

Version 1713112

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-13/1776074804
id: 1713112
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161945318
updated: 2026-04-13 05:08:55

Version 1711964

created: 2026-04-12 05:07:19

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-12/1775988161
id: 1711964
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161896421
updated: 2026-04-12 05:07:30

Version 1710715

created: 2026-04-11 05:17:59

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-11/1775902577
id: 1710715
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161843935
updated: 2026-04-11 05:18:12

Version 1709566

created: 2026-04-10 05:03:01

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-10/1775815221
id: 1709566
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161788608
updated: 2026-04-10 05:03:12

Version 1708393

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-09/1775728838
id: 1708393
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161732952
updated: 2026-04-09 05:02:21

Version 1707180

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-08/1775642989
id: 1707180
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161678339
updated: 2026-04-08 05:11:37

Version 1706035

created: 2026-04-07 05:16:50

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-07/1775556858
id: 1706035
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161622113
updated: 2026-04-07 05:17:04

Version 1704804

created: 2026-04-06 05:18:01

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-06/1775470533
id: 1704804
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161564278
updated: 2026-04-06 05:18:12

Version 1703624

created: 2026-04-05 04:59:23

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-05/1775382947
id: 1703624
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161516644
updated: 2026-04-05 04:59:34

Version 1702443

created: 2026-04-04 04:57:02

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-04/1775296474
id: 1702443
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161462145
updated: 2026-04-04 04:57:13

Version 1701274

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

ddl:

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

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmodel_has_roles/2026-04-03/1775211036
id: 1701274
processed: 1

raw_data:

{
    "model_id": 2,
    "model_type": 3,
    "role_id": 1,
    "tenant": 0
}

schema_attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

schema_name_id: 3445
schema_scan_id: 161404874
updated: 2026-04-03 05:14:20

Schema Scans: 15

Last at 2026-04-17 04:56:32

Scan 162169296

duration: 0:00:14.308317

exit_message:

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

id: 162169296

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_roles/2026-04-17/1776419649",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-17/1776419649/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12492818241508477104,
        "service_name": "drive-thru",
        "span_id": 15264078970487165630,
        "trace_id": 13027178348732739127
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-17 04:56:32
success: True
trace_id: 13027178348732739127

Scan 162114374

duration: 0:00:11.680241

exit_message:

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

id: 162114374

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_roles/2026-04-16/1776334549",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-16/1776334549/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15754958465736232307,
        "service_name": "drive-thru",
        "span_id": 1536274004470735383,
        "trace_id": 14033510777326924616
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-16 05:16:27
success: True
trace_id: 14033510777326924616

Scan 162056352

duration: 0:00:11.752765

exit_message:

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

id: 162056352

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_roles/2026-04-15/1776242363",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-15/1776242363/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15499617692154936328,
        "service_name": "drive-thru",
        "span_id": 192879256752878629,
        "trace_id": 17885857465340127710
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-15 03:40:30
success: True
trace_id: 17885857465340127710

Scan 162003171

duration: 0:00:14.275976

exit_message:

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

id: 162003171

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_roles/2026-04-14/1776160758",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-14/1776160758/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 9494135990475316232,
        "service_name": "drive-thru",
        "span_id": 4151601483429213428,
        "trace_id": 899502059072392417
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-14 05:05:30
success: True
trace_id: 899502059072392417

Scan 161945318

duration: 0:00:14.181004

exit_message:

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

id: 161945318

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_roles/2026-04-13/1776074804",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-13/1776074804/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 8219785451970351900,
        "service_name": "drive-thru",
        "span_id": 4279599722226075752,
        "trace_id": 6390566763329201788
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-13 05:08:41
success: True
trace_id: 6390566763329201788

Scan 161896421

duration: 0:00:11.739368

exit_message:

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

id: 161896421

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_roles/2026-04-12/1775988161",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-12/1775988161/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5648009645145601675,
        "service_name": "drive-thru",
        "span_id": 3229500763772642878,
        "trace_id": 11773939678482261344
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-12 05:07:18
success: True
trace_id: 11773939678482261344

Scan 161843935

duration: 0:00:14.235533

exit_message:

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

id: 161843935

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_roles/2026-04-11/1775902577",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-11/1775902577/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17686363277587399168,
        "service_name": "drive-thru",
        "span_id": 8356809271357586493,
        "trace_id": 7996198019763731666
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-11 05:17:58
success: True
trace_id: 7996198019763731666

Scan 161788608

duration: 0:00:11.699327

exit_message:

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

id: 161788608

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_roles/2026-04-10/1775815221",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-10/1775815221/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14589402462341087060,
        "service_name": "drive-thru",
        "span_id": 14148857057945720128,
        "trace_id": 1426093849462505816
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-10 05:03:00
success: True
trace_id: 1426093849462505816

Scan 161732952

duration: 0:00:14.251959

exit_message:

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

id: 161732952

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_roles/2026-04-09/1775728838",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-09/1775728838/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4153218670333091876,
        "service_name": "drive-thru",
        "span_id": 7131724467358448900,
        "trace_id": 8299418200662614049
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-09 05:02:07
success: True
trace_id: 8299418200662614049

Scan 161678339

duration: 0:00:11.847731

exit_message:

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

id: 161678339

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_roles/2026-04-08/1775642989",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-08/1775642989/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1626147264681208979,
        "service_name": "drive-thru",
        "span_id": 1498896329501205660,
        "trace_id": 8403079016357661833
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-08 05:11:25
success: True
trace_id: 8403079016357661833

Scan 161622113

duration: 0:00:14.439863

exit_message:

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

id: 161622113

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_roles/2026-04-07/1775556858",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-07/1775556858/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3533348213960989647,
        "service_name": "drive-thru",
        "span_id": 5362606042475826067,
        "trace_id": 15838084082283569892
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-07 05:16:50
success: True
trace_id: 15838084082283569892

Scan 161564278

duration: 0:00:11.694770

exit_message:

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

id: 161564278

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_roles/2026-04-06/1775470533",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-06/1775470533/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10918188532987230911,
        "service_name": "drive-thru",
        "span_id": 4226068786220439497,
        "trace_id": 12811082311788746305
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-06 05:18:00
success: True
trace_id: 12811082311788746305

Scan 161516644

duration: 0:00:11.637743

exit_message:

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

id: 161516644

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_roles/2026-04-05/1775382947",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-05/1775382947/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 14864359902935912752,
        "service_name": "drive-thru",
        "span_id": 9642207485892064838,
        "trace_id": 13563180352484470951
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-05 04:59:23
success: True
trace_id: 13563180352484470951

Scan 161462145

duration: 0:00:11.649088

exit_message:

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

id: 161462145

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_roles/2026-04-04/1775296474",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-04/1775296474/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6541552148993448777,
        "service_name": "drive-thru",
        "span_id": 748358131912728427,
        "trace_id": 2423372335389844885
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-04 04:57:02
success: True
trace_id: 2423372335389844885

Scan 161404874

duration: 0:00:11.883831

exit_message:

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

id: 161404874

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_roles/2026-04-03/1775211036",
        "key": "raw/stellar_imsmodel_has_roles/2026-04-03/1775211036/model_has_roles.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsmodel_has_roles",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 13710677080706221342,
        "service_name": "drive-thru",
        "span_id": 9604344884915250899,
        "trace_id": 9348754214580040517
    }
}

running: False
schema_name_id: 3445
start_time: 2026-04-03 05:14:08
success: True
trace_id: 9348754214580040517

Partitions:

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

Schema:

attributes:

{
    "model_id": "string",
    "model_type": "string",
    "role_id": "string",
    "tenant": "string"
}

created: 2026-04-17 04:56:33

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_roles`\n(\n `tenant`  string , `role_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_roles/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_roles`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_roles"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-12-21 03:21:54",
        "disabled": false,
        "format": "raw",
        "id": 3445,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsmodel_has_roles"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "model_id": "string",
            "model_type": "string",
            "role_id": "string",
            "tenant": "string"
        },
        "created": "2026-04-17 04:56:33",
        "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_roles`\n(\n `tenant`  string , `role_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_roles/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmodel_has_roles`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmodel_has_roles"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}