Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_unit_lookup_fact

created: 2019-02-12 04:46:08
disabled: False
format: raw
id: 624
is_partitioned: False
is_schema_datatyped: True

name:

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

type: postgres

Schema Versions: 15

Version 1717497

created: 2026-04-17 00:55:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-17/1776405301'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-17/1776405301
id: 1717497
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 162163968
updated: 2026-04-17 00:55:22

Version 1716269

created: 2026-04-16 01:04:29

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-16/1776319455'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-16/1776319455
id: 1716269
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 162109248
updated: 2026-04-16 01:04:40

Version 1715082

created: 2026-04-15 01:08:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-15/1776233281'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-15/1776233281
id: 1715082
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 162053409
updated: 2026-04-15 01:08:25

Version 1713879

created: 2026-04-14 01:02:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-14/1776146474'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-14/1776146474
id: 1713879
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161997575
updated: 2026-04-14 01:02:27

Version 1712646

created: 2026-04-13 01:04:06

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-13/1776060236'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-13/1776060236
id: 1712646
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161940039
updated: 2026-04-13 01:04:19

Version 1711435

created: 2026-04-12 00:59:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-12/1775973509'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-12/1775973509
id: 1711435
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161889960
updated: 2026-04-12 00:59:57

Version 1710259

created: 2026-04-11 01:04:20

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-11/1775887454'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-11/1775887454
id: 1710259
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161838651
updated: 2026-04-11 01:04:31

Version 1709096

created: 2026-04-10 01:02:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-10/1775800887'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-10/1775800887
id: 1709096
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161783007
updated: 2026-04-10 01:02:22

Version 1707949

created: 2026-04-09 00:54:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-09/1775714072'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-09/1775714072
id: 1707949
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161726742
updated: 2026-04-09 00:54:52

Version 1706746

created: 2026-04-08 01:08:34

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-08/1775628505'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-08/1775628505
id: 1706746
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161672794
updated: 2026-04-08 01:08:48

Version 1705557

created: 2026-04-07 01:02:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-07/1775541755'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-07/1775541755
id: 1705557
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161616662
updated: 2026-04-07 01:02:51

Version 1704330

created: 2026-04-06 01:03:09

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-06/1775455301'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-06/1775455301
id: 1704330
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161558726
updated: 2026-04-06 01:03:23

Version 1703142

created: 2026-04-05 00:53:45

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-05/1775368412'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-05/1775368412
id: 1703142
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161511118
updated: 2026-04-05 00:53:57

Version 1701966

created: 2026-04-04 00:51:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-04/1775281881'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-04/1775281881
id: 1701966
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161455883
updated: 2026-04-04 00:51:37

Version 1700755

created: 2026-04-03 01:01:36

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-03/1775195942'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-03/1775195942
id: 1700755
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "facility_dim_id": 2,
    "received_epoch": 4,
    "unit_dim_id": 1,
    "unit_lookup_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

schema_name_id: 624
schema_scan_id: 161398282
updated: 2026-04-03 01:01:47

Schema Scans: 15

Last at 2026-04-17 00:55:11

Scan 162163968

duration: 0:00:11.815568

exit_message:

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

id: 162163968

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-17/1776405301",
        "key": "raw/unit_lookup_fact/2026-04-17/1776405301/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 12078087114171703969,
        "service_name": "kepler-normies",
        "span_id": 13450046636864487667,
        "trace_id": 12078087114171703969
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-17 00:55:11
success: True
trace_id: 12078087114171703969

Scan 162109248

duration: 0:00:11.907622

exit_message:

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

id: 162109248

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-16/1776319455",
        "key": "raw/unit_lookup_fact/2026-04-16/1776319455/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2517307655272708515,
        "service_name": "kepler-normies",
        "span_id": 14625152714481214293,
        "trace_id": 2517307655272708515
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-16 01:04:28
success: True
trace_id: 2517307655272708515

Scan 162053409

duration: 0:00:14.338104

exit_message:

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

id: 162053409

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-15/1776233281",
        "key": "raw/unit_lookup_fact/2026-04-15/1776233281/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17576121294562601325,
        "service_name": "kepler-normies",
        "span_id": 6863655763066744242,
        "trace_id": 17576121294562601325
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-15 01:08:11
success: True
trace_id: 17576121294562601325

Scan 161997575

duration: 0:00:11.737028

exit_message:

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

id: 161997575

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-14/1776146474",
        "key": "raw/unit_lookup_fact/2026-04-14/1776146474/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8406562030015401023,
        "service_name": "kepler-normies",
        "span_id": 2047326142363261440,
        "trace_id": 8406562030015401023
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-14 01:02:16
success: True
trace_id: 8406562030015401023

Scan 161940039

duration: 0:00:14.501183

exit_message:

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

id: 161940039

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-13/1776060236",
        "key": "raw/unit_lookup_fact/2026-04-13/1776060236/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2591293523657039588,
        "service_name": "kepler-normies",
        "span_id": 8151668541119609041,
        "trace_id": 2591293523657039588
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-13 01:04:05
success: True
trace_id: 2591293523657039588

Scan 161889960

duration: 0:00:14.331124

exit_message:

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

id: 161889960

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-12/1775973509",
        "key": "raw/unit_lookup_fact/2026-04-12/1775973509/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 10631824336701699780,
        "service_name": "kepler-normies",
        "span_id": 16694384936775465851,
        "trace_id": 10631824336701699780
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-12 00:59:43
success: True
trace_id: 10631824336701699780

