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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state:
    []
  • type: None
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
Raw:
{
    "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"
    }
}