Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_auction_fact

created: 2022-05-05 01:11:34
disabled: False
format: raw
id: 972
is_partitioned: False
is_schema_datatyped: True

name:

{
    "database": "sfdl_prod_postgres",
    "table": "keplernormies_auction_fact"
}

type: postgres

Schema Versions: 15

Version 1717495

created: 2026-04-17 00:55:08

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-17/1776405291'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-17/1776405291
id: 1717495
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 162163962
updated: 2026-04-17 00:55:19

Version 1716272

created: 2026-04-16 01:04:46

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-16/1776319483'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-16/1776319483
id: 1716272
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 162109254
updated: 2026-04-16 01:05:00

Version 1715085

created: 2026-04-15 01:08:21

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-15/1776233291'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-15/1776233291
id: 1715085
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 162053412
updated: 2026-04-15 01:08:32

Version 1713870

created: 2026-04-14 01:01:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-14/1776146467'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-14/1776146467
id: 1713870
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161997494
updated: 2026-04-14 01:01:26

Version 1712641

created: 2026-04-13 01:03:49

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-13/1776060222'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-13/1776060222
id: 1712641
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161940032
updated: 2026-04-13 01:04:03

Version 1711447

created: 2026-04-12 01:02:04

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-12/1775973534'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-12/1775973534
id: 1711447
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161890310
updated: 2026-04-12 01:02:16

Version 1710254

created: 2026-04-11 01:03:58

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-11/1775887424'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-11/1775887424
id: 1710254
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161838645
updated: 2026-04-11 01:04:10

Version 1709102

created: 2026-04-10 01:02:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-10/1775800956'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-10/1775800956
id: 1709102
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161783041
updated: 2026-04-10 01:02:51

Version 1707945

created: 2026-04-09 00:54:12

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-09/1775714048'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-09/1775714048
id: 1707945
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161726718
updated: 2026-04-09 00:54:23

Version 1706742

created: 2026-04-08 01:08:11

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-08/1775628487'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-08/1775628487
id: 1706742
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161672788
updated: 2026-04-08 01:08:23

Version 1705563

created: 2026-04-07 01:02:57

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-07/1775541733'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-07/1775541733
id: 1705563
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161616687
updated: 2026-04-07 01:03:10

Version 1704334

created: 2026-04-06 01:03:25

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-06/1775455285'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-06/1775455285
id: 1704334
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161558757
updated: 2026-04-06 01:03:39

Version 1703137

created: 2026-04-05 00:53:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-05/1775368387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-05/1775368387
id: 1703137
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161511106
updated: 2026-04-05 00:53:27

Version 1701969

created: 2026-04-04 00:51:50

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-04/1775281907'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-04/1775281907
id: 1701969
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161455896
updated: 2026-04-04 00:52:04

Version 1700759

created: 2026-04-03 01:02:14

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-03/1775195969'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-03/1775195969
id: 1700759
processed: 1

raw_data:

{
    "amount_owed": 7,
    "auction_at_date": 8,
    "auction_commission": 9,
    "auction_fact_id": 0,
    "bid_amount": 10,
    "bid_payment_voided": 22,
    "bid_payment_voided_on": 23,
    "bid_winner": 11,
    "company_dim_id": 3,
    "created_at_date_dim_id": 16,
    "deleted": 12,
    "deleted_on_date_dim_id": 13,
    "effective_on_date_dim_id": 14,
    "facility_dim_id": 4,
    "ledger_provider_id": 18,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 19,
    "resolved_on_date_dim_id": 15,
    "status": 21,
    "tax_amount": 20,
    "tenant_dim_id": 5,
    "unit_dim_id": 6,
    "updated_at_date_dim_id": 17
}

schema_attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

schema_name_id: 972
schema_scan_id: 161398387
updated: 2026-04-03 01:02:25

Schema Scans: 15

Last at 2026-04-17 00:55:07

Scan 162163962

duration: 0:00:12.310555

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162163962

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-17/1776405291",
        "key": "raw/auction_fact/2026-04-17/1776405291/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17956650495773003862,
        "service_name": "kepler-normies",
        "span_id": 1045730703332447052,
        "trace_id": 17956650495773003862
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-17 00:55:07
success: True
trace_id: 17956650495773003862

Scan 162109254

duration: 0:00:14.910167

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162109254

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-16/1776319483",
        "key": "raw/auction_fact/2026-04-16/1776319483/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2270858262917326450,
        "service_name": "kepler-normies",
        "span_id": 4829469912527500180,
        "trace_id": 2270858262917326450
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-16 01:04:45
success: True
trace_id: 2270858262917326450

