Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned

created: 2024-08-01 15:36:00
disabled: False
format: raw
id: 1978
is_partitioned: False
is_schema_datatyped: True

name:

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

type: postgres

Schema Versions: 15

Version 1717514

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-17/1776405384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-17/1776405384
id: 1717514
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 162164120
updated: 2026-04-17 00:57:09

Version 1716263

created: 2026-04-16 01:04:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-16/1776319442'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-16/1776319442
id: 1716263
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 162109242
updated: 2026-04-16 01:04:21

Version 1715072

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-15/1776233207'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-15/1776233207
id: 1715072
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 162053389
updated: 2026-04-15 01:07:03

Version 1713877

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-14/1776146473'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-14/1776146473
id: 1713877
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161997571
updated: 2026-04-14 01:02:22

Version 1712639

created: 2026-04-13 01:03:43

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-13/1776060213'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-13/1776060213
id: 1712639
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161940028
updated: 2026-04-13 01:03:55

Version 1711436

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-12/1775973503'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-12/1775973503
id: 1711436
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161889985
updated: 2026-04-12 01:00:06

Version 1710246

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-11/1775887385'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-11/1775887385
id: 1710246
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161838637
updated: 2026-04-11 01:03:21

Version 1709110

created: 2026-04-10 01:03:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-10/1775800871'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-10/1775800871
id: 1709110
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161783092
updated: 2026-04-10 01:03:28

Version 1707950

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-09/1775714055'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-09/1775714055
id: 1707950
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161726744
updated: 2026-04-09 00:54:55

Version 1706756

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-08/1775628578'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-08/1775628578
id: 1706756
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161672804
updated: 2026-04-08 01:09:55

Version 1705571

created: 2026-04-07 01:03:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-07/1775541826'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-07/1775541826
id: 1705571
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161616701
updated: 2026-04-07 01:04:07

Version 1704333

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-06/1775455365'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-06/1775455365
id: 1704333
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161558756
updated: 2026-04-06 01:03:36

Version 1703139

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-05/1775368403'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-05/1775368403
id: 1703139
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161511109
updated: 2026-04-05 00:53:42

Version 1701961

created: 2026-04-04 00:51:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-04/1775281863'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-04/1775281863
id: 1701961
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161455878
updated: 2026-04-04 00:51:24

Version 1700757

created: 2026-04-03 01:02:13

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-03/1775195926'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/private_insurance_fact_cleaned/2026-04-03/1775195926
id: 1700757
processed: 1

raw_data:

{
    "company_dim_id": 4,
    "date_dim_id": 3,
    "effective_on_date_dim_id": 8,
    "end_date": 11,
    "facility_dim_id": 5,
    "private_insurance_fact_id": 0,
    "provider": 1,
    "provider_id": 2,
    "received_epoch": 9,
    "start_date": 10,
    "tenant_dim_id": 6,
    "unit_dim_id": 7
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

schema_name_id: 1978
schema_scan_id: 161398385
updated: 2026-04-03 01:02:27

Schema Scans: 15

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

Scan 162164120

duration: 0:00:14.512588

exit_message:

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

id: 162164120

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-17/1776405384",
        "key": "raw/private_insurance_fact_cleaned/2026-04-17/1776405384/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1478216911234421146,
        "service_name": "kepler-normies",
        "span_id": 12044041897756640102,
        "trace_id": 1478216911234421146
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-17 00:56:54
success: True
trace_id: 1478216911234421146

Scan 162109242

duration: 0:00:14.610015

exit_message:

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

id: 162109242

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-16/1776319442",
        "key": "raw/private_insurance_fact_cleaned/2026-04-16/1776319442/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15407469389480828219,
        "service_name": "kepler-normies",
        "span_id": 14599257213507423351,
        "trace_id": 15407469389480828219
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-16 01:04:07
success: True
trace_id: 15407469389480828219

Scan 162053389

duration: 0:00:11.940749

exit_message:

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

id: 162053389

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-15/1776233207",
        "key": "raw/private_insurance_fact_cleaned/2026-04-15/1776233207/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2796268328494032067,
        "service_name": "kepler-normies",
        "span_id": 8428809166362751484,
        "trace_id": 2796268328494032067
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-15 01:06:52
success: True
trace_id: 2796268328494032067

Scan 161997571

duration: 0:00:14.486841

exit_message:

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

id: 161997571

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-14/1776146473",
        "key": "raw/private_insurance_fact_cleaned/2026-04-14/1776146473/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 10689230061694926174,
        "service_name": "kepler-normies",
        "span_id": 432176027321344884,
        "trace_id": 10689230061694926174
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-14 01:02:07
success: True
trace_id: 10689230061694926174

Scan 161940028

duration: 0:00:12.069325

exit_message:

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

id: 161940028

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-13/1776060213",
        "key": "raw/private_insurance_fact_cleaned/2026-04-13/1776060213/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 11537476213014010555,
        "service_name": "kepler-normies",
        "span_id": 10997119001510152326,
        "trace_id": 11537476213014010555
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-13 01:03:43
success: True
trace_id: 11537476213014010555

Scan 161889985

duration: 0:00:14.469748

exit_message:

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

id: 161889985

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-12/1775973503",
        "key": "raw/private_insurance_fact_cleaned/2026-04-12/1775973503/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 6731734879275434441,
        "service_name": "kepler-normies",
        "span_id": 10752301414940013846,
        "trace_id": 6731734879275434441
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-12 00:59:52
success: True
trace_id: 6731734879275434441

Scan 161838637

duration: 0:00:11.985076

exit_message:

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

id: 161838637

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-11/1775887385",
        "key": "raw/private_insurance_fact_cleaned/2026-04-11/1775887385/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 13784914423930799081,
        "service_name": "kepler-normies",
        "span_id": 11053866300115778097,
        "trace_id": 13784914423930799081
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-11 01:03:09
success: True
trace_id: 13784914423930799081

Scan 161783092

duration: 0:00:12.173321

exit_message:

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

id: 161783092

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-10/1775800871",
        "key": "raw/private_insurance_fact_cleaned/2026-04-10/1775800871/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 16600479291747242185,
        "service_name": "kepler-normies",
        "span_id": 4305807423780309905,
        "trace_id": 16600479291747242185
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-10 01:03:16
success: True
trace_id: 16600479291747242185

Scan 161726744

duration: 0:00:14.600696

exit_message:

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

id: 161726744

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-09/1775714055",
        "key": "raw/private_insurance_fact_cleaned/2026-04-09/1775714055/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1909514228068651951,
        "service_name": "kepler-normies",
        "span_id": 152538903973643590,
        "trace_id": 1909514228068651951
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-09 00:54:40
success: True
trace_id: 1909514228068651951

Scan 161672804

duration: 0:00:14.473000

exit_message:

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

id: 161672804

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-08/1775628578",
        "key": "raw/private_insurance_fact_cleaned/2026-04-08/1775628578/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 13142224687090213606,
        "service_name": "kepler-normies",
        "span_id": 10617819123358409350,
        "trace_id": 13142224687090213606
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-08 01:09:41
success: True
trace_id: 13142224687090213606

Scan 161616701

duration: 0:00:14.482802

exit_message:

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

id: 161616701

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-07/1775541826",
        "key": "raw/private_insurance_fact_cleaned/2026-04-07/1775541826/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 12125621575722009964,
        "service_name": "kepler-normies",
        "span_id": 12766935374707544657,
        "trace_id": 12125621575722009964
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-07 01:03:53
success: True
trace_id: 12125621575722009964

Scan 161558756

duration: 0:00:11.928179

exit_message:

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

id: 161558756

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-06/1775455365",
        "key": "raw/private_insurance_fact_cleaned/2026-04-06/1775455365/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 16386689257182587370,
        "service_name": "kepler-normies",
        "span_id": 1274690351370488427,
        "trace_id": 16386689257182587370
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-06 01:03:24
success: True
trace_id: 16386689257182587370

Scan 161511109

duration: 0:00:14.506902

exit_message:

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

id: 161511109

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-05/1775368403",
        "key": "raw/private_insurance_fact_cleaned/2026-04-05/1775368403/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 11615258525649560273,
        "service_name": "kepler-normies",
        "span_id": 8443232401763476829,
        "trace_id": 11615258525649560273
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-05 00:53:27
success: True
trace_id: 11615258525649560273

Scan 161455878

duration: 0:00:12.065134

exit_message:

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

id: 161455878

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-04/1775281863",
        "key": "raw/private_insurance_fact_cleaned/2026-04-04/1775281863/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 4104898304756184113,
        "service_name": "kepler-normies",
        "span_id": 4912924488364625135,
        "trace_id": 4104898304756184113
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-04 00:51:12
success: True
trace_id: 4104898304756184113

Scan 161398385

duration: 0:00:14.654341

exit_message:

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

id: 161398385

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "end_date": "date",
        "facility_dim_id": "int",
        "private_insurance_fact_id": "int",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date",
        "tenant_dim_id": "int",
        "unit_dim_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/private_insurance_fact_cleaned/2026-04-03/1775195926",
        "key": "raw/private_insurance_fact_cleaned/2026-04-03/1775195926/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 16063546992638031383,
        "service_name": "kepler-normies",
        "span_id": 16336501228409519774,
        "trace_id": 16063546992638031383
    }
}

running: False
schema_name_id: 1978
start_time: 2026-04-03 01:02:12
success: True
trace_id: 16063546992638031383

Partitions:

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

Schema:

attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "end_date": "date",
    "facility_dim_id": "int",
    "private_insurance_fact_id": "int",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date",
    "tenant_dim_id": "int",
    "unit_dim_id": "int"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-17/1776405384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
}

Server:

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

Raw:

{
    "name": {
        "created": "2024-08-01 15:36:00",
        "disabled": false,
        "format": "raw",
        "id": 1978,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_private_insurance_fact_cleaned"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "company_dim_id": "int",
            "date_dim_id": "int",
            "effective_on_date_dim_id": "int",
            "end_date": "date",
            "facility_dim_id": "int",
            "private_insurance_fact_id": "int",
            "provider": "string",
            "provider_id": "string",
            "received_epoch": "bigint",
            "start_date": "date",
            "tenant_dim_id": "int",
            "unit_dim_id": "int"
        },
        "created": "2026-04-17 00:56:55",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`\n(\n `private_insurance_fact_id`  int , `provider`  string , `provider_id`  string , `date_dim_id`  int , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `effective_on_date_dim_id`  int , `received_epoch`  bigint , `start_date`  date , `end_date`  date \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/private_insurance_fact_cleaned/2026-04-17/1776405384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_private_insurance_fact_cleaned"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}