Schema Info

Schema Name: sfdl_prod_postgres.schemamanager_schema_names

created: 2021-08-20 12:13:40
disabled: False
format: raw
id: 948
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_postgres",
    "table": "schemamanager_schema_names"
}

type: postgres

Schema Versions: 15

Version 1718329

created: 2026-04-17 12:04:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-17/1776445229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-17/1776445229
id: 1718329
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 162187144
updated: 2026-04-17 12:04:48

Version 1717093

created: 2026-04-16 12:03:48

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-16/1776358830'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-16/1776358830
id: 1717093
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 162131277
updated: 2026-04-16 12:03:59

Version 1715899

created: 2026-04-15 12:04:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-15/1776272432'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-15/1776272432
id: 1715899
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 162075413
updated: 2026-04-15 12:04:29

Version 1714672

created: 2026-04-14 12:02:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-14/1776186032'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-14/1776186032
id: 1714672
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 162019354
updated: 2026-04-14 12:03:03

Version 1713478

created: 2026-04-13 12:02:56

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-13/1776099630'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-13/1776099630
id: 1713478
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161962792
updated: 2026-04-13 12:03:08

Version 1712290

created: 2026-04-12 12:03:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-12/1776013229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-12/1776013229
id: 1712290
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161910450
updated: 2026-04-12 12:03:20

Version 1711079

created: 2026-04-11 12:03:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-11/1775926829'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-11/1775926829
id: 1711079
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161860149
updated: 2026-04-11 12:03:48

Version 1709890

created: 2026-04-10 12:03:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-10/1775840428'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-10/1775840428
id: 1709890
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161806163
updated: 2026-04-10 12:03:25

Version 1708745

created: 2026-04-09 12:03:32

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-09/1775754028'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-09/1775754028
id: 1708745
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161750062
updated: 2026-04-09 12:03:46

Version 1707592

created: 2026-04-08 12:03:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-08/1775667627'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-08/1775667627
id: 1707592
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161694724
updated: 2026-04-08 12:03:54

Version 1706372

created: 2026-04-07 12:02:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-07/1775581227'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-07/1775581227
id: 1706372
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161639066
updated: 2026-04-07 12:03:01

Version 1705159

created: 2026-04-06 12:02:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-06/1775494827'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-06/1775494827
id: 1705159
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161581738
updated: 2026-04-06 12:02:53

Version 1703945

created: 2026-04-05 12:04:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-05/1775408428'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-05/1775408428
id: 1703945
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161530636
updated: 2026-04-05 12:04:27

Version 1702773

created: 2026-04-04 12:02:22

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-04/1775322026'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-04/1775322026
id: 1702773
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161480243
updated: 2026-04-04 12:02:36

Version 1701588

created: 2026-04-03 12:02:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.schemamanager_schema_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-03/1775235629'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
]

hive_path: s3://sfdl-postgres-schemamanager-prod/raw/schema_names/2026-04-03/1775235629
id: 1701588
processed: 1

raw_data:

{
    "created": 3,
    "disabled": 4,
    "file_properties": 6,
    "format": 5,
    "id": 0,
    "is_partitioned": 7,
    "is_schema_datatyped": 8,
    "name": 1,
    "type": 2
}

schema_attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

schema_name_id: 948
schema_scan_id: 161423386
updated: 2026-04-03 12:02:31

Schema Scans: 15

Last at 2026-04-17 12:04:34

Scan 162187144

duration: 0:00:14.538299

exit_message:

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

id: 162187144

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-17/1776445229",
        "key": "raw/schema_names/2026-04-17/1776445229/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15556413081199578304,
        "service_name": "schema_manager",
        "span_id": 5131131333269214590,
        "trace_id": 15556413081199578304
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-17 12:04:34
success: True
trace_id: 15556413081199578304

Scan 162131277

duration: 0:00:11.759362

exit_message:

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

id: 162131277

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-16/1776358830",
        "key": "raw/schema_names/2026-04-16/1776358830/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1482520114172259195,
        "service_name": "schema_manager",
        "span_id": 11665727852861141615,
        "trace_id": 1482520114172259195
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-16 12:03:48
success: True
trace_id: 1482520114172259195

Scan 162075413

duration: 0:00:14.458719

exit_message:

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

id: 162075413

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-15/1776272432",
        "key": "raw/schema_names/2026-04-15/1776272432/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5035394893839469358,
        "service_name": "schema_manager",
        "span_id": 1271130152622904202,
        "trace_id": 5035394893839469358
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-15 12:04:15
success: True
trace_id: 5035394893839469358

Scan 162019354

duration: 0:00:11.809822

exit_message:

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

id: 162019354

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-14/1776186032",
        "key": "raw/schema_names/2026-04-14/1776186032/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5414843390687324345,
        "service_name": "schema_manager",
        "span_id": 13807973251809770975,
        "trace_id": 5414843390687324345
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-14 12:02:51
success: True
trace_id: 5414843390687324345

Scan 161962792

duration: 0:00:11.782573

exit_message:

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

id: 161962792

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-13/1776099630",
        "key": "raw/schema_names/2026-04-13/1776099630/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17183682368946226847,
        "service_name": "schema_manager",
        "span_id": 2921286791834116491,
        "trace_id": 17183682368946226847
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-13 12:02:56
success: True
trace_id: 17183682368946226847

Scan 161910450

duration: 0:00:11.927105