Scan 162053412

duration: 0:00:12.234644

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 162053412

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-15/1776233291",
        "key": "raw/auction_fact/2026-04-15/1776233291/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17097915601920465318,
        "service_name": "kepler-normies",
        "span_id": 3818752360742804545,
        "trace_id": 17097915601920465318
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-15 01:08:20
success: True
trace_id: 17097915601920465318

Scan 161997494

duration: 0:00:12.269474

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161997494

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-14/1776146467",
        "key": "raw/auction_fact/2026-04-14/1776146467/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3628192382138675339,
        "service_name": "kepler-normies",
        "span_id": 6833435900020920793,
        "trace_id": 3628192382138675339
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-14 01:01:14
success: True
trace_id: 3628192382138675339

Scan 161940032

duration: 0:00:14.839332

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161940032

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-13/1776060222",
        "key": "raw/auction_fact/2026-04-13/1776060222/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3840655888209094184,
        "service_name": "kepler-normies",
        "span_id": 6290908697031802981,
        "trace_id": 3840655888209094184
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-13 01:03:48
success: True
trace_id: 3840655888209094184

Scan 161890310

duration: 0:00:12.377508

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161890310

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-12/1775973534",
        "key": "raw/auction_fact/2026-04-12/1775973534/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 10397242568977838294,
        "service_name": "kepler-normies",
        "span_id": 7801948365286407828,
        "trace_id": 10397242568977838294
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-12 01:02:03
success: True
trace_id: 10397242568977838294

Scan 161838645

duration: 0:00:12.330530

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161838645

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-11/1775887424",
        "key": "raw/auction_fact/2026-04-11/1775887424/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 10358418876748240010,
        "service_name": "kepler-normies",
        "span_id": 10962846874065121155,
        "trace_id": 10358418876748240010
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-11 01:03:57
success: True
trace_id: 10358418876748240010

Scan 161783041

duration: 0:00:12.284518

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161783041

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-10/1775800956",
        "key": "raw/auction_fact/2026-04-10/1775800956/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 6484910964372997730,
        "service_name": "kepler-normies",
        "span_id": 8564811523717991622,
        "trace_id": 6484910964372997730
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-10 01:02:38
success: True
trace_id: 6484910964372997730

Scan 161726718

duration: 0:00:12.383383

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161726718

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-09/1775714048",
        "key": "raw/auction_fact/2026-04-09/1775714048/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15771108829936023539,
        "service_name": "kepler-normies",
        "span_id": 321350345701018091,
        "trace_id": 15771108829936023539
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-09 00:54:11
success: True
trace_id: 15771108829936023539

Scan 161672788

duration: 0:00:12.339067

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161672788

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-08/1775628487",
        "key": "raw/auction_fact/2026-04-08/1775628487/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 13897221242264400475,
        "service_name": "kepler-normies",
        "span_id": 4986199871504264208,
        "trace_id": 13897221242264400475
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-08 01:08:10
success: True
trace_id: 13897221242264400475

Scan 161616687

duration: 0:00:14.913201

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161616687

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-07/1775541733",
        "key": "raw/auction_fact/2026-04-07/1775541733/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9673915204012008657,
        "service_name": "kepler-normies",
        "span_id": 16534495689479244339,
        "trace_id": 9673915204012008657
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-07 01:02:56
success: True
trace_id: 9673915204012008657

Scan 161558757

duration: 0:00:14.746532

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161558757

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-06/1775455285",
        "key": "raw/auction_fact/2026-04-06/1775455285/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17468678332247419911,
        "service_name": "kepler-normies",
        "span_id": 16400951638546373850,
        "trace_id": 17468678332247419911
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-06 01:03:24
success: True
trace_id: 17468678332247419911

Scan 161511106

duration: 0:00:12.245582

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161511106

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-05/1775368387",
        "key": "raw/auction_fact/2026-04-05/1775368387/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5548609051647476014,
        "service_name": "kepler-normies",
        "span_id": 2773264301863655594,
        "trace_id": 5548609051647476014
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-05 00:53:15
success: True
trace_id: 5548609051647476014

Scan 161455896

duration: 0:00:14.719978

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161455896

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-04/1775281907",
        "key": "raw/auction_fact/2026-04-04/1775281907/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5206218797766210402,
        "service_name": "kepler-normies",
        "span_id": 7639698032824565679,
        "trace_id": 5206218797766210402
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-04 00:51:49
success: True
trace_id: 5206218797766210402

