Schema Info

Schema Name: sfdl_prod_drivethru.stellar_imsuser_has_permissions

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

name:

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

type: drivethrucsv

Schema Versions: 15

Version 1718015

created: 2026-04-17 04:58:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 162169369
updated: 2026-04-17 04:58:59

Version 1716746

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-16/1776334555'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-16/1776334555
id: 1716746
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 162114415
updated: 2026-04-16 05:18:12

Version 1715513

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-15/1776242369'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 162056399
updated: 2026-04-15 03:42:25

Version 1714417

created: 2026-04-14 05:05:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-14/1776160764'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-14/1776160764
id: 1714417
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 162003191
updated: 2026-04-14 05:05:54

Version 1713177

created: 2026-04-13 05:11:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-13/1776074810'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161945388
updated: 2026-04-13 05:11:37

Version 1711947

created: 2026-04-12 05:06:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-12/1775988167'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-12/1775988167
id: 1711947
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161896401
updated: 2026-04-12 05:06:43

Version 1710778

created: 2026-04-11 05:20:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-11/1775902582'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161844003
updated: 2026-04-11 05:20:40

Version 1709600

created: 2026-04-10 05:04:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-10/1775815223'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-10/1775815223
id: 1709600
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161788654
updated: 2026-04-10 05:04:37

Version 1708457

created: 2026-04-09 05:04:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-09/1775728845'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161733021
updated: 2026-04-09 05:04:44

Version 1707227

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-08/1775642998'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-08/1775642998
id: 1707227
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161678388
updated: 2026-04-08 05:14:01

Version 1706050

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-07/1775556864'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161622128
updated: 2026-04-07 05:17:40

Version 1704837

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-06/1775470539'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-06/1775470539
id: 1704837
processed: 1

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161564312
updated: 2026-04-06 05:19:24

Version 1703636

created: 2026-04-05 04:59:41

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-05/1775382952'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161516674
updated: 2026-04-05 04:59:55

Version 1702473

created: 2026-04-04 04:58:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-04/1775296475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161462201
updated: 2026-04-04 04:58:24

Version 1701286

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-03/1775211042'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
]

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

raw_data:

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

schema_attributes:

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

schema_name_id: 1488
schema_scan_id: 161404885
updated: 2026-04-03 05:14:46

Schema Scans: 15

Last at 2026-04-17 04:58:45

Scan 162169369

duration: 0:00:14.160253

exit_message:

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

id: 162169369

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-17/1776419655",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-17/1776419655/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11688366716899725602,
        "service_name": "drive-thru",
        "span_id": 9589607079241861181,
        "trace_id": 5498219070517314884
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-17 04:58:45
success: True
trace_id: 5498219070517314884

Scan 162114415

duration: 0:00:11.522425

exit_message:

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

id: 162114415

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-16/1776334555",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-16/1776334555/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 3886320396815281702,
        "service_name": "drive-thru",
        "span_id": 11507501312980750370,
        "trace_id": 7983252486184952707
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-16 05:18:01
success: True
trace_id: 7983252486184952707

Scan 162056399

duration: 0:00:14.076848

exit_message:

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

id: 162056399

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-15/1776242369",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-15/1776242369/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 5560479227018917780,
        "service_name": "drive-thru",
        "span_id": 5087536551550623440,
        "trace_id": 8666309049375380630
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-15 03:42:11
success: True
trace_id: 8666309049375380630

Scan 162003191

duration: 0:00:11.463480

exit_message:

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

id: 162003191

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-14/1776160764",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-14/1776160764/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 6680210977691535978,
        "service_name": "drive-thru",
        "span_id": 7959038091874012618,
        "trace_id": 16279425163817916610
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-14 05:05:42
success: True
trace_id: 16279425163817916610

Scan 161945388

duration: 0:00:14.331169

exit_message:

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

id: 161945388

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-13/1776074810",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-13/1776074810/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 15341251254301951738,
        "service_name": "drive-thru",
        "span_id": 7720286186888191,
        "trace_id": 6194334092646595312
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-13 05:11:23
success: True
trace_id: 6194334092646595312

Scan 161896401

duration: 0:00:11.593672

exit_message:

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

id: 161896401

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-12/1775988167",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-12/1775988167/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1484506057636623035,
        "service_name": "drive-thru",
        "span_id": 16399387929898441004,
        "trace_id": 11063197222430946779
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-12 05:06:32
success: True
trace_id: 11063197222430946779

