Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsuser_has_roles
- created: 2023-02-07 01:47:36
- disabled: False
- format: raw
- id: 1481
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsuser_has_roles" } - type: drivethrucsv
Schema Versions: 15
-
Version 1718021
- created: 2026-04-17 04:58:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-17/1776419655
- id: 1718021
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 162169375
- updated: 2026-04-17 04:59:06
-
Version 1716785
- created: 2026-04-16 05:19:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-16/1776334556'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-16/1776334556
- id: 1716785
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 162114457
- updated: 2026-04-16 05:19:47
-
Version 1715515
- created: 2026-04-15 03:42:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-15/1776242369'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-15/1776242369
- id: 1715515
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 162056400
- updated: 2026-04-15 03:42:30
-
Version 1714408
- created: 2026-04-14 05:05:06
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-14/1776160764'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-14/1776160764
- id: 1714408
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 162003149
- updated: 2026-04-14 05:05:19
-
Version 1713125
- created: 2026-04-13 05:09:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-13/1776074810'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-13/1776074810
- id: 1713125
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161945331
- updated: 2026-04-13 05:09:25
-
Version 1711992
- created: 2026-04-12 05:09:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-12/1775988167'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-12/1775988167
- id: 1711992
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161896459
- updated: 2026-04-12 05:09:37
-
Version 1710779
- 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_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-11/1775902583'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-11/1775902583
- id: 1710779
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161844002
- updated: 2026-04-11 05:20:41
-
Version 1709608
- created: 2026-04-10 05:04:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-10/1775815223'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-10/1775815223
- id: 1709608
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161788671
- updated: 2026-04-10 05:04:59
-
Version 1708455
- created: 2026-04-09 05:04:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-09/1775728845'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-09/1775728845
- id: 1708455
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161733018
- updated: 2026-04-09 05:04:42
-
Version 1707177
- created: 2026-04-08 05:11:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-08/1775642996'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-08/1775642996
- id: 1707177
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161678336
- updated: 2026-04-08 05:11:27
-
Version 1706078
- created: 2026-04-07 05:18:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-07/1775556864'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-07/1775556864
- id: 1706078
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161622171
- updated: 2026-04-07 05:18:54
-
Version 1704832
- created: 2026-04-06 05:19:01
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-06/1775470540'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-06/1775470540
- id: 1704832
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161564307
- updated: 2026-04-06 05:19:15
-
Version 1703604
- created: 2026-04-05 04:58:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-05/1775382953'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-05/1775382953
- id: 1703604
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161516605
- updated: 2026-04-05 04:58:57
-
Version 1702494
- created: 2026-04-04 04:58:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-04/1775296475'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-04/1775296475
- id: 1702494
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161462269
- updated: 2026-04-04 04:59:06
-
Version 1701306
- created: 2026-04-03 05:15:31
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsuser_has_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-03/1775211042'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsuser_has_roles/2026-04-03/1775211042
- id: 1701306
- processed: 1
- raw_data:
{ "role_id": 1, "tenant": 0, "user_id": 2 } - schema_attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - schema_name_id: 1481
- schema_scan_id: 161404906
- updated: 2026-04-03 05:15:42
Schema Scans: 15
Last at 2026-04-17 04:58:50
-
Scan 162169375
- duration: 0:00:15.752116
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169375
- 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_roles/2026-04-17/1776419655", "key": "raw/stellar_imsuser_has_roles/2026-04-17/1776419655/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13434112209604794692, "service_name": "drive-thru", "span_id": 2649457656832768396, "trace_id": 12731352300143004891 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-17 04:58:50
- success: True
- trace_id: 12731352300143004891
-
Scan 162114457
- duration: 0:00:15.850439
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114457
- 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_roles/2026-04-16/1776334556", "key": "raw/stellar_imsuser_has_roles/2026-04-16/1776334556/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9628871678456996344, "service_name": "drive-thru", "span_id": 13720979499230230565, "trace_id": 1506126619888778006 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-16 05:19:32
- success: True
- trace_id: 1506126619888778006
-
Scan 162056400
- duration: 0:00:15.739178
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056400
- 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_roles/2026-04-15/1776242369", "key": "raw/stellar_imsuser_has_roles/2026-04-15/1776242369/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15107423839206746891, "service_name": "drive-thru", "span_id": 619560109834905493, "trace_id": 17945153752622467787 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-15 03:42:14
- success: True
- trace_id: 17945153752622467787
-
Scan 162003149
- duration: 0:00:15.686617
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003149
- 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_roles/2026-04-14/1776160764", "key": "raw/stellar_imsuser_has_roles/2026-04-14/1776160764/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6928187631114390867, "service_name": "drive-thru", "span_id": 11055980806900932997, "trace_id": 7384733676258809839 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-14 05:05:04
- success: True
- trace_id: 7384733676258809839
-
Scan 161945331
- duration: 0:00:15.739972
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945331
- 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_roles/2026-04-13/1776074810", "key": "raw/stellar_imsuser_has_roles/2026-04-13/1776074810/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13446399414179990413, "service_name": "drive-thru", "span_id": 4930529948850561619, "trace_id": 12569666442469528425 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-13 05:09:10
- success: True
- trace_id: 12569666442469528425
-
Scan 161896459
- duration: 0:00:13.159080
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896459
- 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_roles/2026-04-12/1775988167", "key": "raw/stellar_imsuser_has_roles/2026-04-12/1775988167/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 13766589423545550430, "service_name": "drive-thru", "span_id": 12249835808647041812, "trace_id": 9154588317413949250 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-12 05:09:24
- success: True
- trace_id: 9154588317413949250
-
Scan 161844002
- duration: 0:00:13.214962
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161844002
- 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_roles/2026-04-11/1775902583", "key": "raw/stellar_imsuser_has_roles/2026-04-11/1775902583/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 17336551916033410470, "service_name": "drive-thru", "span_id": 8213151183061109816, "trace_id": 5993456995840821755 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-11 05:20:27
- success: True
- trace_id: 5993456995840821755
-
Scan 161788671
- duration: 0:00:15.815779
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788671
- 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_roles/2026-04-10/1775815223", "key": "raw/stellar_imsuser_has_roles/2026-04-10/1775815223/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 3071340606161336412, "service_name": "drive-thru", "span_id": 5516190976419966017, "trace_id": 15769839180382736337 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-10 05:04:43
- success: True
- trace_id: 15769839180382736337
-
Scan 161733018
- duration: 0:00:13.243932
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161733018
- 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_roles/2026-04-09/1775728845", "key": "raw/stellar_imsuser_has_roles/2026-04-09/1775728845/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 6257152012830891749, "service_name": "drive-thru", "span_id": 9390894897965344517, "trace_id": 12399177267773487544 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-09 05:04:29
- success: True
- trace_id: 12399177267773487544
-
Scan 161678336
- duration: 0:00:15.719403
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678336
- 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_roles/2026-04-08/1775642996", "key": "raw/stellar_imsuser_has_roles/2026-04-08/1775642996/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12323816921167448228, "service_name": "drive-thru", "span_id": 13701065787508833363, "trace_id": 18432109565698450598 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-08 05:11:12
- success: True
- trace_id: 18432109565698450598
-
Scan 161622171
- duration: 0:00:13.343231
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622171
- 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_roles/2026-04-07/1775556864", "key": "raw/stellar_imsuser_has_roles/2026-04-07/1775556864/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16476930697292637094, "service_name": "drive-thru", "span_id": 5619386968074086294, "trace_id": 15441404116189520544 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-07 05:18:40
- success: True
- trace_id: 15441404116189520544
-
Scan 161564307
- duration: 0:00:15.748399
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564307
- 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_roles/2026-04-06/1775470540", "key": "raw/stellar_imsuser_has_roles/2026-04-06/1775470540/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 586234942571896660, "service_name": "drive-thru", "span_id": 296234974534371273, "trace_id": 2453001911065536835 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-06 05:18:59
- success: True
- trace_id: 2453001911065536835
-
Scan 161516605
- duration: 0:00:13.098139
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516605
- 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_roles/2026-04-05/1775382953", "key": "raw/stellar_imsuser_has_roles/2026-04-05/1775382953/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 180737039625221189, "service_name": "drive-thru", "span_id": 16209994736941047161, "trace_id": 13498908936587313160 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-05 04:58:44
- success: True
- trace_id: 13498908936587313160
-
Scan 161462269
- duration: 0:00:13.332846
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462269
- 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_roles/2026-04-04/1775296475", "key": "raw/stellar_imsuser_has_roles/2026-04-04/1775296475/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15866706443142435003, "service_name": "drive-thru", "span_id": 9057831594257621605, "trace_id": 3266235249101501807 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-04 04:58:52
- success: True
- trace_id: 3266235249101501807
-
Scan 161404906
- duration: 0:00:13.302074
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404906
- 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_roles/2026-04-03/1775211042", "key": "raw/stellar_imsuser_has_roles/2026-04-03/1775211042/user_has_roles.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsuser_has_roles", "type": "drivethrucsv" }, "trace_context": { "parent_id": 12667767260874461052, "service_name": "drive-thru", "span_id": 6507481675727261071, "trace_id": 5266666597383674128 } } - running: False
- schema_name_id: 1481
- start_time: 2026-04-03 05:15:29
- success: True
- trace_id: 5266666597383674128
- attributes:
{ "100_5": "string", "101_5": "string", "102_5": "string", "103_5": "string", "104_5": "string", "105_5": "string", "106_5": "string", "107_5": "string", "108_5": "string", "109_5": "string", "10_5": "string", "110_5": "string", "111_5": "string", "112_5": "string", "113_5": "string", "114": "string", "11_5": "string", "12_5": "string", "13_5": "string", "14_5": "string", "15_5": "string", "16_5": "string", "17_5": "string", "18_5": "string", "19_5": "string", "1_1": "string", "20_5": "string", "21_5": "string", "22_5": "string", "23_5": "string", "24_5": "string", "25_5": "string", "26_5": "string", "27_5": "string", "28_5": "string", "29_5": "string", "30_5": "string", "31_5": "string", "32_5": "string", "33_5": "string", "34_5": "string", "35_5": "string", "36_5": "string", "37_5": "string", "38_5": "string", "39_5": "string", "3_9": "string", "40_5": "string", "41_5": "string", "42_5": "string", "43_5": "string", "44_5": "string", "45_5": "string", "46_5": "string", "47_5": "string", "48_5": "string", "49_5": "string", "4_5": "string", "50_5": "string", "51_5": "string", "52_5": "string", "53_5": "string", "54_5": "string", "55_5": "string", "56_5": "string", "57_5": "string", "58_5": "string", "59_5": "string", "5_1": "string", "60_5": "string", "61_5": "string", "62_5": "string", "63_5": "string", "64_5": "string", "65_5": "string", "66_5": "string", "67_5": "string", "68_5": "string", "69_5": "string", "6_1": "string", "70_5": "string", "71_5": "string", "72_5": "string", "73_5": "string", "74_5": "string", "75_5": "string", "76_5": "string", "77_5": "string", "78_5": "string", "79_5": "string", "7_2": "string", "80_5": "string", "81_5": "string", "82_5": "string", "83_5": "string", "84_5": "string", "85_5": "string", "86_5": "string", "87_5": "string", "88_5": "string", "89_5": "string", "8_5": "string", "90_5": "string", "91_5": "string", "92_5": "string", "93_5": "string", "94_5": "string", "95_5": "string", "96_5": "string", "97_5": "string", "98_5": "string", "99_5": "string", "9_5": "string", "role_id": "string", "tenant": "string", "user_id": "string", "user_id_1": "string" } - created: 2026-04-17 04:58:52
- 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_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2023-02-07 01:47:36",
"disabled": false,
"format": "raw",
"id": 1481,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsuser_has_roles"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"100_5": "string",
"101_5": "string",
"102_5": "string",
"103_5": "string",
"104_5": "string",
"105_5": "string",
"106_5": "string",
"107_5": "string",
"108_5": "string",
"109_5": "string",
"10_5": "string",
"110_5": "string",
"111_5": "string",
"112_5": "string",
"113_5": "string",
"114": "string",
"11_5": "string",
"12_5": "string",
"13_5": "string",
"14_5": "string",
"15_5": "string",
"16_5": "string",
"17_5": "string",
"18_5": "string",
"19_5": "string",
"1_1": "string",
"20_5": "string",
"21_5": "string",
"22_5": "string",
"23_5": "string",
"24_5": "string",
"25_5": "string",
"26_5": "string",
"27_5": "string",
"28_5": "string",
"29_5": "string",
"30_5": "string",
"31_5": "string",
"32_5": "string",
"33_5": "string",
"34_5": "string",
"35_5": "string",
"36_5": "string",
"37_5": "string",
"38_5": "string",
"39_5": "string",
"3_9": "string",
"40_5": "string",
"41_5": "string",
"42_5": "string",
"43_5": "string",
"44_5": "string",
"45_5": "string",
"46_5": "string",
"47_5": "string",
"48_5": "string",
"49_5": "string",
"4_5": "string",
"50_5": "string",
"51_5": "string",
"52_5": "string",
"53_5": "string",
"54_5": "string",
"55_5": "string",
"56_5": "string",
"57_5": "string",
"58_5": "string",
"59_5": "string",
"5_1": "string",
"60_5": "string",
"61_5": "string",
"62_5": "string",
"63_5": "string",
"64_5": "string",
"65_5": "string",
"66_5": "string",
"67_5": "string",
"68_5": "string",
"69_5": "string",
"6_1": "string",
"70_5": "string",
"71_5": "string",
"72_5": "string",
"73_5": "string",
"74_5": "string",
"75_5": "string",
"76_5": "string",
"77_5": "string",
"78_5": "string",
"79_5": "string",
"7_2": "string",
"80_5": "string",
"81_5": "string",
"82_5": "string",
"83_5": "string",
"84_5": "string",
"85_5": "string",
"86_5": "string",
"87_5": "string",
"88_5": "string",
"89_5": "string",
"8_5": "string",
"90_5": "string",
"91_5": "string",
"92_5": "string",
"93_5": "string",
"94_5": "string",
"95_5": "string",
"96_5": "string",
"97_5": "string",
"98_5": "string",
"99_5": "string",
"9_5": "string",
"role_id": "string",
"tenant": "string",
"user_id": "string",
"user_id_1": "string"
},
"created": "2026-04-17 04:58:52",
"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_roles`\n(\n `tenant` string , `role_id` string , `user_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_roles/2026-04-17/1776419655'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsuser_has_roles`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsuser_has_roles"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}