Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_facility_daily_fact

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

name:

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

type: postgres

Schema Versions: 15

Version 1717508

created: 2026-04-17 00:56:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-17/1776405334'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-17/1776405334
id: 1717508
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 162164032
updated: 2026-04-17 00:56:16

Version 1716274

created: 2026-04-16 01:05:01

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-16/1776319489'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-16/1776319489
id: 1716274
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 162109256
updated: 2026-04-16 01:05:12

Version 1715071

created: 2026-04-15 01:06:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-15/1776233198'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-15/1776233198
id: 1715071
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 162053388
updated: 2026-04-15 01:07:04

Version 1713883

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-14/1776146534'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-14/1776146534
id: 1713883
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161997589
updated: 2026-04-14 01:02:47

Version 1712651

created: 2026-04-13 01:04:28

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-13/1776060256'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-13/1776060256
id: 1712651
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161940049
updated: 2026-04-13 01:04:41

Version 1711444

created: 2026-04-12 01:01:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-12/1775973594'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-12/1775973594
id: 1711444
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161890286
updated: 2026-04-12 01:02:02

Version 1710255

created: 2026-04-11 01:04:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-11/1775887429'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-11/1775887429
id: 1710255
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161838646
updated: 2026-04-11 01:04:17

Version 1709098

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-10/1775800923'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-10/1775800923
id: 1709098
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161783017
updated: 2026-04-10 01:02:32

Version 1707958

created: 2026-04-09 00:55:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-09/1775714107'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-09/1775714107
id: 1707958
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161726811
updated: 2026-04-09 00:55:38

Version 1706758

created: 2026-04-08 01:09:52

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-08/1775628574'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-08/1775628574
id: 1706758
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161672806
updated: 2026-04-08 01:10:06

Version 1705573

created: 2026-04-07 01:04:10

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-07/1775541833'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-07/1775541833
id: 1705573
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161616703
updated: 2026-04-07 01:04:24

Version 1704332

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-06/1775455381'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-06/1775455381
id: 1704332
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161558745
updated: 2026-04-06 01:03:30

Version 1703150

created: 2026-04-05 00:54:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-05/1775368465'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-05/1775368465
id: 1703150
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161511145
updated: 2026-04-05 00:55:03

Version 1701962

created: 2026-04-04 00:51:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-04/1775281858'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-04/1775281858
id: 1701962
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161455879
updated: 2026-04-04 00:51:28

Version 1700771

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-03/1775195991'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_daily_fact/2026-04-03/1775195991
id: 1700771
processed: 1

raw_data:

{
    "company_dim_id": 3,
    "date_dim_id": 5,
    "delinquent_balance": 10,
    "delinquent_count": 9,
    "delinquent_days_total": 11,
    "facility_daily_fact_id": 0,
    "facility_dim_id": 4,
    "insured_count": 1,
    "occupied_count": 2,
    "past_due_balance": 7,
    "past_due_count": 6,
    "past_due_days_total": 8,
    "prepaid_balance": 13,
    "prepaid_count": 12,
    "prepaid_days_total": 14,
    "unit_count": 15
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

schema_name_id: 628
schema_scan_id: 161398598
updated: 2026-04-03 01:04:23

Schema Scans: 15

Last at 2026-04-17 00:56:04

Scan 162164032

duration: 0:00:12.106982

exit_message:

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

id: 162164032

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-17/1776405334",
        "key": "raw/facility_daily_fact/2026-04-17/1776405334/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15844803948474046348,
        "service_name": "kepler-normies",
        "span_id": 12083542847103784326,
        "trace_id": 15844803948474046348
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-17 00:56:04
success: True
trace_id: 15844803948474046348

Scan 162109256

duration: 0:00:12.059084

exit_message:

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

id: 162109256

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-16/1776319489",
        "key": "raw/facility_daily_fact/2026-04-16/1776319489/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 14556643698808238598,
        "service_name": "kepler-normies",
        "span_id": 14699803155456520960,
        "trace_id": 14556643698808238598
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-16 01:05:00
success: True
trace_id: 14556643698808238598

Scan 162053388

duration: 0:00:14.605137

exit_message:

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

id: 162053388

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-15/1776233198",
        "key": "raw/facility_daily_fact/2026-04-15/1776233198/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 11223785981698296202,
        "service_name": "kepler-normies",
        "span_id": 13596525128166845766,
        "trace_id": 11223785981698296202
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-15 01:06:50
success: True
trace_id: 11223785981698296202

Scan 161997589

duration: 0:00:12.113079

exit_message:

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

id: 161997589

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-14/1776146534",
        "key": "raw/facility_daily_fact/2026-04-14/1776146534/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2395516610975940247,
        "service_name": "kepler-normies",
        "span_id": 2300211734067583458,
        "trace_id": 2395516610975940247
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-14 01:02:34
success: True
trace_id: 2395516610975940247

Scan 161940049

duration: 0:00:14.476531

exit_message:

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

id: 161940049

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-13/1776060256",
        "key": "raw/facility_daily_fact/2026-04-13/1776060256/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9046315719904966223,
        "service_name": "kepler-normies",
        "span_id": 15875885763452191981,
        "trace_id": 9046315719904966223
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-13 01:04:27
success: True
trace_id: 9046315719904966223

Scan 161890286

duration: 0:00:12.057270

exit_message:

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

id: 161890286

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-12/1775973594",
        "key": "raw/facility_daily_fact/2026-04-12/1775973594/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3795886912524137934,
        "service_name": "kepler-normies",
        "span_id": 94334925376440298,
        "trace_id": 3795886912524137934
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-12 01:01:50
success: True
trace_id: 3795886912524137934

Scan 161838646

duration: 0:00:14.754677

exit_message:

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

id: 161838646

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-11/1775887429",
        "key": "raw/facility_daily_fact/2026-04-11/1775887429/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 14211784766594333621,
        "service_name": "kepler-normies",
        "span_id": 18313945064922017312,
        "trace_id": 14211784766594333621
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-11 01:04:02
success: True
trace_id: 14211784766594333621

Scan 161783017

duration: 0:00:14.669436

exit_message:

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

id: 161783017

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-10/1775800923",
        "key": "raw/facility_daily_fact/2026-04-10/1775800923/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8717140891918186656,
        "service_name": "kepler-normies",
        "span_id": 2200121319916432827,
        "trace_id": 8717140891918186656
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-10 01:02:17
success: True
trace_id: 8717140891918186656

Scan 161726811

duration: 0:00:12.159310

exit_message:

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

id: 161726811

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-09/1775714107",
        "key": "raw/facility_daily_fact/2026-04-09/1775714107/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 7966779007038000299,
        "service_name": "kepler-normies",
        "span_id": 15569490757799549280,
        "trace_id": 7966779007038000299
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-09 00:55:26
success: True
trace_id: 7966779007038000299

Scan 161672806

duration: 0:00:14.901788

exit_message:

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

id: 161672806

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-08/1775628574",
        "key": "raw/facility_daily_fact/2026-04-08/1775628574/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 6062823550174405177,
        "service_name": "kepler-normies",
        "span_id": 10487785349095348634,
        "trace_id": 6062823550174405177
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-08 01:09:51
success: True
trace_id: 6062823550174405177

Scan 161616703

duration: 0:00:14.632319

exit_message:

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

id: 161616703

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-07/1775541833",
        "key": "raw/facility_daily_fact/2026-04-07/1775541833/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15485056949857768839,
        "service_name": "kepler-normies",
        "span_id": 12906209102057821693,
        "trace_id": 15485056949857768839
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-07 01:04:09
success: True
trace_id: 15485056949857768839

Scan 161558745

duration: 0:00:12.000846

exit_message:

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

id: 161558745

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-06/1775455381",
        "key": "raw/facility_daily_fact/2026-04-06/1775455381/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8081517070288111985,
        "service_name": "kepler-normies",
        "span_id": 17568430470735782926,
        "trace_id": 8081517070288111985
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-06 01:03:18
success: True
trace_id: 8081517070288111985

Scan 161511145

duration: 0:00:14.571273

exit_message:

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

id: 161511145

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-05/1775368465",
        "key": "raw/facility_daily_fact/2026-04-05/1775368465/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5520027176690390246,
        "service_name": "kepler-normies",
        "span_id": 3364036513221648264,
        "trace_id": 5520027176690390246
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-05 00:54:49
success: True
trace_id: 5520027176690390246

Scan 161455879

duration: 0:00:14.685822

exit_message:

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

id: 161455879

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-04/1775281858",
        "key": "raw/facility_daily_fact/2026-04-04/1775281858/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8343990536050635057,
        "service_name": "kepler-normies",
        "span_id": 11452888148680742664,
        "trace_id": 8343990536050635057
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-04 00:51:13
success: True
trace_id: 8343990536050635057

Scan 161398598

duration: 0:00:14.631541

exit_message:

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

id: 161398598

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "delinquent_balance": "decimal",
        "delinquent_count": "int",
        "delinquent_days_total": "bigint",
        "facility_daily_fact_id": "bigint",
        "facility_dim_id": "int",
        "insured_count": "int",
        "occupied_count": "int",
        "past_due_balance": "decimal",
        "past_due_count": "int",
        "past_due_days_total": "bigint",
        "prepaid_balance": "decimal",
        "prepaid_count": "int",
        "prepaid_days_total": "bigint",
        "unit_count": "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/facility_daily_fact/2026-04-03/1775195991",
        "key": "raw/facility_daily_fact/2026-04-03/1775195991/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_daily_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17161971734843516909,
        "service_name": "kepler-normies",
        "span_id": 15187686476449233985,
        "trace_id": 17161971734843516909
    }
}