exit_message:

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

id: 161910450

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-12/1776013229",
        "key": "raw/schema_names/2026-04-12/1776013229/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2324236869468848400,
        "service_name": "schema_manager",
        "span_id": 9761831433757854173,
        "trace_id": 2324236869468848400
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-12 12:03:08
success: True
trace_id: 2324236869468848400

Scan 161860149

duration: 0:00:14.338221

exit_message:

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

id: 161860149

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-11/1775926829",
        "key": "raw/schema_names/2026-04-11/1775926829/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9750847849550516364,
        "service_name": "schema_manager",
        "span_id": 14700603223085876406,
        "trace_id": 9750847849550516364
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-11 12:03:34
success: True
trace_id: 9750847849550516364

Scan 161806163

duration: 0:00:14.353624

exit_message:

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

id: 161806163

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-10/1775840428",
        "key": "raw/schema_names/2026-04-10/1775840428/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8354194264587083969,
        "service_name": "schema_manager",
        "span_id": 2646792705448557345,
        "trace_id": 8354194264587083969
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-10 12:03:11
success: True
trace_id: 8354194264587083969

Scan 161750062

duration: 0:00:14.380963

exit_message:

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

id: 161750062

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-09/1775754028",
        "key": "raw/schema_names/2026-04-09/1775754028/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8582711301771355423,
        "service_name": "schema_manager",
        "span_id": 3166463496382960389,
        "trace_id": 8582711301771355423
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-09 12:03:31
success: True
trace_id: 8582711301771355423

Scan 161694724

duration: 0:00:14.490382

exit_message:

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

id: 161694724

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-08/1775667627",
        "key": "raw/schema_names/2026-04-08/1775667627/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15090176889659531243,
        "service_name": "schema_manager",
        "span_id": 14734423296495372686,
        "trace_id": 15090176889659531243
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-08 12:03:40
success: True
trace_id: 15090176889659531243

Scan 161639066

duration: 0:00:22.256271

exit_message:

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

id: 161639066

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-07/1775581227",
        "key": "raw/schema_names/2026-04-07/1775581227/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15046325192915134449,
        "service_name": "schema_manager",
        "span_id": 11258017911334680521,
        "trace_id": 15046325192915134449
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-07 12:02:39
success: True
trace_id: 15046325192915134449

Scan 161581738

duration: 0:00:14.563218

exit_message:

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

id: 161581738

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-06/1775494827",
        "key": "raw/schema_names/2026-04-06/1775494827/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2558904946650676329,
        "service_name": "schema_manager",
        "span_id": 4225244129103190843,
        "trace_id": 2558904946650676329
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-06 12:02:39
success: True
trace_id: 2558904946650676329

Scan 161530636

duration: 0:00:14.348698

exit_message:

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

id: 161530636

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-05/1775408428",
        "key": "raw/schema_names/2026-04-05/1775408428/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15930316449697536495,
        "service_name": "schema_manager",
        "span_id": 7934322605097279717,
        "trace_id": 15930316449697536495
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-05 12:04:13
success: True
trace_id: 15930316449697536495

Scan 161480243

duration: 0:00:14.394368

exit_message:

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

id: 161480243

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-04/1775322026",
        "key": "raw/schema_names/2026-04-04/1775322026/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5634669874783249286,
        "service_name": "schema_manager",
        "span_id": 6481844152184405950,
        "trace_id": 5634669874783249286
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-04 12:02:22
success: True
trace_id: 5634669874783249286

Scan 161423386

duration: 0:00:14.349775

exit_message:

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

id: 161423386

payload:

{
    "datatype_dict": {
        "created": "timestamp",
        "disabled": "string",
        "file_properties": "string",
        "format": "string",
        "id": "int",
        "is_partitioned": "string",
        "is_schema_datatyped": "string",
        "name": "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_names/2026-04-03/1775235629",
        "key": "raw/schema_names/2026-04-03/1775235629/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.schemamanager_schema_names",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15317818200017795383,
        "service_name": "schema_manager",
        "span_id": 6645580739967224535,
        "trace_id": 15317818200017795383
    }
}

running: False
schema_name_id: 948
start_time: 2026-04-03 12:02:17
success: True
trace_id: 15317818200017795383

Partitions:

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

Schema:

attributes:

{
    "created": "timestamp",
    "disabled": "string",
    "file_properties": "string",
    "format": "string",
    "id": "int",
    "is_partitioned": "string",
    "is_schema_datatyped": "string",
    "name": "string",
    "type": "string"
}

created: 2026-04-17 12:04:34

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_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-17/1776445229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
}

Server:

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

Raw:

{
    "name": {
        "created": "2021-08-20 12:13:40",
        "disabled": false,
        "format": "raw",
        "id": 948,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "schemamanager_schema_names"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "created": "timestamp",
            "disabled": "string",
            "file_properties": "string",
            "format": "string",
            "id": "int",
            "is_partitioned": "string",
            "is_schema_datatyped": "string",
            "name": "string",
            "type": "string"
        },
        "created": "2026-04-17 12:04:34",
        "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_names`\n(\n `id`  int , `name`  string , `type`  string , `created`  timestamp , `disabled`  string , `format`  string , `file_properties`  string , `is_partitioned`  string , `is_schema_datatyped`  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_names/2026-04-17/1776445229'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.schemamanager_schema_names`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.schemamanager_schema_names"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}