Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_facility_group_fact

created: 2019-02-12 04:45:54
disabled: False
format: raw
id: 622
is_partitioned: False
is_schema_datatyped: True

name:

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

type: postgres

Schema Versions: 15

Version 1717513

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-17/1776405384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

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

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 162164114
updated: 2026-04-17 00:57:03

Version 1716279

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-16/1776319508'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-16/1776319508
id: 1716279
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 162109269
updated: 2026-04-16 01:05:41

Version 1715080

created: 2026-04-15 01:07:40

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-15/1776233255'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-15/1776233255
id: 1715080
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 162053402
updated: 2026-04-15 01:07:53

Version 1713876

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-14/1776146501'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-14/1776146501
id: 1713876
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161997569
updated: 2026-04-14 01:02:15

Version 1712650

created: 2026-04-13 01:04:27

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-13/1776060263'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-13/1776060263
id: 1712650
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161940048
updated: 2026-04-13 01:04:41

Version 1711442

created: 2026-04-12 01:01:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-12/1775973524'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-12/1775973524
id: 1711442
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161890247
updated: 2026-04-12 01:01:44

Version 1710257

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-11/1775887444'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-11/1775887444
id: 1710257
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161838648
updated: 2026-04-11 01:04:22

Version 1709097

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-10/1775800924'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-10/1775800924
id: 1709097
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161783010
updated: 2026-04-10 01:02:23

Version 1707955

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-09/1775714100'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-09/1775714100
id: 1707955
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161726776
updated: 2026-04-09 00:55:20

Version 1706753

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-08/1775628568'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-08/1775628568
id: 1706753
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161672802
updated: 2026-04-08 01:09:48

Version 1705567

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-07/1775541811'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-07/1775541811
id: 1705567
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161616698
updated: 2026-04-07 01:03:55

Version 1704328

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-06/1775455343'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-06/1775455343
id: 1704328
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161558691
updated: 2026-04-06 01:03:04

Version 1703146

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-05/1775368444'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-05/1775368444
id: 1703146
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161511129
updated: 2026-04-05 00:54:29

Version 1701975

created: 2026-04-04 00:52:23

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-04/1775281920'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-04/1775281920
id: 1701975
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161455905
updated: 2026-04-04 00:52:37

Version 1700768

created: 2026-04-03 01:03:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_facility_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-03/1775195976'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-03/1775195976
id: 1700768
processed: 1

raw_data:

{
    "company_dim_id": 7,
    "date_dim_id": 9,
    "deleted_on": 6,
    "end_date": 5,
    "facility_dim_id": 8,
    "facility_group_fact_id": 0,
    "facility_group_name": 3,
    "migrated_on": 10,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 11,
    "start_date": 4
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

schema_name_id: 622
schema_scan_id: 161398541
updated: 2026-04-03 01:03:51

Schema Scans: 15

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

Scan 162164114

duration: 0:00:11.957576

exit_message:

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

id: 162164114

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-17/1776405384",
        "key": "raw/facility_group_fact/2026-04-17/1776405384/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 16400742489758729194,
        "service_name": "kepler-normies",
        "span_id": 15216550384615069160,
        "trace_id": 16400742489758729194
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-17 00:56:51
success: True
trace_id: 16400742489758729194

Scan 162109269

duration: 0:00:14.682881

exit_message:

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

id: 162109269

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-16/1776319508",
        "key": "raw/facility_group_fact/2026-04-16/1776319508/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 16189828985894153386,
        "service_name": "kepler-normies",
        "span_id": 7083535688693255701,
        "trace_id": 16189828985894153386
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-16 01:05:26
success: True
trace_id: 16189828985894153386

Scan 162053402

duration: 0:00:14.481824

exit_message:

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

id: 162053402

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-15/1776233255",
        "key": "raw/facility_group_fact/2026-04-15/1776233255/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3337259858855336120,
        "service_name": "kepler-normies",
        "span_id": 5071357668294781027,
        "trace_id": 3337259858855336120
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-15 01:07:39
success: True
trace_id: 3337259858855336120

Scan 161997569

duration: 0:00:14.499859

exit_message:

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

id: 161997569

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-14/1776146501",
        "key": "raw/facility_group_fact/2026-04-14/1776146501/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 7434891472420639618,
        "service_name": "kepler-normies",
        "span_id": 10056097623965272732,
        "trace_id": 7434891472420639618
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-14 01:02:01
success: True
trace_id: 7434891472420639618

Scan 161940048

duration: 0:00:14.448590

exit_message:

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

id: 161940048

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-13/1776060263",
        "key": "raw/facility_group_fact/2026-04-13/1776060263/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 4987790206180606153,
        "service_name": "kepler-normies",
        "span_id": 13740177897380912995,
        "trace_id": 4987790206180606153
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-13 01:04:27
success: True
trace_id: 4987790206180606153

Scan 161890247

duration: 0:00:12.064934

exit_message:

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

id: 161890247

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-12/1775973524",
        "key": "raw/facility_group_fact/2026-04-12/1775973524/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 10282652135107172837,
        "service_name": "kepler-normies",
        "span_id": 2999796089761721816,
        "trace_id": 10282652135107172837
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-12 01:01:32
success: True
trace_id: 10282652135107172837

Scan 161838648

duration: 0:00:14.392696

exit_message:

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

id: 161838648

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-11/1775887444",
        "key": "raw/facility_group_fact/2026-04-11/1775887444/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9776566015610190438,
        "service_name": "kepler-normies",
        "span_id": 10244360978426623246,
        "trace_id": 9776566015610190438
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-11 01:04:07
success: True
trace_id: 9776566015610190438

Scan 161783010

duration: 0:00:12.001766

exit_message:

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

id: 161783010

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-10/1775800924",
        "key": "raw/facility_group_fact/2026-04-10/1775800924/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17445332402086247643,
        "service_name": "kepler-normies",
        "span_id": 5236523285395970159,
        "trace_id": 17445332402086247643
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-10 01:02:12
success: True
trace_id: 17445332402086247643

Scan 161726776

duration: 0:00:14.421358

exit_message:

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

id: 161726776

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-09/1775714100",
        "key": "raw/facility_group_fact/2026-04-09/1775714100/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1248743848982009773,
        "service_name": "kepler-normies",
        "span_id": 17052656055868136783,
        "trace_id": 1248743848982009773
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-09 00:55:06
success: True
trace_id: 1248743848982009773

Scan 161672802

duration: 0:00:11.995309

exit_message:

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

id: 161672802

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-08/1775628568",
        "key": "raw/facility_group_fact/2026-04-08/1775628568/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 646531305343898175,
        "service_name": "kepler-normies",
        "span_id": 10739792509069370533,
        "trace_id": 646531305343898175
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-08 01:09:36
success: True
trace_id: 646531305343898175

Scan 161616698

duration: 0:00:14.432368

exit_message:

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

id: 161616698

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-07/1775541811",
        "key": "raw/facility_group_fact/2026-04-07/1775541811/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3456717383302285977,
        "service_name": "kepler-normies",
        "span_id": 15984518298538934252,
        "trace_id": 3456717383302285977
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-07 01:03:41
success: True
trace_id: 3456717383302285977

Scan 161558691

duration: 0:00:14.447896

exit_message:

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

id: 161558691

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-06/1775455343",
        "key": "raw/facility_group_fact/2026-04-06/1775455343/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 16844263799465809173,
        "service_name": "kepler-normies",
        "span_id": 16646422061848268424,
        "trace_id": 16844263799465809173
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-06 01:02:50
success: True
trace_id: 16844263799465809173

Scan 161511129

duration: 0:00:12.006221

exit_message:

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

id: 161511129

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-05/1775368444",
        "key": "raw/facility_group_fact/2026-04-05/1775368444/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 7160327726948619093,
        "service_name": "kepler-normies",
        "span_id": 8844603704172981067,
        "trace_id": 7160327726948619093
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-05 00:54:17
success: True
trace_id: 7160327726948619093

Scan 161455905

duration: 0:00:14.579795

exit_message:

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

id: 161455905

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-04/1775281920",
        "key": "raw/facility_group_fact/2026-04-04/1775281920/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3690410083995389938,
        "service_name": "kepler-normies",
        "span_id": 17637645746715078866,
        "trace_id": 3690410083995389938
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-04 00:52:23
success: True
trace_id: 3690410083995389938

Scan 161398541

duration: 0:00:12.146670

exit_message:

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

id: 161398541

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "deleted_on": "date",
        "end_date": "date",
        "facility_dim_id": "int",
        "facility_group_fact_id": "int",
        "facility_group_name": "string",
        "migrated_on": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "start_date": "date"
    },
    "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_group_fact/2026-04-03/1775195976",
        "key": "raw/facility_group_fact/2026-04-03/1775195976/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_facility_group_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5032326561912019133,
        "service_name": "kepler-normies",
        "span_id": 10701990611375049925,
        "trace_id": 5032326561912019133
    }
}

running: False
schema_name_id: 622
start_time: 2026-04-03 01:03:39
success: True
trace_id: 5032326561912019133

Partitions:

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

Schema:

attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "deleted_on": "date",
    "end_date": "date",
    "facility_dim_id": "int",
    "facility_group_fact_id": "int",
    "facility_group_name": "string",
    "migrated_on": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "start_date": "date"
}

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

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_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-17/1776405384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_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:45:54",
        "disabled": false,
        "format": "raw",
        "id": 622,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_facility_group_fact"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "company_dim_id": "int",
            "date_dim_id": "int",
            "deleted_on": "date",
            "end_date": "date",
            "facility_dim_id": "int",
            "facility_group_fact_id": "int",
            "facility_group_name": "string",
            "migrated_on": "string",
            "provider": "string",
            "provider_id": "string",
            "received_epoch": "bigint",
            "start_date": "date"
        },
        "created": "2026-04-17 00:56:51",
        "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_group_fact`\n(\n `facility_group_fact_id`  int , `provider_id`  string , `provider`  string , `facility_group_name`  string , `start_date`  date , `end_date`  date , `deleted_on`  date , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `migrated_on`  string , `received_epoch`  bigint \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/facility_group_fact/2026-04-17/1776405384'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_facility_group_fact`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_facility_group_fact"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}