running: False
schema_name_id: 628
start_time: 2026-04-03 01:04:08
success: True
trace_id: 17161971734843516909

Partitions:

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

Schema:

attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "delinquent_balance": "decimal",
    "delinquent_count": "int",
    "delinquent_days_total": "bigint",
    "facility_daily_fact_id": "bigint",
    "facility_dim_id": "int",
    "insured_count": "int",
    "occupied_count": "int",
    "past_due_balance": "decimal",
    "past_due_count": "int",
    "past_due_days_total": "bigint",
    "prepaid_balance": "decimal",
    "prepaid_count": "int",
    "prepaid_days_total": "bigint",
    "unit_count": "int"
}

created: 2026-04-17 00:56:04

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-17/1776405334'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_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:46",
        "disabled": false,
        "format": "raw",
        "id": 628,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_facility_daily_fact"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "company_dim_id": "int",
            "date_dim_id": "int",
            "delinquent_balance": "decimal",
            "delinquent_count": "int",
            "delinquent_days_total": "bigint",
            "facility_daily_fact_id": "bigint",
            "facility_dim_id": "int",
            "insured_count": "int",
            "occupied_count": "int",
            "past_due_balance": "decimal",
            "past_due_count": "int",
            "past_due_days_total": "bigint",
            "prepaid_balance": "decimal",
            "prepaid_count": "int",
            "prepaid_days_total": "bigint",
            "unit_count": "int"
        },
        "created": "2026-04-17 00:56:04",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_daily_fact`\n(\n `facility_daily_fact_id`  bigint , `insured_count`  int , `occupied_count`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `past_due_count`  int , `past_due_balance`  decimal , `past_due_days_total`  bigint , `delinquent_count`  int , `delinquent_balance`  decimal , `delinquent_days_total`  bigint , `prepaid_count`  int , `prepaid_balance`  decimal , `prepaid_days_total`  bigint , `unit_count`  int \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/facility_daily_fact/2026-04-17/1776405334'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_daily_fact`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_daily_fact"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}