Schema Info
Schema Name: sfdl_prod_drivethru.stellar_imsmigrations
- created: 2023-02-07 01:45:48
- disabled: False
- format: raw
- id: 1444
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_drivethru", "table": "stellar_imsmigrations" } - type: drivethrucsv
Schema Versions: 15
-
Version 1718002
- created: 2026-04-17 04:58:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-17/1776419649
- id: 1718002
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 162169342
- updated: 2026-04-17 04:58:19
-
Version 1716707
- created: 2026-04-16 05:16:34
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-16/1776334549'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-16/1776334549
- id: 1716707
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 162114376
- updated: 2026-04-16 05:16:48
-
Version 1715486
- created: 2026-04-15 03:41:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-15/1776242362'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-15/1776242362
- id: 1715486
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 162056369
- updated: 2026-04-15 03:41:20
-
Version 1714411
- created: 2026-04-14 05:05:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-14/1776160757'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-14/1776160757
- id: 1714411
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 162003157
- updated: 2026-04-14 05:05:29
-
Version 1713092
- created: 2026-04-13 05:08:00
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-13/1776074803'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-13/1776074803
- id: 1713092
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161945298
- updated: 2026-04-13 05:08:13
-
Version 1711929
- created: 2026-04-12 05:05:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-12/1775988161'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-12/1775988161
- id: 1711929
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161896378
- updated: 2026-04-12 05:05:50
-
Version 1710770
- created: 2026-04-11 05:20:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-11/1775902577'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-11/1775902577
- id: 1710770
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161843992
- updated: 2026-04-11 05:20:19
-
Version 1709553
- created: 2026-04-10 05:02:28
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-10/1775815220'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-10/1775815220
- id: 1709553
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161788594
- updated: 2026-04-10 05:02:42
-
Version 1708417
- created: 2026-04-09 05:02:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-09/1775728840'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-09/1775728840
- id: 1708417
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161732976
- updated: 2026-04-09 05:03:12
-
Version 1707178
- created: 2026-04-08 05:11:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-08/1775642997'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-08/1775642997
- id: 1707178
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161678337
- updated: 2026-04-08 05:11:25
-
Version 1706022
- created: 2026-04-07 05:16:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-07/1775556858'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-07/1775556858
- id: 1706022
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161622100
- updated: 2026-04-07 05:16:37
-
Version 1704850
- created: 2026-04-06 05:19:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-06/1775470533'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-06/1775470533
- id: 1704850
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161564329
- updated: 2026-04-06 05:20:01
-
Version 1703602
- created: 2026-04-05 04:58:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-05/1775382946'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-05/1775382946
- id: 1703602
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161516603
- updated: 2026-04-05 04:58:57
-
Version 1702448
- created: 2026-04-04 04:57:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-04/1775296473'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-04/1775296473
- id: 1702448
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161462151
- updated: 2026-04-04 04:57:25
-
Version 1701226
- created: 2026-04-03 05:12:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-03/1775211037'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" ] - hive_path: s3://sfdl-drivethrucsv-drivethru-prod/raw/stellar_imsmigrations/2026-04-03/1775211037
- id: 1701226
- processed: 1
- raw_data:
{ "batch": 3, "id": 1, "migration": 2, "tenant": 0 } - schema_attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - schema_name_id: 1444
- schema_scan_id: 161404824
- updated: 2026-04-03 05:12:31
Schema Scans: 15
Last at 2026-04-17 04:58:08
-
Scan 162169342
- duration: 0:00:11.675777
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162169342
- 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_imsmigrations/2026-04-17/1776419649", "key": "raw/stellar_imsmigrations/2026-04-17/1776419649/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5484575760813447241, "service_name": "drive-thru", "span_id": 1368410345196980746, "trace_id": 4284507655218819443 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-17 04:58:08
- success: True
- trace_id: 4284507655218819443
-
Scan 162114376
- duration: 0:00:14.282746
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162114376
- 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_imsmigrations/2026-04-16/1776334549", "key": "raw/stellar_imsmigrations/2026-04-16/1776334549/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 11070390018992942557, "service_name": "drive-thru", "span_id": 17395136977293753376, "trace_id": 2877274714829895338 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-16 05:16:34
- success: True
- trace_id: 2877274714829895338
-
Scan 162056369
- duration: 0:00:11.631241
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162056369
- 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_imsmigrations/2026-04-15/1776242362", "key": "raw/stellar_imsmigrations/2026-04-15/1776242362/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 8896119178310733570, "service_name": "drive-thru", "span_id": 2420104676280770658, "trace_id": 7369877356973243648 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-15 03:41:08
- success: True
- trace_id: 7369877356973243648
-
Scan 162003157
- duration: 0:00:11.723855
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162003157
- 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_imsmigrations/2026-04-14/1776160757", "key": "raw/stellar_imsmigrations/2026-04-14/1776160757/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 9543490442127707576, "service_name": "drive-thru", "span_id": 11571950853957335012, "trace_id": 12797092558326783269 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-14 05:05:17
- success: True
- trace_id: 12797092558326783269
-
Scan 161945298
- duration: 0:00:14.355167
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161945298
- 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_imsmigrations/2026-04-13/1776074803", "key": "raw/stellar_imsmigrations/2026-04-13/1776074803/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1353491813432691810, "service_name": "drive-thru", "span_id": 7883356957007252180, "trace_id": 18313734749904032397 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-13 05:07:59
- success: True
- trace_id: 18313734749904032397
-
Scan 161896378
- duration: 0:00:11.605357
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161896378
- 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_imsmigrations/2026-04-12/1775988161", "key": "raw/stellar_imsmigrations/2026-04-12/1775988161/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10472150054197584011, "service_name": "drive-thru", "span_id": 11714269147702356024, "trace_id": 6652504726029537815 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-12 05:05:38
- success: True
- trace_id: 6652504726029537815
-
Scan 161843992
- duration: 0:00:11.700550
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161843992
- 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_imsmigrations/2026-04-11/1775902577", "key": "raw/stellar_imsmigrations/2026-04-11/1775902577/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2290850899981109073, "service_name": "drive-thru", "span_id": 6083574808524404672, "trace_id": 13238003706570407422 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-11 05:20:08
- success: True
- trace_id: 13238003706570407422
-
Scan 161788594
- duration: 0:00:14.279463
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161788594
- 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_imsmigrations/2026-04-10/1775815220", "key": "raw/stellar_imsmigrations/2026-04-10/1775815220/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 14139971868900658635, "service_name": "drive-thru", "span_id": 10074200790432707585, "trace_id": 13821620449160968345 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-10 05:02:28
- success: True
- trace_id: 13821620449160968345
-
Scan 161732976
- duration: 0:00:14.232882
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161732976
- 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_imsmigrations/2026-04-09/1775728840", "key": "raw/stellar_imsmigrations/2026-04-09/1775728840/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 10675298999660811442, "service_name": "drive-thru", "span_id": 11248890993065230773, "trace_id": 3817744001072344161 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-09 05:02:58
- success: True
- trace_id: 3817744001072344161
-
Scan 161678337
- duration: 0:00:11.728680
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161678337
- 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_imsmigrations/2026-04-08/1775642997", "key": "raw/stellar_imsmigrations/2026-04-08/1775642997/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 15254756808707824649, "service_name": "drive-thru", "span_id": 10779344194936613093, "trace_id": 10438477325480813854 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-08 05:11:14
- success: True
- trace_id: 10438477325480813854
-
Scan 161622100
- duration: 0:00:14.212577
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161622100
- 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_imsmigrations/2026-04-07/1775556858", "key": "raw/stellar_imsmigrations/2026-04-07/1775556858/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5364133270423690513, "service_name": "drive-thru", "span_id": 10001965230181472684, "trace_id": 17058125266371031391 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-07 05:16:23
- success: True
- trace_id: 17058125266371031391
-
Scan 161564329
- duration: 0:00:14.196977
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161564329
- 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_imsmigrations/2026-04-06/1775470533", "key": "raw/stellar_imsmigrations/2026-04-06/1775470533/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 5104873597595557409, "service_name": "drive-thru", "span_id": 7705404573875955279, "trace_id": 51132783738607690 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-06 05:19:46
- success: True
- trace_id: 51132783738607690
-
Scan 161516603
- duration: 0:00:14.062049
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161516603
- 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_imsmigrations/2026-04-05/1775382946", "key": "raw/stellar_imsmigrations/2026-04-05/1775382946/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 16557897102038958749, "service_name": "drive-thru", "span_id": 10590601997403772876, "trace_id": 1184651545522936860 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-05 04:58:43
- success: True
- trace_id: 1184651545522936860
-
Scan 161462151
- duration: 0:00:11.717513
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161462151
- 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_imsmigrations/2026-04-04/1775296473", "key": "raw/stellar_imsmigrations/2026-04-04/1775296473/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 2513322409154293361, "service_name": "drive-thru", "span_id": 7655007517742586612, "trace_id": 13534499542823391678 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-04 04:57:14
- success: True
- trace_id: 13534499542823391678
-
Scan 161404824
- duration: 0:00:14.312242
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161404824
- 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_imsmigrations/2026-04-03/1775211037", "key": "raw/stellar_imsmigrations/2026-04-03/1775211037/migrations.csv.gz" }, "schema": { "name": "sfdl_prod_drivethru.stellar_imsmigrations", "type": "drivethrucsv" }, "trace_context": { "parent_id": 1144682245508604811, "service_name": "drive-thru", "span_id": 10182700878069780119, "trace_id": 3608317864155344860 } } - running: False
- schema_name_id: 1444
- start_time: 2026-04-03 05:12:17
- success: True
- trace_id: 3608317864155344860
- attributes:
{ "1_2": "string", "1_3": "string", "2": "string", "2014_10_12_000000_create_users_table": "string", "2014_10_12_100000_create_password_resets_table": "string", "2017_03_06_024635_create_permission_tables": "string", "batch": "string", "batch_1": "string", "id": "string", "migration": "string", "tenant": "string" } - created: 2026-04-17 04:58:08
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations" }
- 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:45:48",
"disabled": false,
"format": "raw",
"id": 1444,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_drivethru",
"table": "stellar_imsmigrations"
},
"type": "drivethrucsv"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"1_2": "string",
"1_3": "string",
"2": "string",
"2014_10_12_000000_create_users_table": "string",
"2014_10_12_100000_create_password_resets_table": "string",
"2017_03_06_024635_create_permission_tables": "string",
"batch": "string",
"batch_1": "string",
"id": "string",
"migration": "string",
"tenant": "string"
},
"created": "2026-04-17 04:58:08",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_drivethru`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_drivethru.stellar_imsmigrations`\n(\n `tenant` string , `id` string , `migration` string , `batch` 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_imsmigrations/2026-04-17/1776419649'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_drivethru.stellar_imsmigrations`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_drivethru.stellar_imsmigrations"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}