Schema Info
Schema Name: sfdl_prod_postgres.keplernormies_occupancy_fact
- created: 2019-02-12 04:49:52
- disabled: False
- format: raw
- id: 630
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_postgres", "table": "keplernormies_occupancy_fact" } - type: postgres
Schema Versions: 15
-
Version 1717525
- created: 2026-04-17 01:49:03
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-17/1776408495'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-17/1776408495
- id: 1717525
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 162165187
- updated: 2026-04-17 01:49:17
-
Version 1716292
- created: 2026-04-16 01:57:44
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-16/1776322621'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-16/1776322621
- id: 1716292
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 162109790
- updated: 2026-04-16 01:57:56
-
Version 1715100
- created: 2026-04-15 01:56:08
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-15/1776236127'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-15/1776236127
- id: 1715100
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 162053704
- updated: 2026-04-15 01:56:19
-
Version 1713914
- created: 2026-04-14 02:01:18
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-14/1776149921'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-14/1776149921
- id: 1713914
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161998821
- updated: 2026-04-14 02:01:32
-
Version 1712670
- created: 2026-04-13 01:54:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-13/1776063221'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-13/1776063221
- id: 1712670
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161940175
- updated: 2026-04-13 01:54:31
-
Version 1711476
- created: 2026-04-12 02:01:56
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-12/1775977282'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-12/1775977282
- id: 1711476
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161891874
- updated: 2026-04-12 02:02:10
-
Version 1710280
- created: 2026-04-11 01:49:23
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-11/1775890115'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-11/1775890115
- id: 1710280
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161838728
- updated: 2026-04-11 01:49:34
-
Version 1709122
- created: 2026-04-10 01:54:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-10/1775804044'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-10/1775804044
- id: 1709122
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161783251
- updated: 2026-04-10 01:54:56
-
Version 1707980
- created: 2026-04-09 01:51:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-09/1775717464'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-09/1775717464
- id: 1707980
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161728077
- updated: 2026-04-09 01:51:52
-
Version 1706768
- created: 2026-04-08 01:49:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-08/1775630910'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-08/1775630910
- id: 1706768
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161672891
- updated: 2026-04-08 01:49:26
-
Version 1705590
- created: 2026-04-07 01:52:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-07/1775544730'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-07/1775544730
- id: 1705590
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161616871
- updated: 2026-04-07 01:52:59
-
Version 1704361
- created: 2026-04-06 01:57:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-06/1775458593'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-06/1775458593
- id: 1704361
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161559438
- updated: 2026-04-06 01:57:30
-
Version 1703165
- created: 2026-04-05 01:46:26
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-05/1775371546'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-05/1775371546
- id: 1703165
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161512497
- updated: 2026-04-05 01:46:40
-
Version 1701994
- created: 2026-04-04 01:49:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-04/1775285315'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-04/1775285315
- id: 1701994
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161457545
- updated: 2026-04-04 01:49:19
-
Version 1700786
- created: 2026-04-03 02:01:07
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-03/1775199628'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-03/1775199628
- id: 1700786
- processed: 1
- raw_data:
{ "available_on_date_dim_id": 24, "company_dim_id": 15, "company_owned": 26, "complimentary": 4, "cross_sell_group_dim_id": 27, "damaged": 5, "date_dim_id": 19, "deleted_on": 14, "dirty": 6, "end_date": 13, "facility_dim_id": 16, "insured": 8, "insured_private": 22, "ledger_provider_id": 25, "managed_rate": 9, "migrated_on": 20, "occupancy_fact_id": 0, "occupied": 1, "received_epoch": 21, "rent_rate": 11, "reserved": 3, "standard_rate": 10, "start_date": 12, "tenant_dim_id": 18, "tier_dim_id": 29, "tiered_rate": 28, "unit_dim_id": 17, "unit_group_key": 23, "unrentable": 7, "vacant": 2 } - schema_attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - schema_name_id: 630
- schema_scan_id: 161399981
- updated: 2026-04-03 02:01:18
Schema Scans: 15
Last at 2026-04-17 01:49:01
-
Scan 162165187
- duration: 0:00:15.172051
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162165187
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-17/1776408495", "key": "raw/occupancy_fact/2026-04-17/1776408495/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 17412567433029281541, "service_name": "kepler-normies", "span_id": 5067767015313222918, "trace_id": 17412567433029281541 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-17 01:49:01
- success: True
- trace_id: 17412567433029281541
-
Scan 162109790
- duration: 0:00:12.519570
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162109790
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-16/1776322621", "key": "raw/occupancy_fact/2026-04-16/1776322621/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 8220569727757529709, "service_name": "kepler-normies", "span_id": 3658342738668659046, "trace_id": 8220569727757529709 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-16 01:57:43
- success: True
- trace_id: 8220569727757529709
-
Scan 162053704
- duration: 0:00:12.560643
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162053704
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-15/1776236127", "key": "raw/occupancy_fact/2026-04-15/1776236127/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 8947717095924613867, "service_name": "kepler-normies", "span_id": 459694265633877430, "trace_id": 8947717095924613867 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-15 01:56:06
- success: True
- trace_id: 8947717095924613867
-
Scan 161998821
- duration: 0:00:15.124305
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161998821
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-14/1776149921", "key": "raw/occupancy_fact/2026-04-14/1776149921/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 5043120040269973798, "service_name": "kepler-normies", "span_id": 9294320525065050971, "trace_id": 5043120040269973798 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-14 02:01:17
- success: True
- trace_id: 5043120040269973798
-
Scan 161940175
- duration: 0:00:12.493060
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161940175
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-13/1776063221", "key": "raw/occupancy_fact/2026-04-13/1776063221/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 15654068860859999032, "service_name": "kepler-normies", "span_id": 9083852335995240353, "trace_id": 15654068860859999032 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-13 01:54:18
- success: True
- trace_id: 15654068860859999032
-
Scan 161891874
- duration: 0:00:14.944031
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161891874
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-12/1775977282", "key": "raw/occupancy_fact/2026-04-12/1775977282/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 16573118641692814847, "service_name": "kepler-normies", "span_id": 16947300590880849011, "trace_id": 16573118641692814847 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-12 02:01:55
- success: True
- trace_id: 16573118641692814847
-
Scan 161838728
- duration: 0:00:12.609445
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161838728
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-11/1775890115", "key": "raw/occupancy_fact/2026-04-11/1775890115/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 13134940198470395395, "service_name": "kepler-normies", "span_id": 7308926288339298087, "trace_id": 13134940198470395395 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-11 01:49:22
- success: True
- trace_id: 13134940198470395395
-
Scan 161783251
- duration: 0:00:15.179155
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161783251
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-10/1775804044", "key": "raw/occupancy_fact/2026-04-10/1775804044/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 6952644865164866652, "service_name": "kepler-normies", "span_id": 13368489694621718429, "trace_id": 6952644865164866652 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-10 01:54:41
- success: True
- trace_id: 6952644865164866652
-
Scan 161728077
- duration: 0:00:15.120059
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161728077
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-09/1775717464", "key": "raw/occupancy_fact/2026-04-09/1775717464/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 17169527787531097960, "service_name": "kepler-normies", "span_id": 17889190844007766536, "trace_id": 17169527787531097960 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-09 01:51:37
- success: True
- trace_id: 17169527787531097960
-
Scan 161672891
- duration: 0:00:14.909533
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161672891
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-08/1775630910", "key": "raw/occupancy_fact/2026-04-08/1775630910/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 540431817074564887, "service_name": "kepler-normies", "span_id": 15390841196261673649, "trace_id": 540431817074564887 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-08 01:49:11
- success: True
- trace_id: 540431817074564887
-
Scan 161616871
- duration: 0:00:15.017025
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161616871
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-07/1775544730", "key": "raw/occupancy_fact/2026-04-07/1775544730/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 10180980935621394183, "service_name": "kepler-normies", "span_id": 2696239670339058671, "trace_id": 10180980935621394183 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-07 01:52:44
- success: True
- trace_id: 10180980935621394183
-
Scan 161559438
- duration: 0:00:15.092603
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161559438
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-06/1775458593", "key": "raw/occupancy_fact/2026-04-06/1775458593/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 3277854067490763468, "service_name": "kepler-normies", "span_id": 13683332177504366980, "trace_id": 3277854067490763468 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-06 01:57:15
- success: True
- trace_id: 3277854067490763468
-
Scan 161512497
- duration: 0:00:14.976157
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161512497
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-05/1775371546", "key": "raw/occupancy_fact/2026-04-05/1775371546/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 9110748403984865548, "service_name": "kepler-normies", "span_id": 13062689959904448006, "trace_id": 9110748403984865548 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-05 01:46:25
- success: True
- trace_id: 9110748403984865548
-
Scan 161457545
- duration: 0:00:12.407802
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161457545
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-04/1775285315", "key": "raw/occupancy_fact/2026-04-04/1775285315/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 16420504013569005720, "service_name": "kepler-normies", "span_id": 14653212716298339032, "trace_id": 16420504013569005720 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-04 01:49:06
- success: True
- trace_id: 16420504013569005720
-
Scan 161399981
- duration: 0:00:12.492137
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161399981
- payload:
{ "datatype_dict": { "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "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/occupancy_fact/2026-04-03/1775199628", "key": "raw/occupancy_fact/2026-04-03/1775199628/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_occupancy_fact", "type": "postgres" }, "trace_context": { "parent_id": 8997815302210851102, "service_name": "kepler-normies", "span_id": 13348752479884570703, "trace_id": 8997815302210851102 } } - running: False
- schema_name_id: 630
- start_time: 2026-04-03 02:01:06
- success: True
- trace_id: 8997815302210851102
- attributes:
{ "available_on_date_dim_id": "int", "company_dim_id": "int", "company_owned": "int", "complimentary": "int", "cross_sell_group_dim_id": "int", "damaged": "int", "date_dim_id": "int", "deleted_on": "date", "dirty": "int", "end_date": "date", "facility_dim_id": "int", "insured": "int", "insured_private": "int", "ledger_provider_id": "string", "managed_rate": "decimal", "migrated_on": "string", "occupancy_fact_id": "int", "occupied": "int", "received_epoch": "bigint", "rent_rate": "decimal", "reserved": "int", "standard_rate": "decimal", "start_date": "date", "tenant_dim_id": "int", "tier_dim_id": "int", "tiered_rate": "decimal", "unit_dim_id": "int", "unit_group_key": "string", "unrentable": "int", "vacant": "int" } - created: 2026-04-17 01:49:03
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-17/1776408495'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2019-02-12 04:49:52",
"disabled": false,
"format": "raw",
"id": 630,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_postgres",
"table": "keplernormies_occupancy_fact"
},
"type": "postgres"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"available_on_date_dim_id": "int",
"company_dim_id": "int",
"company_owned": "int",
"complimentary": "int",
"cross_sell_group_dim_id": "int",
"damaged": "int",
"date_dim_id": "int",
"deleted_on": "date",
"dirty": "int",
"end_date": "date",
"facility_dim_id": "int",
"insured": "int",
"insured_private": "int",
"ledger_provider_id": "string",
"managed_rate": "decimal",
"migrated_on": "string",
"occupancy_fact_id": "int",
"occupied": "int",
"received_epoch": "bigint",
"rent_rate": "decimal",
"reserved": "int",
"standard_rate": "decimal",
"start_date": "date",
"tenant_dim_id": "int",
"tier_dim_id": "int",
"tiered_rate": "decimal",
"unit_dim_id": "int",
"unit_group_key": "string",
"unrentable": "int",
"vacant": "int"
},
"created": "2026-04-17 01:49:03",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_occupancy_fact`\n(\n `occupancy_fact_id` int , `occupied` int , `vacant` int , `reserved` int , `complimentary` int , `damaged` int , `dirty` int , `unrentable` int , `insured` int , `managed_rate` decimal , `standard_rate` decimal , `rent_rate` decimal , `start_date` date , `end_date` date , `deleted_on` date , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `migrated_on` string , `received_epoch` bigint , `insured_private` int , `unit_group_key` string , `available_on_date_dim_id` int , `ledger_provider_id` string , `company_owned` int , `cross_sell_group_dim_id` int , `tiered_rate` decimal , `tier_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/occupancy_fact/2026-04-17/1776408495'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_occupancy_fact`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_occupancy_fact"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}