Schema Info
Schema Name: sfdl_prod_postgres.keplernormies_insurance_activity_fact
- created: 2020-11-15 01:09:20
- disabled: False
- format: raw
- id: 810
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_prod_postgres", "table": "keplernormies_insurance_activity_fact" } - type: postgres
Schema Versions: 15
-
Version 1717520
- created: 2026-04-17 01:08:11
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-17/1776406056'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-17/1776406056
- id: 1717520
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 162165046
- updated: 2026-04-17 01:08:25
-
Version 1716283
- created: 2026-04-16 01:14:04
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-16/1776320013'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-16/1776320013
- id: 1716283
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 162109283
- updated: 2026-04-16 01:14:18
-
Version 1715094
- created: 2026-04-15 01:21:58
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-15/1776234090'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-15/1776234090
- id: 1715094
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 162053431
- updated: 2026-04-15 01:22:09
-
Version 1713894
- created: 2026-04-14 01:05:46
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-14/1776146722'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-14/1776146722
- id: 1713894
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161997624
- updated: 2026-04-14 01:06:00
-
Version 1712664
- created: 2026-04-13 01:14:12
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-13/1776060827'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-13/1776060827
- id: 1712664
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161940082
- updated: 2026-04-13 01:14:24
-
Version 1711453
- created: 2026-04-12 01:02:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-12/1775973755'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-12/1775973755
- id: 1711453
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161890411
- updated: 2026-04-12 01:03:10
-
Version 1710267
- created: 2026-04-11 01:06:29
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-11/1775887565'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-11/1775887565
- id: 1710267
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161838663
- updated: 2026-04-11 01:06:43
-
Version 1709115
- created: 2026-04-10 01:06:19
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-10/1775801154'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-10/1775801154
- id: 1709115
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161783131
- updated: 2026-04-10 01:06:30
-
Version 1707971
- created: 2026-04-09 01:13:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-09/1775715195'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-09/1775715195
- id: 1707971
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161727968
- updated: 2026-04-09 01:13:56
-
Version 1706762
- created: 2026-04-08 01:12:14
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-08/1775628710'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-08/1775628710
- id: 1706762
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161672813
- updated: 2026-04-08 01:12:28
-
Version 1705576
- created: 2026-04-07 01:05:15
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-07/1775541891'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-07/1775541891
- id: 1705576
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161616720
- updated: 2026-04-07 01:05:28
-
Version 1704353
- created: 2026-04-06 01:20:20
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-06/1775456387'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-06/1775456387
- id: 1704353
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161558876
- updated: 2026-04-06 01:20:34
-
Version 1703160
- created: 2026-04-05 01:05:45
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-05/1775369124'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-05/1775369124
- id: 1703160
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161512412
- updated: 2026-04-05 01:05:59
-
Version 1701983
- created: 2026-04-04 01:04:47
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-04/1775282656'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-04/1775282656
- id: 1701983
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161457426
- updated: 2026-04-04 01:05:01
-
Version 1700778
- created: 2026-04-03 01:12:42
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-03/1775196720'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-03/1775196720
- id: 1700778
- processed: 1
- raw_data:
{ "action_type": 3, "activity_source": 25, "amount": 19, "auto_enrolled": 24, "cancellation_effective_dim_id": 9, "company_dim_id": 10, "coverage_amount": 5, "coverage_effective_dim_id": 8, "coverage_percentage": 6, "date_dim_id": 14, "deleted": 21, "deleted_on_date_dim_id": 22, "facility_dim_id": 11, "insurance_activity_fact_id": 0, "insurance_company": 23, "paid_thru_date_dim_id": 18, "policy_number": 4, "premium": 7, "provider": 2, "provider_id": 1, "received_epoch": 15, "refund_due": 20, "refund_paid": 16, "retained_fee": 17, "tenant_dim_id": 13, "unit_dim_id": 12 } - schema_attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - schema_name_id: 810
- schema_scan_id: 161398689
- updated: 2026-04-03 01:12:56
Schema Scans: 15
Last at 2026-04-17 01:08:10
-
Scan 162165046
- duration: 0:00:15.108120
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162165046
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-17/1776406056", "key": "raw/insurance_activity_fact/2026-04-17/1776406056/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 1390050617487927841, "service_name": "kepler-normies", "span_id": 4527998914073871212, "trace_id": 1390050617487927841 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-17 01:08:10
- success: True
- trace_id: 1390050617487927841
-
Scan 162109283
- duration: 0:00:15.090498
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162109283
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-16/1776320013", "key": "raw/insurance_activity_fact/2026-04-16/1776320013/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 10977564776670730397, "service_name": "kepler-normies", "span_id": 50666374290334197, "trace_id": 10977564776670730397 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-16 01:14:03
- success: True
- trace_id: 10977564776670730397
-
Scan 162053431
- duration: 0:00:12.403064
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 162053431
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-15/1776234090", "key": "raw/insurance_activity_fact/2026-04-15/1776234090/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 17834091837963174992, "service_name": "kepler-normies", "span_id": 5094620160040312375, "trace_id": 17834091837963174992 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-15 01:21:57
- success: True
- trace_id: 17834091837963174992
-
Scan 161997624
- duration: 0:00:14.919687
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161997624
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-14/1776146722", "key": "raw/insurance_activity_fact/2026-04-14/1776146722/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 18431101933956811081, "service_name": "kepler-normies", "span_id": 17578972865076861083, "trace_id": 18431101933956811081 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-14 01:05:45
- success: True
- trace_id: 18431101933956811081
-
Scan 161940082
- duration: 0:00:12.297167
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161940082
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-13/1776060827", "key": "raw/insurance_activity_fact/2026-04-13/1776060827/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 3666128158302385128, "service_name": "kepler-normies", "span_id": 7640811940829026713, "trace_id": 3666128158302385128 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-13 01:14:11
- success: True
- trace_id: 3666128158302385128
-
Scan 161890411
- duration: 0:00:12.291572
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161890411
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-12/1775973755", "key": "raw/insurance_activity_fact/2026-04-12/1775973755/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 14947937938843240221, "service_name": "kepler-normies", "span_id": 14648519507552256173, "trace_id": 14947937938843240221 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-12 01:02:58
- success: True
- trace_id: 14947937938843240221
-
Scan 161838663
- duration: 0:00:14.982070
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161838663
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-11/1775887565", "key": "raw/insurance_activity_fact/2026-04-11/1775887565/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 12718527847316887778, "service_name": "kepler-normies", "span_id": 15546992532445319906, "trace_id": 12718527847316887778 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-11 01:06:28
- success: True
- trace_id: 12718527847316887778
-
Scan 161783131
- duration: 0:00:12.444553
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161783131
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-10/1775801154", "key": "raw/insurance_activity_fact/2026-04-10/1775801154/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 14688578680827928297, "service_name": "kepler-normies", "span_id": 10671049077017933316, "trace_id": 14688578680827928297 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-10 01:06:18
- success: True
- trace_id: 14688578680827928297
-
Scan 161727968
- duration: 0:00:14.958015
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161727968
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-09/1775715195", "key": "raw/insurance_activity_fact/2026-04-09/1775715195/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 8070032008810214972, "service_name": "kepler-normies", "span_id": 15510018337402994552, "trace_id": 8070032008810214972 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-09 01:13:41
- success: True
- trace_id: 8070032008810214972
-
Scan 161672813
- duration: 0:00:14.912295
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161672813
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-08/1775628710", "key": "raw/insurance_activity_fact/2026-04-08/1775628710/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 3957324485207074804, "service_name": "kepler-normies", "span_id": 9005532478683474969, "trace_id": 3957324485207074804 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-08 01:12:13
- success: True
- trace_id: 3957324485207074804
-
Scan 161616720
- duration: 0:00:14.979070
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161616720
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-07/1775541891", "key": "raw/insurance_activity_fact/2026-04-07/1775541891/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 5370452742246729546, "service_name": "kepler-normies", "span_id": 2576646181317203573, "trace_id": 5370452742246729546 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-07 01:05:14
- success: True
- trace_id: 5370452742246729546
-
Scan 161558876
- duration: 0:00:15.034915
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161558876
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-06/1775456387", "key": "raw/insurance_activity_fact/2026-04-06/1775456387/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 5064791089049049967, "service_name": "kepler-normies", "span_id": 16817393267168252104, "trace_id": 5064791089049049967 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-06 01:20:19
- success: True
- trace_id: 5064791089049049967
-
Scan 161512412
- duration: 0:00:14.978930
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161512412
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-05/1775369124", "key": "raw/insurance_activity_fact/2026-04-05/1775369124/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 10261009490899174485, "service_name": "kepler-normies", "span_id": 16368272885902606810, "trace_id": 10261009490899174485 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-05 01:05:44
- success: True
- trace_id: 10261009490899174485
-
Scan 161457426
- duration: 0:00:14.948713
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161457426
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-04/1775282656", "key": "raw/insurance_activity_fact/2026-04-04/1775282656/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 2419813983489251451, "service_name": "kepler-normies", "span_id": 6862971880957352100, "trace_id": 2419813983489251451 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-04 01:04:46
- success: True
- trace_id: 2419813983489251451
-
Scan 161398689
- duration: 0:00:14.884053
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 161398689
- payload:
{ "datatype_dict": { "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" }, "file_format": "dat", "file_properties": { "data_has_header_row": true, "serde_properties": { "separatorChar": "\u0001" } }, "is_schema_datatyped": true, "s3": { "bucket": "sfdl-postgres-keplernormies-prod", "hive_path": "s3://sfdl-postgres-keplernormies-prod/raw/insurance_activity_fact/2026-04-03/1775196720", "key": "raw/insurance_activity_fact/2026-04-03/1775196720/data_0.csv.gz" }, "schema": { "name": "sfdl_prod_postgres.keplernormies_insurance_activity_fact", "type": "postgres" }, "trace_context": { "parent_id": 17522291839264347297, "service_name": "kepler-normies", "span_id": 6982989055262353942, "trace_id": 17522291839264347297 } } - running: False
- schema_name_id: 810
- start_time: 2026-04-03 01:12:41
- success: True
- trace_id: 17522291839264347297
- attributes:
{ "action_type": "string", "activity_source": "string", "amount": "decimal", "auto_enrolled": "string", "cancellation_effective_dim_id": "int", "company_dim_id": "int", "coverage_amount": "decimal", "coverage_effective_dim_id": "int", "coverage_percentage": "decimal", "date_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "facility_dim_id": "int", "insurance_activity_fact_id": "int", "insurance_company": "string", "paid_thru_date_dim_id": "int", "policy_number": "string", "premium": "decimal", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "refund_due": "decimal", "refund_paid": "decimal", "retained_fee": "decimal", "tenant_dim_id": "int", "unit_dim_id": "int" } - created: 2026-04-17 01:08:11
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-17/1776406056'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`", "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact" }
- hostname: schemamanager-5475496c57-7dpqb
- name: schema_manager
- process_start: 2026-01-09 11:27:47
- sf_env: prod
- version: 2112174301
{
"name": {
"created": "2020-11-15 01:09:20",
"disabled": false,
"format": "raw",
"id": 810,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_prod_postgres",
"table": "keplernormies_insurance_activity_fact"
},
"type": "postgres"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"action_type": "string",
"activity_source": "string",
"amount": "decimal",
"auto_enrolled": "string",
"cancellation_effective_dim_id": "int",
"company_dim_id": "int",
"coverage_amount": "decimal",
"coverage_effective_dim_id": "int",
"coverage_percentage": "decimal",
"date_dim_id": "int",
"deleted": "string",
"deleted_on_date_dim_id": "int",
"facility_dim_id": "int",
"insurance_activity_fact_id": "int",
"insurance_company": "string",
"paid_thru_date_dim_id": "int",
"policy_number": "string",
"premium": "decimal",
"provider": "string",
"provider_id": "string",
"received_epoch": "bigint",
"refund_due": "decimal",
"refund_paid": "decimal",
"retained_fee": "decimal",
"tenant_dim_id": "int",
"unit_dim_id": "int"
},
"created": "2026-04-17 01:08:11",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_insurance_activity_fact`\n(\n `insurance_activity_fact_id` int , `provider_id` string , `provider` string , `action_type` string , `policy_number` string , `coverage_amount` decimal , `coverage_percentage` decimal , `premium` decimal , `coverage_effective_dim_id` int , `cancellation_effective_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `unit_dim_id` int , `tenant_dim_id` int , `date_dim_id` int , `received_epoch` bigint , `refund_paid` decimal , `retained_fee` decimal , `paid_thru_date_dim_id` int , `amount` decimal , `refund_due` decimal , `deleted` string , `deleted_on_date_dim_id` int , `insurance_company` string , `auto_enrolled` string , `activity_source` 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/insurance_activity_fact/2026-04-17/1776406056'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_insurance_activity_fact`",
"repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_insurance_activity_fact"
}
},
"server": {
"hostname": "schemamanager-5475496c57-7dpqb",
"name": "schema_manager",
"process_start": "2026-01-09 11:27:47",
"sf_env": "prod",
"version": "2112174301"
}
}