Schema Info
Schema Name: sfdl_stage_postgres.keplernormies_delinquency_action_fact
- created: 2022-07-29 13:48:27
- disabled: False
- format: raw
- id: 1229
- is_partitioned: False
- is_schema_datatyped: True
- name:
{ "database": "sfdl_stage_postgres", "table": "keplernormies_delinquency_action_fact" } - type: postgres
Schema Versions: 3
-
Version 868669
- created: 2025-09-27 02:10:57
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_delinquency_action_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_delinquency_action_fact`\n(\n `delinquency_action_fact_id` int , `provider_id` string , `provider` string , `stage_applied_on_date_dim_id` int , `recurring_stage` string , `action_name` string , `action_status` string , `action_price` string , `action_completed` string , `action_cancelled` string , `last_action_on_date_dim_id` int , `resolved_on_date_dim_id` int , `updated_by_user_dim_id` int , `needs_followup` string , `needs_followup_by_user_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `tenant_dim_id` int , `unit_dim_id` int , `start_date` date , `end_date` date , `received_epoch` bigint , `deleted` string , `deleted_on_date_dim_id` int , `delinquency_stage_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-27/1758957004'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_delinquency_action_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-27/1758957004
- id: 868669
- processed: 1
- raw_data:
{ "action_cancelled": 9, "action_completed": 8, "action_name": 5, "action_price": 7, "action_status": 6, "company_dim_id": 15, "deleted": 22, "deleted_on_date_dim_id": 23, "delinquency_action_fact_id": 0, "delinquency_stage_dim_id": 24, "end_date": 20, "facility_dim_id": 16, "last_action_on_date_dim_id": 10, "needs_followup": 13, "needs_followup_by_user_dim_id": 14, "provider": 2, "provider_id": 1, "received_epoch": 21, "recurring_stage": 4, "resolved_on_date_dim_id": 11, "stage_applied_on_date_dim_id": 3, "start_date": 19, "tenant_dim_id": 17, "unit_dim_id": 18, "updated_by_user_dim_id": 12 } - schema_attributes:
{ "action_cancelled": "string", "action_completed": "string", "action_name": "string", "action_price": "string", "action_status": "string", "company_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "delinquency_action_fact_id": "int", "delinquency_stage_dim_id": "int", "end_date": "date", "facility_dim_id": "int", "last_action_on_date_dim_id": "int", "needs_followup": "string", "needs_followup_by_user_dim_id": "int", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "recurring_stage": "string", "resolved_on_date_dim_id": "int", "stage_applied_on_date_dim_id": "int", "start_date": "date", "tenant_dim_id": "int", "unit_dim_id": "int", "updated_by_user_dim_id": "int" } - schema_name_id: 1229
- schema_scan_id: 6326814
- updated: 2025-09-27 02:11:11
-
Version 868486
- created: 2025-09-26 01:39:59
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_delinquency_action_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_delinquency_action_fact`\n(\n `delinquency_action_fact_id` int , `provider_id` string , `provider` string , `stage_applied_on_date_dim_id` int , `recurring_stage` string , `action_name` string , `action_status` string , `action_price` string , `action_completed` string , `action_cancelled` string , `last_action_on_date_dim_id` int , `resolved_on_date_dim_id` int , `updated_by_user_dim_id` int , `needs_followup` string , `needs_followup_by_user_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `tenant_dim_id` int , `unit_dim_id` int , `start_date` date , `end_date` date , `received_epoch` bigint , `deleted` string , `deleted_on_date_dim_id` int , `delinquency_stage_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-26/1758868746'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_delinquency_action_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-26/1758868746
- id: 868486
- processed: 1
- raw_data:
{ "action_cancelled": 9, "action_completed": 8, "action_name": 5, "action_price": 7, "action_status": 6, "company_dim_id": 15, "deleted": 22, "deleted_on_date_dim_id": 23, "delinquency_action_fact_id": 0, "delinquency_stage_dim_id": 24, "end_date": 20, "facility_dim_id": 16, "last_action_on_date_dim_id": 10, "needs_followup": 13, "needs_followup_by_user_dim_id": 14, "provider": 2, "provider_id": 1, "received_epoch": 21, "recurring_stage": 4, "resolved_on_date_dim_id": 11, "stage_applied_on_date_dim_id": 3, "start_date": 19, "tenant_dim_id": 17, "unit_dim_id": 18, "updated_by_user_dim_id": 12 } - schema_attributes:
{ "action_cancelled": "string", "action_completed": "string", "action_name": "string", "action_price": "string", "action_status": "string", "company_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "delinquency_action_fact_id": "int", "delinquency_stage_dim_id": "int", "end_date": "date", "facility_dim_id": "int", "last_action_on_date_dim_id": "int", "needs_followup": "string", "needs_followup_by_user_dim_id": "int", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "recurring_stage": "string", "resolved_on_date_dim_id": "int", "stage_applied_on_date_dim_id": "int", "start_date": "date", "tenant_dim_id": "int", "unit_dim_id": "int", "updated_by_user_dim_id": "int" } - schema_name_id: 1229
- schema_scan_id: 6326458
- updated: 2025-09-26 01:40:10
-
Version 868267
- created: 2025-09-25 01:34:48
- ddl:
[ "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_delinquency_action_fact`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_delinquency_action_fact`\n(\n `delinquency_action_fact_id` int , `provider_id` string , `provider` string , `stage_applied_on_date_dim_id` int , `recurring_stage` string , `action_name` string , `action_status` string , `action_price` string , `action_completed` string , `action_cancelled` string , `last_action_on_date_dim_id` int , `resolved_on_date_dim_id` int , `updated_by_user_dim_id` int , `needs_followup` string , `needs_followup_by_user_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `tenant_dim_id` int , `unit_dim_id` int , `start_date` date , `end_date` date , `received_epoch` bigint , `deleted` string , `deleted_on_date_dim_id` int , `delinquency_stage_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-25/1758782031'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_delinquency_action_fact" ] - hive_path: s3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-25/1758782031
- id: 868267
- processed: 1
- raw_data:
{ "action_cancelled": 9, "action_completed": 8, "action_name": 5, "action_price": 7, "action_status": 6, "company_dim_id": 15, "deleted": 22, "deleted_on_date_dim_id": 23, "delinquency_action_fact_id": 0, "delinquency_stage_dim_id": 24, "end_date": 20, "facility_dim_id": 16, "last_action_on_date_dim_id": 10, "needs_followup": 13, "needs_followup_by_user_dim_id": 14, "provider": 2, "provider_id": 1, "received_epoch": 21, "recurring_stage": 4, "resolved_on_date_dim_id": 11, "stage_applied_on_date_dim_id": 3, "start_date": 19, "tenant_dim_id": 17, "unit_dim_id": 18, "updated_by_user_dim_id": 12 } - schema_attributes:
{ "action_cancelled": "string", "action_completed": "string", "action_name": "string", "action_price": "string", "action_status": "string", "company_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "delinquency_action_fact_id": "int", "delinquency_stage_dim_id": "int", "end_date": "date", "facility_dim_id": "int", "last_action_on_date_dim_id": "int", "needs_followup": "string", "needs_followup_by_user_dim_id": "int", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "recurring_stage": "string", "resolved_on_date_dim_id": "int", "stage_applied_on_date_dim_id": "int", "start_date": "date", "tenant_dim_id": "int", "unit_dim_id": "int", "updated_by_user_dim_id": "int" } - schema_name_id: 1229
- schema_scan_id: 6326034
- updated: 2025-09-25 01:34:59
Schema Scans: 3
Last at 2025-09-27 02:10:56
-
Scan 6326814
- duration: 0:00:14.859888
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6326814
- payload:
{ "datatype_dict": { "action_cancelled": "string", "action_completed": "string", "action_name": "string", "action_price": "string", "action_status": "string", "company_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "delinquency_action_fact_id": "int", "delinquency_stage_dim_id": "int", "end_date": "date", "facility_dim_id": "int", "last_action_on_date_dim_id": "int", "needs_followup": "string", "needs_followup_by_user_dim_id": "int", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "recurring_stage": "string", "resolved_on_date_dim_id": "int", "stage_applied_on_date_dim_id": "int", "start_date": "date", "tenant_dim_id": "int", "unit_dim_id": "int", "updated_by_user_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-stage", "hive_path": "s3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-27/1758957004", "key": "raw/delinquency_action_fact/2025-09-27/1758957004/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.keplernormies_delinquency_action_fact", "type": "postgres" }, "trace_context": { "parent_id": 10082384357283216392, "service_name": "kepler-normies", "span_id": 7744316667698330460, "trace_id": 10082384357283216392 } } - running: False
- schema_name_id: 1229
- start_time: 2025-09-27 02:10:56
- success: True
- trace_id: 10082384357283216392
-
Scan 6326458
- duration: 0:00:12.305707
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6326458
- payload:
{ "datatype_dict": { "action_cancelled": "string", "action_completed": "string", "action_name": "string", "action_price": "string", "action_status": "string", "company_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "delinquency_action_fact_id": "int", "delinquency_stage_dim_id": "int", "end_date": "date", "facility_dim_id": "int", "last_action_on_date_dim_id": "int", "needs_followup": "string", "needs_followup_by_user_dim_id": "int", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "recurring_stage": "string", "resolved_on_date_dim_id": "int", "stage_applied_on_date_dim_id": "int", "start_date": "date", "tenant_dim_id": "int", "unit_dim_id": "int", "updated_by_user_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-stage", "hive_path": "s3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-26/1758868746", "key": "raw/delinquency_action_fact/2025-09-26/1758868746/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.keplernormies_delinquency_action_fact", "type": "postgres" }, "trace_context": { "parent_id": 15073377532342586967, "service_name": "kepler-normies", "span_id": 15275970136779998787, "trace_id": 15073377532342586967 } } - running: False
- schema_name_id: 1229
- start_time: 2025-09-26 01:39:58
- success: True
- trace_id: 15073377532342586967
-
Scan 6326034
- duration: 0:00:12.430898
- exit_message:
{ "ddl_changed": true, "partitions_applied": false, "success": true } - id: 6326034
- payload:
{ "datatype_dict": { "action_cancelled": "string", "action_completed": "string", "action_name": "string", "action_price": "string", "action_status": "string", "company_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "delinquency_action_fact_id": "int", "delinquency_stage_dim_id": "int", "end_date": "date", "facility_dim_id": "int", "last_action_on_date_dim_id": "int", "needs_followup": "string", "needs_followup_by_user_dim_id": "int", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "recurring_stage": "string", "resolved_on_date_dim_id": "int", "stage_applied_on_date_dim_id": "int", "start_date": "date", "tenant_dim_id": "int", "unit_dim_id": "int", "updated_by_user_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-stage", "hive_path": "s3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-25/1758782031", "key": "raw/delinquency_action_fact/2025-09-25/1758782031/data_0.csv.gz" }, "schema": { "name": "sfdl_stage_postgres.keplernormies_delinquency_action_fact", "type": "postgres" }, "trace_context": { "parent_id": 15113862908879745781, "service_name": "kepler-normies", "span_id": 16753420412569283000, "trace_id": 15113862908879745781 } } - running: False
- schema_name_id: 1229
- start_time: 2025-09-25 01:34:47
- success: True
- trace_id: 15113862908879745781
- attributes:
{ "action_cancelled": "string", "action_completed": "string", "action_name": "string", "action_price": "string", "action_status": "string", "company_dim_id": "int", "deleted": "string", "deleted_on_date_dim_id": "int", "delinquency_action_fact_id": "int", "delinquency_stage_dim_id": "int", "end_date": "date", "facility_dim_id": "int", "last_action_on_date_dim_id": "int", "needs_followup": "string", "needs_followup_by_user_dim_id": "int", "provider": "string", "provider_id": "string", "received_epoch": "bigint", "recurring_stage": "string", "resolved_on_date_dim_id": "int", "stage_applied_on_date_dim_id": "int", "start_date": "date", "tenant_dim_id": "int", "unit_dim_id": "int", "updated_by_user_dim_id": "int" } - created: 2025-09-27 02:10:57
- ddl:
{ "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`", "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_delinquency_action_fact`\n(\n `delinquency_action_fact_id` int , `provider_id` string , `provider` string , `stage_applied_on_date_dim_id` int , `recurring_stage` string , `action_name` string , `action_status` string , `action_price` string , `action_completed` string , `action_cancelled` string , `last_action_on_date_dim_id` int , `resolved_on_date_dim_id` int , `updated_by_user_dim_id` int , `needs_followup` string , `needs_followup_by_user_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `tenant_dim_id` int , `unit_dim_id` int , `start_date` date , `end_date` date , `received_epoch` bigint , `deleted` string , `deleted_on_date_dim_id` int , `delinquency_stage_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-27/1758957004'\nTBLPROPERTIES ('skip.header.line.count' = '1')", "drop_table": "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_delinquency_action_fact`", "repair_table": "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_delinquency_action_fact" }
- hostname: schemamanager-5c55c886bf-h2ts4
- name: schema_manager
- process_start: 2025-10-21 13:03:27
- sf_env: stage
- version: 2112174301
{
"name": {
"created": "2022-07-29 13:48:27",
"disabled": false,
"format": "raw",
"id": 1229,
"is_partitioned": false,
"is_schema_datatyped": true,
"name": {
"database": "sfdl_stage_postgres",
"table": "keplernormies_delinquency_action_fact"
},
"type": "postgres"
},
"partition": {
"count": 0,
"ddl": null,
"name": null,
"state": [],
"type": null
},
"schema": {
"attributes": {
"action_cancelled": "string",
"action_completed": "string",
"action_name": "string",
"action_price": "string",
"action_status": "string",
"company_dim_id": "int",
"deleted": "string",
"deleted_on_date_dim_id": "int",
"delinquency_action_fact_id": "int",
"delinquency_stage_dim_id": "int",
"end_date": "date",
"facility_dim_id": "int",
"last_action_on_date_dim_id": "int",
"needs_followup": "string",
"needs_followup_by_user_dim_id": "int",
"provider": "string",
"provider_id": "string",
"received_epoch": "bigint",
"recurring_stage": "string",
"resolved_on_date_dim_id": "int",
"stage_applied_on_date_dim_id": "int",
"start_date": "date",
"tenant_dim_id": "int",
"unit_dim_id": "int",
"updated_by_user_dim_id": "int"
},
"created": "2025-09-27 02:10:57",
"ddl": {
"create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_stage_postgres`",
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_stage_postgres.keplernormies_delinquency_action_fact`\n(\n `delinquency_action_fact_id` int , `provider_id` string , `provider` string , `stage_applied_on_date_dim_id` int , `recurring_stage` string , `action_name` string , `action_status` string , `action_price` string , `action_completed` string , `action_cancelled` string , `last_action_on_date_dim_id` int , `resolved_on_date_dim_id` int , `updated_by_user_dim_id` int , `needs_followup` string , `needs_followup_by_user_dim_id` int , `company_dim_id` int , `facility_dim_id` int , `tenant_dim_id` int , `unit_dim_id` int , `start_date` date , `end_date` date , `received_epoch` bigint , `deleted` string , `deleted_on_date_dim_id` int , `delinquency_stage_dim_id` int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-postgres-keplernormies-stage/raw/delinquency_action_fact/2025-09-27/1758957004'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
"drop_table": "DROP TABLE IF EXISTS `sfdl_stage_postgres.keplernormies_delinquency_action_fact`",
"repair_table": "MSCK REPAIR TABLE sfdl_stage_postgres.keplernormies_delinquency_action_fact"
}
},
"server": {
"hostname": "schemamanager-5c55c886bf-h2ts4",
"name": "schema_manager",
"process_start": "2025-10-21 13:03:27",
"sf_env": "stage",
"version": "2112174301"
}
}