Schema Info
Schema Name: sfdl_stage_postgres.schemamanager_schema_types
- created: 2021-08-17 12:13:51
- disabled: False
- format: raw
- id: 1142
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_postgres", "table": "schemamanager_schema_types" } - type: postgres
Schema Versions: 15
-
Version 906507
- created: 2026-04-16 12:00:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-16/1776358829'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-16/1776358829
- id: 906507
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6414984
- updated: 2026-04-16 12:00:56
-
Version 906294
- created: 2026-04-15 12:01:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-15/1776272431'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-15/1776272431
- id: 906294
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6414461
- updated: 2026-04-15 12:01:17
-
Version 906081
- created: 2026-04-14 12:01:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-14/1776186031'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-14/1776186031
- id: 906081
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6413971
- updated: 2026-04-14 12:01:18
-
Version 905866
- created: 2026-04-13 12:00:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-13/1776099628'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-13/1776099628
- id: 905866
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6413459
- updated: 2026-04-13 12:01:11
-
Version 905657
- created: 2026-04-12 12:00:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-12/1776013230'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-12/1776013230
- id: 905657
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6412964
- updated: 2026-04-12 12:01:06
-
Version 905455
- created: 2026-04-11 12:00:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-11/1775926831'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-11/1775926831
- id: 905455
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6412584
- updated: 2026-04-11 12:01:10
-
Version 905245
- created: 2026-04-10 12:00:36
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-10/1775840429'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-10/1775840429
- id: 905245
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6412148
- updated: 2026-04-10 12:00:50
-
Version 905033
- created: 2026-04-09 12:01:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-09/1775754034'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-09/1775754034
- id: 905033
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6411639
- updated: 2026-04-09 12:01:18
-
Version 904817
- created: 2026-04-08 12:01:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-08/1775667632'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-08/1775667632
- id: 904817
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6411133
- updated: 2026-04-08 12:01:14
-
Version 904605
- created: 2026-04-07 12:00:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-07/1775581233'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-07/1775581233
- id: 904605
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6410628
- updated: 2026-04-07 12:01:11
-
Version 904389
- created: 2026-04-06 12:00:50
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-06/1775494832'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-06/1775494832
- id: 904389
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6410122
- updated: 2026-04-06 12:01:02
-
Version 904184
- created: 2026-04-05 12:00:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-05/1775408428'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-05/1775408428
- id: 904184
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6409634
- updated: 2026-04-05 12:01:10
-
Version 903982
- created: 2026-04-04 12:00:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-04/1775322027'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-04/1775322027
- id: 903982
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6409256
- updated: 2026-04-04 12:01:00
-
Version 903774
- created: 2026-04-03 12:01:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-03/1775235631'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-03/1775235631
- id: 903774
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6408824
- updated: 2026-04-03 12:01:18
-
Version 903556
- created: 2026-04-02 12:00:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-02/1775149231'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-02/1775149231
- id: 903556
- processed: 1
- raw_data:
{ "created": 2, "extra": 4, "id": 0, "perform_parquet": 3, "type": 1 } - schema_attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - schema_name_id: 1142
- schema_scan_id: 6408310
- updated: 2026-04-02 12:00:56
Schema Scans: 15
Last at 2026-04-16 12:00:44
-
Scan 6414984
- duration: 0:00:11.800590
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414984
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-16/1776358829", "key": "raw/schema_types/2026-04-16/1776358829/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 12244940235623235007, "service_name": "schema_manager", "span_id": 5564133296735725272, "trace_id": 12244940235623235007 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-16 12:00:44
- success: True
- trace_id: 12244940235623235007
-
Scan 6414461
- duration: 0:00:14.476997
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6414461
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-15/1776272431", "key": "raw/schema_types/2026-04-15/1776272431/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 14362800248418389143, "service_name": "schema_manager", "span_id": 13279635587601088761, "trace_id": 14362800248418389143 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-15 12:01:03
- success: True
- trace_id: 14362800248418389143
-
Scan 6413971
- duration: 0:00:14.328962
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413971
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-14/1776186031", "key": "raw/schema_types/2026-04-14/1776186031/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 2902136834897267458, "service_name": "schema_manager", "span_id": 12915591278081849037, "trace_id": 2902136834897267458 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-14 12:01:03
- success: True
- trace_id: 2902136834897267458
-
Scan 6413459
- duration: 0:00:14.337476
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6413459
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-13/1776099628", "key": "raw/schema_types/2026-04-13/1776099628/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 1187280296475660561, "service_name": "schema_manager", "span_id": 3104073279245175347, "trace_id": 1187280296475660561 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-13 12:00:56
- success: True
- trace_id: 1187280296475660561
-
Scan 6412964
- duration: 0:00:11.780744
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412964
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-12/1776013230", "key": "raw/schema_types/2026-04-12/1776013230/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 604453814702928138, "service_name": "schema_manager", "span_id": 4966291686465898691, "trace_id": 604453814702928138 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-12 12:00:54
- success: True
- trace_id: 604453814702928138
-
Scan 6412584
- duration: 0:00:14.363420
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412584
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-11/1775926831", "key": "raw/schema_types/2026-04-11/1775926831/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 8758226996891396145, "service_name": "schema_manager", "span_id": 16651942955921629604, "trace_id": 8758226996891396145 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-11 12:00:55
- success: True
- trace_id: 8758226996891396145
-
Scan 6412148
- duration: 0:00:14.296210
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6412148
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-10/1775840429", "key": "raw/schema_types/2026-04-10/1775840429/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 8318218749590290531, "service_name": "schema_manager", "span_id": 7657477326098425432, "trace_id": 8318218749590290531 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-10 12:00:36
- success: True
- trace_id: 8318218749590290531
-
Scan 6411639
- duration: 0:00:14.455015
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411639
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-09/1775754034", "key": "raw/schema_types/2026-04-09/1775754034/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 4353507521859180840, "service_name": "schema_manager", "span_id": 5773539987082160733, "trace_id": 4353507521859180840 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-09 12:01:04
- success: True
- trace_id: 4353507521859180840
-
Scan 6411133
- duration: 0:00:11.813528
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6411133
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-08/1775667632", "key": "raw/schema_types/2026-04-08/1775667632/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 10294656741815558465, "service_name": "schema_manager", "span_id": 11487871821114300828, "trace_id": 10294656741815558465 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-08 12:01:02
- success: True
- trace_id: 10294656741815558465
-
Scan 6410628
- duration: 0:00:14.385802
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410628
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-07/1775581233", "key": "raw/schema_types/2026-04-07/1775581233/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 10051798056042667341, "service_name": "schema_manager", "span_id": 16613969950923088262, "trace_id": 10051798056042667341 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-07 12:00:56
- success: True
- trace_id: 10051798056042667341
-
Scan 6410122
- duration: 0:00:11.803345
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6410122
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-06/1775494832", "key": "raw/schema_types/2026-04-06/1775494832/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 9314187739219346268, "service_name": "schema_manager", "span_id": 1468178967356858959, "trace_id": 9314187739219346268 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-06 12:00:50
- success: True
- trace_id: 9314187739219346268
-
Scan 6409634
- duration: 0:00:11.704825
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409634
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-05/1775408428", "key": "raw/schema_types/2026-04-05/1775408428/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 3410935499188886900, "service_name": "schema_manager", "span_id": 4821290031393843599, "trace_id": 3410935499188886900 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-05 12:00:58
- success: True
- trace_id: 3410935499188886900
-
Scan 6409256
- duration: 0:00:14.191265
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6409256
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-04/1775322027", "key": "raw/schema_types/2026-04-04/1775322027/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 17648756504264509356, "service_name": "schema_manager", "span_id": 7677797143418663682, "trace_id": 17648756504264509356 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-04 12:00:46
- success: True
- trace_id: 17648756504264509356
-
Scan 6408824
- duration: 0:00:14.388577
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408824
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-03/1775235631", "key": "raw/schema_types/2026-04-03/1775235631/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 2370077364101792138, "service_name": "schema_manager", "span_id": 9415297677787078787, "trace_id": 2370077364101792138 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-03 12:01:03
- success: True
- trace_id: 2370077364101792138
-
Scan 6408310
- duration: 0:00:14.265977
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6408310
- payload:
{ "datatype_dict": { "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-schemamanager-stage", "hive_path": "s3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-02/1775149231", "key": "raw/schema_types/2026-04-02/1775149231/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 6559955426698869124, "service_name": "schema_manager", "span_id": 14867671348983701412, "trace_id": 6559955426698869124 } } - running: False
- schema_name_id: 1142
- start_time: 2026-04-02 12:00:42
- success: True
- trace_id: 6559955426698869124
- attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - created: 2026-04-16 12:00:45
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-16/1776358829'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2021-08-17 12:13:51",
"disabled": false,
"format": "raw",
"id": 1142,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_postgres",
"table": "schemamanager_schema_types"
},
"type": "postgres"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"created": "timestamp",
"extra": "string",
"id": "int",
"perform_parquet": "string",
"type": "string"
},
"created": "2026-04-16 12:00:45",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.schemamanager_schema_types`\n(\n `id` int , `type` string , `created` timestamp , `perform_parquet` string , `extra` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-schemamanager-stage/raw/schema_types/2026-04-16/1776358829'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_postgres.schemamanager_schema_types`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_postgres.schemamanager_schema_types"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}