Scan 161838651

duration: 0:00:11.704971

exit_message:

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

id: 161838651

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-11/1775887454",
        "key": "raw/unit_lookup_fact/2026-04-11/1775887454/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 7560599174844536117,
        "service_name": "kepler-normies",
        "span_id": 7273713979383485431,
        "trace_id": 7560599174844536117
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-11 01:04:19
success: True
trace_id: 7560599174844536117

Scan 161783007

duration: 0:00:11.883771

exit_message:

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

id: 161783007

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-10/1775800887",
        "key": "raw/unit_lookup_fact/2026-04-10/1775800887/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3666996301168491319,
        "service_name": "kepler-normies",
        "span_id": 12728855240229503882,
        "trace_id": 3666996301168491319
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-10 01:02:10
success: True
trace_id: 3666996301168491319

Scan 161726742

duration: 0:00:11.940959

exit_message:

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

id: 161726742

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-09/1775714072",
        "key": "raw/unit_lookup_fact/2026-04-09/1775714072/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 272625308331759356,
        "service_name": "kepler-normies",
        "span_id": 17819088413872081322,
        "trace_id": 272625308331759356
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-09 00:54:40
success: True
trace_id: 272625308331759356

Scan 161672794

duration: 0:00:14.315009

exit_message:

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

id: 161672794

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-08/1775628505",
        "key": "raw/unit_lookup_fact/2026-04-08/1775628505/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1102202231304884599,
        "service_name": "kepler-normies",
        "span_id": 11294524248154530845,
        "trace_id": 1102202231304884599
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-08 01:08:33
success: True
trace_id: 1102202231304884599

Scan 161616662

duration: 0:00:11.798438

exit_message:

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

id: 161616662

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-07/1775541755",
        "key": "raw/unit_lookup_fact/2026-04-07/1775541755/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8935259033558678359,
        "service_name": "kepler-normies",
        "span_id": 15071690282641338782,
        "trace_id": 8935259033558678359
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-07 01:02:39
success: True
trace_id: 8935259033558678359

Scan 161558726

duration: 0:00:14.392366

exit_message:

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

id: 161558726

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-06/1775455301",
        "key": "raw/unit_lookup_fact/2026-04-06/1775455301/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9634597164236731593,
        "service_name": "kepler-normies",
        "span_id": 3393333721484357925,
        "trace_id": 9634597164236731593
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-06 01:03:08
success: True
trace_id: 9634597164236731593

Scan 161511118

duration: 0:00:11.716503

exit_message:

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

id: 161511118

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-05/1775368412",
        "key": "raw/unit_lookup_fact/2026-04-05/1775368412/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 12767793476945782024,
        "service_name": "kepler-normies",
        "span_id": 8569681587613050168,
        "trace_id": 12767793476945782024
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-05 00:53:45
success: True
trace_id: 12767793476945782024

Scan 161455883

duration: 0:00:11.760232

exit_message:

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

id: 161455883

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-04/1775281881",
        "key": "raw/unit_lookup_fact/2026-04-04/1775281881/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5335766018353205017,
        "service_name": "kepler-normies",
        "span_id": 12880249368066186602,
        "trace_id": 5335766018353205017
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-04 00:51:25
success: True
trace_id: 5335766018353205017

Scan 161398282

duration: 0:00:11.709807

exit_message:

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

id: 161398282

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "facility_dim_id": "int",
        "received_epoch": "bigint",
        "unit_dim_id": "int",
        "unit_lookup_fact_id": "int"
    },
    "file_format": "dat",
    "file_properties": {
        "data_has_header_row": true,
        "serde_properties": {
            "separatorChar": "\u0001"
        }
    },
    "is_schema_datatyped": true,
    "s3": {
        "bucket": "sfdl-postgres-keplernormies-prod",
        "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_lookup_fact/2026-04-03/1775195942",
        "key": "raw/unit_lookup_fact/2026-04-03/1775195942/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_unit_lookup_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 11019373401372050415,
        "service_name": "kepler-normies",
        "span_id": 11717589222231586763,
        "trace_id": 11019373401372050415
    }
}

running: False
schema_name_id: 624
start_time: 2026-04-03 01:01:36
success: True
trace_id: 11019373401372050415

Partitions:

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

Schema:

attributes:

{
    "company_dim_id": "int",
    "facility_dim_id": "int",
    "received_epoch": "bigint",
    "unit_dim_id": "int",
    "unit_lookup_fact_id": "int"
}

created: 2026-04-17 00:55:11

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-17/1776405301'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-02-12 04:46:08",
        "disabled": false,
        "format": "raw",
        "id": 624,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_unit_lookup_fact"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "company_dim_id": "int",
            "facility_dim_id": "int",
            "received_epoch": "bigint",
            "unit_dim_id": "int",
            "unit_lookup_fact_id": "int"
        },
        "created": "2026-04-17 00:55:11",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_lookup_fact`\n(\n `unit_lookup_fact_id`  int , `unit_dim_id`  int , `facility_dim_id`  int , `company_dim_id`  int , `received_epoch`  bigint \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-keplernormies-prod/raw/unit_lookup_fact/2026-04-17/1776405301'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_lookup_fact`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_lookup_fact"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}