Schema Info
Schema Name: sfdl_prod_postgres.schemamanager_schema_types
- created: 2021-08-20 12:13:11
- disabled: False
- format: raw
- id: 946
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_postgres", "table": "schemamanager_schema_types" } - type: postgres
Schema Versions: 15
-
Version 1718331
- created: 2026-04-17 12:05:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-17/1776445231'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-17/1776445231
- id: 1718331
- 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: 946
- schema_scan_id: 162187248
- updated: 2026-04-17 12:05:30
-
Version 1717090
- created: 2026-04-16 12:02:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-16/1776358831'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-16/1776358831
- id: 1717090
- 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: 946
- schema_scan_id: 162130916
- updated: 2026-04-16 12:02:29
-
Version 1715900
- created: 2026-04-15 12:04:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-15/1776272433'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-15/1776272433
- id: 1715900
- 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: 946
- schema_scan_id: 162075466
- updated: 2026-04-15 12:04:53
-
Version 1714671
- created: 2026-04-14 12:02:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-14/1776186032'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-14/1776186032
- id: 1714671
- 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: 946
- schema_scan_id: 162019348
- updated: 2026-04-14 12:03:00
-
Version 1713476
- created: 2026-04-13 12:02:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-13/1776099629'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-13/1776099629
- id: 1713476
- 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: 946
- schema_scan_id: 161962785
- updated: 2026-04-13 12:03:06
-
Version 1712289
- created: 2026-04-12 12:02:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-12/1776013229'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-12/1776013229
- id: 1712289
- 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: 946
- schema_scan_id: 161910276
- updated: 2026-04-12 12:02:26
-
Version 1711078
- created: 2026-04-11 12:03:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-11/1775926829'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-11/1775926829
- id: 1711078
- 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: 946
- schema_scan_id: 161860078
- updated: 2026-04-11 12:03:29
-
Version 1709887
- created: 2026-04-10 12:02:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-10/1775840427'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-10/1775840427
- id: 1709887
- 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: 946
- schema_scan_id: 161806117
- updated: 2026-04-10 12:02:58
-
Version 1708741
- created: 2026-04-09 12:02:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-09/1775754028'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-09/1775754028
- id: 1708741
- 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: 946
- schema_scan_id: 161749867
- updated: 2026-04-09 12:02:57
-
Version 1707589
- created: 2026-04-08 12:02:35
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-08/1775667627'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-08/1775667627
- id: 1707589
- 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: 946
- schema_scan_id: 161694585
- updated: 2026-04-08 12:02:46
-
Version 1706375
- created: 2026-04-07 12:03:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-07/1775581227'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-07/1775581227
- id: 1706375
- 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: 946
- schema_scan_id: 161639295
- updated: 2026-04-07 12:04:00
-
Version 1705161
- created: 2026-04-06 12:02:54
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-06/1775494826'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-06/1775494826
- id: 1705161
- 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: 946
- schema_scan_id: 161581786
- updated: 2026-04-06 12:03:08
-
Version 1703941
- created: 2026-04-05 12:03:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-05/1775408428'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-05/1775408428
- id: 1703941
- 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: 946
- schema_scan_id: 161530518
- updated: 2026-04-05 12:03:43
-
Version 1702772
- created: 2026-04-04 12:01:55
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-04/1775322027'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-04/1775322027
- id: 1702772
- 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: 946
- schema_scan_id: 161480138
- updated: 2026-04-04 12:02:09
-
Version 1701591
- created: 2026-04-03 12:03:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-03/1775235629'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" ] - hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-03/1775235629
- id: 1701591
- 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: 946
- schema_scan_id: 161423705
- updated: 2026-04-03 12:04:08
Schema Scans: 15
Last at 2026-04-17 12:05:16
-
Scan 162187248
- duration: 0:00:14.270734
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162187248
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-17/1776445231", "key": "raw/schema_types/2026-04-17/1776445231/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 15455196994100314393, "service_name": "schema_manager", "span_id": 13019932683926061966, "trace_id": 15455196994100314393 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-17 12:05:16
- success: True
- trace_id: 15455196994100314393
-
Scan 162130916
- duration: 0:00:14.372437
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162130916
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-16/1776358831", "key": "raw/schema_types/2026-04-16/1776358831/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 55476038143836433, "service_name": "schema_manager", "span_id": 5096000293760933513, "trace_id": 55476038143836433 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-16 12:02:15
- success: True
- trace_id: 55476038143836433
-
Scan 162075466
- duration: 0:00:11.871728
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162075466
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-15/1776272433", "key": "raw/schema_types/2026-04-15/1776272433/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 12655689779110099138, "service_name": "schema_manager", "span_id": 17779315743161124716, "trace_id": 12655689779110099138 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-15 12:04:41
- success: True
- trace_id: 12655689779110099138
-
Scan 162019348
- duration: 0:00:11.658072
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162019348
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-14/1776186032", "key": "raw/schema_types/2026-04-14/1776186032/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 12585584633418729434, "service_name": "schema_manager", "span_id": 3728083290458976834, "trace_id": 12585584633418729434 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-14 12:02:48
- success: True
- trace_id: 12585584633418729434
-
Scan 161962785
- duration: 0:00:11.753287
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161962785
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-13/1776099629", "key": "raw/schema_types/2026-04-13/1776099629/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 8508654560561579782, "service_name": "schema_manager", "span_id": 11160906111551256243, "trace_id": 8508654560561579782 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-13 12:02:55
- success: True
- trace_id: 8508654560561579782
-
Scan 161910276
- duration: 0:00:11.576734
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161910276
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-12/1776013229", "key": "raw/schema_types/2026-04-12/1776013229/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 9583753873244014199, "service_name": "schema_manager", "span_id": 5623052133629863867, "trace_id": 9583753873244014199 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-12 12:02:15
- success: True
- trace_id: 9583753873244014199
-
Scan 161860078
- duration: 0:00:14.140088
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161860078
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-11/1775926829", "key": "raw/schema_types/2026-04-11/1775926829/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 2562041910242294795, "service_name": "schema_manager", "span_id": 7602599240428484296, "trace_id": 2562041910242294795 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-11 12:03:15
- success: True
- trace_id: 2562041910242294795
-
Scan 161806117
- duration: 0:00:11.718090
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161806117
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-10/1775840427", "key": "raw/schema_types/2026-04-10/1775840427/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 13270118674400306252, "service_name": "schema_manager", "span_id": 16155590444869030422, "trace_id": 13270118674400306252 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-10 12:02:46
- success: True
- trace_id: 13270118674400306252
-
Scan 161749867
- duration: 0:00:17.278280
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161749867
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-09/1775754028", "key": "raw/schema_types/2026-04-09/1775754028/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 11840168250429093282, "service_name": "schema_manager", "span_id": 15888197081074911852, "trace_id": 11840168250429093282 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-09 12:02:39
- success: True
- trace_id: 11840168250429093282
-
Scan 161694585
- duration: 0:00:11.723761
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161694585
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-08/1775667627", "key": "raw/schema_types/2026-04-08/1775667627/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 6837338759147741191, "service_name": "schema_manager", "span_id": 2737042077075768592, "trace_id": 6837338759147741191 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-08 12:02:34
- success: True
- trace_id: 6837338759147741191
-
Scan 161639295
- duration: 0:00:14.189583
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161639295
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-07/1775581227", "key": "raw/schema_types/2026-04-07/1775581227/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 110628097779178024, "service_name": "schema_manager", "span_id": 16414615730353427957, "trace_id": 110628097779178024 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-07 12:03:46
- success: True
- trace_id: 110628097779178024
-
Scan 161581786
- duration: 0:00:14.250839
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161581786
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-06/1775494826", "key": "raw/schema_types/2026-04-06/1775494826/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 698130054504677442, "service_name": "schema_manager", "span_id": 9582198432764655518, "trace_id": 698130054504677442 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-06 12:02:53
- success: True
- trace_id: 698130054504677442
-
Scan 161530518
- duration: 0:00:14.247641
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161530518
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-05/1775408428", "key": "raw/schema_types/2026-04-05/1775408428/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 6644678061906940661, "service_name": "schema_manager", "span_id": 6535766142809202673, "trace_id": 6644678061906940661 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-05 12:03:28
- success: True
- trace_id: 6644678061906940661
-
Scan 161480138
- duration: 0:00:14.133891
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161480138
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-04/1775322027", "key": "raw/schema_types/2026-04-04/1775322027/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 1229842911776325630, "service_name": "schema_manager", "span_id": 2137601560038865286, "trace_id": 1229842911776325630 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-04 12:01:55
- success: True
- trace_id: 1229842911776325630
-
Scan 161423705
- duration: 0:00:11.695064
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161423705
- 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-prod", "hive_path": "s3://sfdl-postgres-schemamanager-prod/raw/schema_types/2026-04-03/1775235629", "key": "raw/schema_types/2026-04-03/1775235629/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.schemamanager_schema_types", "type": "postgres" }, "trace_context": { "parent_id": 9075239850184950154, "service_name": "schema_manager", "span_id": 2041915660264239896, "trace_id": 9075239850184950154 } } - running: False
- schema_name_id: 946
- start_time: 2026-04-03 12:03:56
- success: True
- trace_id: 9075239850184950154
- attributes:
{ "created": "timestamp", "extra": "string", "id": "int", "perform_parquet": "string", "type": "string" } - created: 2026-04-17 12:05:16
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-17/1776445231'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2021-08-20 12:13:11",
"disabled": false,
"format": "raw",
"id": 946,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_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-17 12:05:16",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_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-prod/raw/schema_types/2026-04-17/1776445231'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_types`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_types"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}