Schema Info
Schema Name: sfdl_prod_postgres.keplernormies_unit_dim
- created: 2019-02-12 04:46:32
- disabled: False
- format: raw
- id: 627
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_postgres", "table": "keplernormies_unit_dim" } - type: postgres
Schema Versions: 15
-
Version 1717501
- created: 2026-04-17 00:55:24
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-17/1776405307'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-17/1776405307
- id: 1717501
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 162163979
- updated: 2026-04-17 00:55:37
-
Version 1716271
- created: 2026-04-16 01:04:40
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-16/1776319464'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-16/1776319464
- id: 1716271
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 162109252
- updated: 2026-04-16 01:04:53
-
Version 1715077
- created: 2026-04-15 01:07:25
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-15/1776233227'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-15/1776233227
- id: 1715077
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 162053395
- updated: 2026-04-15 01:07:36
-
Version 1713889
- created: 2026-04-14 01:03:10
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-14/1776146507'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-14/1776146507
- id: 1713889
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161997610
- updated: 2026-04-14 01:03:23
-
Version 1712652
- created: 2026-04-13 01:04:43
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-13/1776060266'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-13/1776060266
- id: 1712652
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161940050
- updated: 2026-04-13 01:04:56
-
Version 1711455
- created: 2026-04-12 01:03:09
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-12/1775973562'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-12/1775973562
- id: 1711455
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161890434
- updated: 2026-04-12 01:03:20
-
Version 1710258
- created: 2026-04-11 01:04:16
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-11/1775887435'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-11/1775887435
- id: 1710258
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161838649
- updated: 2026-04-11 01:04:30
-
Version 1709093
- created: 2026-04-10 01:01:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-10/1775800893'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-10/1775800893
- id: 1709093
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161782964
- updated: 2026-04-10 01:02:02
-
Version 1707951
- created: 2026-04-09 00:54:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-09/1775714068'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-09/1775714068
- id: 1707951
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161726750
- updated: 2026-04-09 00:54:58
-
Version 1706748
- created: 2026-04-08 01:08:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-08/1775628511'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-08/1775628511
- id: 1706748
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161672796
- updated: 2026-04-08 01:08:59
-
Version 1705561
- created: 2026-04-07 01:02:52
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-07/1775541760'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-07/1775541760
- id: 1705561
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161616682
- updated: 2026-04-07 01:03:03
-
Version 1704327
- created: 2026-04-06 01:02:49
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-06/1775455320'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-06/1775455320
- id: 1704327
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161558689
- updated: 2026-04-06 01:03:00
-
Version 1703143
- created: 2026-04-05 00:53:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-05/1775368418'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-05/1775368418
- id: 1703143
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161511119
- updated: 2026-04-05 00:54:02
-
Version 1701976
- created: 2026-04-04 00:52:37
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-04/1775281934'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-04/1775281934
- id: 1701976
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161455911
- updated: 2026-04-04 00:52:48
-
Version 1700761
- created: 2026-04-03 01:02:39
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-03/1775195950'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-03/1775195950
- id: 1700761
- processed: 1
- raw_data:
{ "access_type": 16, "area": 7, "attribute_description": 22, "auto_applied_discount_plans": 25, "channel_rates": 21, "combo_lock_group_combo_code": 26, "combo_lock_group_name": 27, "deleted_on": 18, "door_height": 9, "door_type": 10, "door_width": 8, "excludes_insurance": 28, "external_account_code": 23, "external_account_name": 24, "floor": 15, "fully_enclosed": 29, "height": 6, "length": 5, "migrated_on": 13, "provider": 2, "provider_id": 1, "received_epoch": 14, "sort_string": 12, "unit_amenities": 20, "unit_dim_id": 0, "unit_group_key": 17, "unit_name": 3, "unit_type": 11, "walk_through_order": 19, "width": 4 } - schema_attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - schema_name_id: 627
- schema_scan_id: 161398431
- updated: 2026-04-03 01:02:52
Schema Scans: 15
Last at 2026-04-17 00:55:22
-
Scan 162163979
- duration: 0:00:14.928249
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162163979
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-17/1776405307", "key": "raw/unit_dim/2026-04-17/1776405307/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 9728302807880349508, "service_name": "kepler-normies", "span_id": 10454208892291684347, "trace_id": 9728302807880349508 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-17 00:55:22
- success: True
- trace_id: 9728302807880349508
-
Scan 162109252
- duration: 0:00:15.057945
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162109252
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-16/1776319464", "key": "raw/unit_dim/2026-04-16/1776319464/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 17785278045092561681, "service_name": "kepler-normies", "span_id": 2454623586665889541, "trace_id": 17785278045092561681 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-16 01:04:38
- success: True
- trace_id: 17785278045092561681
-
Scan 162053395
- duration: 0:00:12.424092
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162053395
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-15/1776233227", "key": "raw/unit_dim/2026-04-15/1776233227/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 10103233210122952694, "service_name": "kepler-normies", "span_id": 9808042620546289628, "trace_id": 10103233210122952694 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-15 01:07:24
- success: True
- trace_id: 10103233210122952694
-
Scan 161997610
- duration: 0:00:14.894807
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161997610
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-14/1776146507", "key": "raw/unit_dim/2026-04-14/1776146507/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 5729459480151887824, "service_name": "kepler-normies", "span_id": 18109601955170601361, "trace_id": 5729459480151887824 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-14 01:03:08
- success: True
- trace_id: 5729459480151887824
-
Scan 161940050
- duration: 0:00:14.914880
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161940050
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-13/1776060266", "key": "raw/unit_dim/2026-04-13/1776060266/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 18286736428375362660, "service_name": "kepler-normies", "span_id": 7344469066523985289, "trace_id": 18286736428375362660 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-13 01:04:42
- success: True
- trace_id: 18286736428375362660
-
Scan 161890434
- duration: 0:00:12.350510
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161890434
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-12/1775973562", "key": "raw/unit_dim/2026-04-12/1775973562/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 9058068602163820648, "service_name": "kepler-normies", "span_id": 9950162629855728140, "trace_id": 9058068602163820648 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-12 01:03:07
- success: True
- trace_id: 9058068602163820648
-
Scan 161838649
- duration: 0:00:14.884880
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161838649
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-11/1775887435", "key": "raw/unit_dim/2026-04-11/1775887435/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 1722224860744704151, "service_name": "kepler-normies", "span_id": 6305136994715157716, "trace_id": 1722224860744704151 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-11 01:04:15
- success: True
- trace_id: 1722224860744704151
-
Scan 161782964
- duration: 0:00:14.895891
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161782964
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-10/1775800893", "key": "raw/unit_dim/2026-04-10/1775800893/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 13817411085119327302, "service_name": "kepler-normies", "span_id": 15632421818200416836, "trace_id": 13817411085119327302 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-10 01:01:47
- success: True
- trace_id: 13817411085119327302
-
Scan 161726750
- duration: 0:00:12.343853
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161726750
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-09/1775714068", "key": "raw/unit_dim/2026-04-09/1775714068/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 4592600096804384831, "service_name": "kepler-normies", "span_id": 12541637400793622741, "trace_id": 4592600096804384831 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-09 00:54:46
- success: True
- trace_id: 4592600096804384831
-
Scan 161672796
- duration: 0:00:14.964926
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161672796
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-08/1775628511", "key": "raw/unit_dim/2026-04-08/1775628511/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 16112457973273340944, "service_name": "kepler-normies", "span_id": 5864575177631344389, "trace_id": 16112457973273340944 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-08 01:08:44
- success: True
- trace_id: 16112457973273340944
-
Scan 161616682
- duration: 0:00:12.612614
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161616682
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-07/1775541760", "key": "raw/unit_dim/2026-04-07/1775541760/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 14609101674053801073, "service_name": "kepler-normies", "span_id": 10532350464219209653, "trace_id": 14609101674053801073 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-07 01:02:50
- success: True
- trace_id: 14609101674053801073
-
Scan 161558689
- duration: 0:00:12.467021
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161558689
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-06/1775455320", "key": "raw/unit_dim/2026-04-06/1775455320/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 3783161549274498106, "service_name": "kepler-normies", "span_id": 6153434991973288948, "trace_id": 3783161549274498106 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-06 01:02:48
- success: True
- trace_id: 3783161549274498106
-
Scan 161511119
- duration: 0:00:14.940798
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161511119
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-05/1775368418", "key": "raw/unit_dim/2026-04-05/1775368418/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 12109720254127116944, "service_name": "kepler-normies", "span_id": 7199572880465761331, "trace_id": 12109720254127116944 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-05 00:53:47
- success: True
- trace_id: 12109720254127116944
-
Scan 161455911
- duration: 0:00:12.470391
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161455911
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-04/1775281934", "key": "raw/unit_dim/2026-04-04/1775281934/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 11114458099143633687, "service_name": "kepler-normies", "span_id": 14021928756649950194, "trace_id": 11114458099143633687 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-04 00:52:36
- success: True
- trace_id: 11114458099143633687
-
Scan 161398431
- duration: 0:00:14.971241
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161398431
- payload:
{ "datatype_dict": { "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-03/1775195950", "key": "raw/unit_dim/2026-04-03/1775195950/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_unit_dim", "type": "postgres" }, "trace_context": { "parent_id": 16673463987460386449, "service_name": "kepler-normies", "span_id": 4761509522954717205, "trace_id": 16673463987460386449 } } - running: False
- schema_name_id: 627
- start_time: 2026-04-03 01:02:37
- success: True
- trace_id: 16673463987460386449
- attributes:
{ "access_type": "string", "area": "double", "attribute_description": "string", "auto_applied_discount_plans": "string", "channel_rates": "string", "combo_lock_group_combo_code": "string", "combo_lock_group_name": "string", "deleted_on": "date", "door_height": "double", "door_type": "string", "door_width": "double", "excludes_insurance": "string", "external_account_code": "string", "external_account_name": "string", "floor": "int", "fully_enclosed": "string", "height": "double", "length": "double", "migrated_on": "string", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "sort_string": "string", "unit_amenities": "string", "unit_dim_id": "int", "unit_group_key": "string", "unit_name": "string", "unit_type": "string", "walk_through_order": "int", "width": "double" } - created: 2026-04-17 00:55:24
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-17/1776405307'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim" }
- 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:46:32",
"disabled": false,
"format": "raw",
"id": 627,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_postgres",
"table": "keplernormies_unit_dim"
},
"type": "postgres"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"access_type": "string",
"area": "double",
"attribute_description": "string",
"auto_applied_discount_plans": "string",
"channel_rates": "string",
"combo_lock_group_combo_code": "string",
"combo_lock_group_name": "string",
"deleted_on": "date",
"door_height": "double",
"door_type": "string",
"door_width": "double",
"excludes_insurance": "string",
"external_account_code": "string",
"external_account_name": "string",
"floor": "int",
"fully_enclosed": "string",
"height": "double",
"length": "double",
"migrated_on": "string",
"provider": "string",
"provider_id": "string",
"received_epoch": "bigint",
"sort_string": "string",
"unit_amenities": "string",
"unit_dim_id": "int",
"unit_group_key": "string",
"unit_name": "string",
"unit_type": "string",
"walk_through_order": "int",
"width": "double"
},
"created": "2026-04-17 00:55:24",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_unit_dim`\n(\n `unit_dim_id` int , `provider_id` string , `provider` string , `unit_name` string , `width` double , `length` double , `height` double , `area` double , `door_width` double , `door_height` double , `door_type` string , `unit_type` string , `sort_string` string , `migrated_on` string , `received_epoch` bigint , `floor` int , `access_type` string , `unit_group_key` string , `deleted_on` date , `walk_through_order` int , `unit_amenities` string , `channel_rates` string , `attribute_description` string , `external_account_code` string , `external_account_name` string , `auto_applied_discount_plans` string , `combo_lock_group_combo_code` string , `combo_lock_group_name` string , `excludes_insurance` string , `fully_enclosed` string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-prod/raw/unit_dim/2026-04-17/1776405307'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_unit_dim`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_unit_dim"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}