Scan 161398387

duration: 0:00:12.426898

exit_message:

{
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}

id: 161398387

payload:

{
    "datatype_dict": {
        "amount_owed": "decimal",
        "auction_at_date": "int",
        "auction_commission": "decimal",
        "auction_fact_id": "bigint",
        "bid_amount": "decimal",
        "bid_payment_voided": "string",
        "bid_payment_voided_on": "int",
        "bid_winner": "string",
        "company_dim_id": "int",
        "created_at_date_dim_id": "int",
        "deleted": "string",
        "deleted_on_date_dim_id": "int",
        "effective_on_date_dim_id": "int",
        "facility_dim_id": "int",
        "ledger_provider_id": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "resolved_on_date_dim_id": "int",
        "status": "string",
        "tax_amount": "decimal",
        "tenant_dim_id": "int",
        "unit_dim_id": "int",
        "updated_at_date_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/auction_fact/2026-04-03/1775195969",
        "key": "raw/auction_fact/2026-04-03/1775195969/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_auction_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 7120004934394125640,
        "service_name": "kepler-normies",
        "span_id": 1854625917781452556,
        "trace_id": 7120004934394125640
    }
}

running: False
schema_name_id: 972
start_time: 2026-04-03 01:02:13
success: True
trace_id: 7120004934394125640

Partitions:

count: 0
ddl: None
name: None
state:
```
[]
```
type: None

Schema:

attributes:

{
    "amount_owed": "decimal",
    "auction_at_date": "int",
    "auction_commission": "decimal",
    "auction_fact_id": "bigint",
    "bid_amount": "decimal",
    "bid_payment_voided": "string",
    "bid_payment_voided_on": "int",
    "bid_winner": "string",
    "company_dim_id": "int",
    "created_at_date_dim_id": "int",
    "deleted": "string",
    "deleted_on_date_dim_id": "int",
    "effective_on_date_dim_id": "int",
    "facility_dim_id": "int",
    "ledger_provider_id": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "resolved_on_date_dim_id": "int",
    "status": "string",
    "tax_amount": "decimal",
    "tenant_dim_id": "int",
    "unit_dim_id": "int",
    "updated_at_date_dim_id": "int"
}

created: 2026-04-17 00:55:08

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-17/1776405291'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
}

Server:

hostname: schemamanager-5475496c57-7dpqb
name: schema_manager
process_start: 2026-01-09 11:27:47
sf_env: prod
version: 2112174301

Raw:

{
    "name": {
        "created": "2022-05-05 01:11:34",
        "disabled": false,
        "format": "raw",
        "id": 972,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_auction_fact"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "amount_owed": "decimal",
            "auction_at_date": "int",
            "auction_commission": "decimal",
            "auction_fact_id": "bigint",
            "bid_amount": "decimal",
            "bid_payment_voided": "string",
            "bid_payment_voided_on": "int",
            "bid_winner": "string",
            "company_dim_id": "int",
            "created_at_date_dim_id": "int",
            "deleted": "string",
            "deleted_on_date_dim_id": "int",
            "effective_on_date_dim_id": "int",
            "facility_dim_id": "int",
            "ledger_provider_id": "string",
            "provider": "string",
            "provider_id": "string",
            "received_epoch": "bigint",
            "resolved_on_date_dim_id": "int",
            "status": "string",
            "tax_amount": "decimal",
            "tenant_dim_id": "int",
            "unit_dim_id": "int",
            "updated_at_date_dim_id": "int"
        },
        "created": "2026-04-17 00:55:08",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_auction_fact`\n(\n `auction_fact_id`  bigint , `provider_id`  string , `provider`  string , `company_dim_id`  int , `facility_dim_id`  int , `tenant_dim_id`  int , `unit_dim_id`  int , `amount_owed`  decimal , `auction_at_date`  int , `auction_commission`  decimal , `bid_amount`  decimal , `bid_winner`  string , `deleted`  string , `deleted_on_date_dim_id`  int , `effective_on_date_dim_id`  int , `resolved_on_date_dim_id`  int , `created_at_date_dim_id`  int , `updated_at_date_dim_id`  int , `ledger_provider_id`  string , `received_epoch`  bigint , `tax_amount`  decimal , `status`  string , `bid_payment_voided`  string , `bid_payment_voided_on`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/auction_fact/2026-04-17/1776405291'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_auction_fact`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_auction_fact"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}