Scan 161844003

duration: 0:00:11.582728

exit_message:

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

id: 161844003

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-11/1775902582",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-11/1775902582/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 7008417478689595480,
        "service_name": "drive-thru",
        "span_id": 7455655004120057112,
        "trace_id": 6070514961335342924
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-11 05:20:28
success: True
trace_id: 6070514961335342924

Scan 161788654

duration: 0:00:14.058015

exit_message:

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

id: 161788654

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-10/1775815223",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-10/1775815223/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 1167429721433746745,
        "service_name": "drive-thru",
        "span_id": 5396543634045944666,
        "trace_id": 4488438031198283565
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-10 05:04:23
success: True
trace_id: 4488438031198283565

Scan 161733021

duration: 0:00:11.455202

exit_message:

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

id: 161733021

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-09/1775728845",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-09/1775728845/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12544395102522473977,
        "service_name": "drive-thru",
        "span_id": 3826737527539760683,
        "trace_id": 3748027781580415353
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-09 05:04:32
success: True
trace_id: 3748027781580415353

Scan 161678388

duration: 0:00:11.688120

exit_message:

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

id: 161678388

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-08/1775642998",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-08/1775642998/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 17335804506168988547,
        "service_name": "drive-thru",
        "span_id": 4385514433329875096,
        "trace_id": 1678797935152825851
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-08 05:13:50
success: True
trace_id: 1678797935152825851

Scan 161622128

duration: 0:00:11.503816

exit_message:

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

id: 161622128

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-07/1775556864",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-07/1775556864/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12847812497923263077,
        "service_name": "drive-thru",
        "span_id": 7794941243320975835,
        "trace_id": 17306942384044162058
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-07 05:17:28
success: True
trace_id: 17306942384044162058

Scan 161564312

duration: 0:00:11.626486

exit_message:

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

id: 161564312

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-06/1775470539",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-06/1775470539/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 10018741643112666231,
        "service_name": "drive-thru",
        "span_id": 1339886860108247147,
        "trace_id": 14124158036038676187
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-06 05:19:12
success: True
trace_id: 14124158036038676187

Scan 161516674

duration: 0:00:14.041220

exit_message:

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

id: 161516674

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-05/1775382952",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-05/1775382952/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 11537769700580346775,
        "service_name": "drive-thru",
        "span_id": 8818563339196720976,
        "trace_id": 10065680846217392419
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-05 04:59:41
success: True
trace_id: 10065680846217392419

Scan 161462201

duration: 0:00:13.962780

exit_message:

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

id: 161462201

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-04/1775296475",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-04/1775296475/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 12592486071824930933,
        "service_name": "drive-thru",
        "span_id": 4482377503444247003,
        "trace_id": 1215794617050688276
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-04 04:58:10
success: True
trace_id: 1215794617050688276

Scan 161404885

duration: 0:00:11.531647

exit_message:

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

id: 161404885

payload:

{
    "datatype_dict": null,
    "file_format": "csv",
    "file_properties": {
        "data_has_header_row": true
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-drivethrucsv-drivethru-prod",
        "hive_path": "s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-03/1775211042",
        "key": "raw/stellar_imsuser_has_permissions/2026-04-03/1775211042/user_has_permissions.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_drivethru.stellar_imsuser_has_permissions",
        "type": "drivethrucsv"
    },
    "trace_context": {
        "parent_id": 4832367777343959182,
        "service_name": "drive-thru",
        "span_id": 16054101738271129249,
        "trace_id": 13455600515794269785
    }
}

running: False
schema_name_id: 1488
start_time: 2026-04-03 05:14:34
success: True
trace_id: 13455600515794269785

Partitions:

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

Schema:

attributes:

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

created: 2026-04-17 04:58:46

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
}

Server:

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

Raw:

{
    "name": {
        "created": "2023-02-07 01:47:59",
        "disabled": false,
        "format": "raw",
        "id": 1488,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_drivethru",
            "table": "stellar_imsuser_has_permissions"
        },
        "type": "drivethrucsv"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "permission_id": "string",
            "tenant": "string",
            "user_id": "string"
        },
        "created": "2026-04-17 04:58:46",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_permissions`\n(\n `tenant`  string , `user_id`  string , `permission_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.OpenCSVSerde'\n WITH SERDEPROPERTIES ( 'separatorChar' = ',', 'quoteChar' = '\"', 'escapeChar' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_permissions/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_permissions`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_permissions"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}