Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_company_dim

created: 2019-02-12 04:46:23
disabled: False
format: raw
id: 626
is_partitioned: False
is_schema_datatyped: True

name:

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

type: postgres

Schema Versions: 15

Version 1717496

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-17/1776405297'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-17/1776405297
id: 1717496
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 162163965
updated: 2026-04-17 00:55:20

Version 1716265

created: 2026-04-16 01:04:18

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-16/1776319450'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-16/1776319450
id: 1716265
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 162109245
updated: 2026-04-16 01:04:32

Version 1715078

created: 2026-04-15 01:07:33

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-15/1776233249'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-15/1776233249
id: 1715078
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 162053398
updated: 2026-04-15 01:07:46

Version 1713888

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-14/1776146478'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-14/1776146478
id: 1713888
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161997607
updated: 2026-04-14 01:03:10

Version 1712638

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-13/1776060209'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-13/1776060209
id: 1712638
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161940024
updated: 2026-04-13 01:03:50

Version 1711441

created: 2026-04-12 01:01:26

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-12/1775973552'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-12/1775973552
id: 1711441
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161890231
updated: 2026-04-12 01:01:37

Version 1710263

created: 2026-04-11 01:04:39

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-11/1775887475'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-11/1775887475
id: 1710263
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161838656
updated: 2026-04-11 01:04:53

Version 1709095

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-10/1775800917'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-10/1775800917
id: 1709095
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161782990
updated: 2026-04-10 01:02:15

Version 1707947

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-09/1775714059'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-09/1775714059
id: 1707947
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161726732
updated: 2026-04-09 00:54:45

Version 1706751

created: 2026-04-08 01:09:30

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-08/1775628560'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-08/1775628560
id: 1706751
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161672800
updated: 2026-04-08 01:09:44

Version 1705556

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-07/1775541745'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-07/1775541745
id: 1705556
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161616660
updated: 2026-04-07 01:02:50

Version 1704331

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-06/1775455340'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-06/1775455340
id: 1704331
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161558728
updated: 2026-04-06 01:03:24

Version 1703140

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-05/1775368407'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-05/1775368407
id: 1703140
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161511112
updated: 2026-04-05 00:53:51

Version 1701971

created: 2026-04-04 00:51:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-04/1775281910'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-04/1775281910
id: 1701971
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161455900
updated: 2026-04-04 00:52:07

Version 1700753

created: 2026-04-03 01:00:16

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-03/1775195926'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-03/1775195926
id: 1700753
processed: 1

raw_data:

{
    "business_phone": 10,
    "company_dim_id": 0,
    "company_name": 3,
    "contact_email": 8,
    "contact_first": 6,
    "contact_last": 7,
    "contact_phone": 9,
    "customer_number": 4,
    "customer_since": 5,
    "deleted": 12,
    "google_analytics_id": 17,
    "migrated_on": 13,
    "notes": 11,
    "provider": 2,
    "provider_id": 1,
    "received_epoch": 16,
    "type": 14,
    "url": 15
}

schema_attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

schema_name_id: 626
schema_scan_id: 161398086
updated: 2026-04-03 01:00:30

Schema Scans: 15

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

Scan 162163965

duration: 0:00:12.135924

exit_message:

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

id: 162163965

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-17/1776405297",
        "key": "raw/company_dim/2026-04-17/1776405297/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 18349999783177530136,
        "service_name": "kepler-normies",
        "span_id": 12836876201731246137,
        "trace_id": 18349999783177530136
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-17 00:55:08
success: True
trace_id: 18349999783177530136

Scan 162109245

duration: 0:00:14.706825

exit_message:

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

id: 162109245

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-16/1776319450",
        "key": "raw/company_dim/2026-04-16/1776319450/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5478832995485956421,
        "service_name": "kepler-normies",
        "span_id": 705273168619266634,
        "trace_id": 5478832995485956421
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-16 01:04:17
success: True
trace_id: 5478832995485956421

Scan 162053398

duration: 0:00:14.605788

exit_message:

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

id: 162053398

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-15/1776233249",
        "key": "raw/company_dim/2026-04-15/1776233249/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 16963340591936688727,
        "service_name": "kepler-normies",
        "span_id": 13788365162127151105,
        "trace_id": 16963340591936688727
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-15 01:07:32
success: True
trace_id: 16963340591936688727

Scan 161997607

duration: 0:00:12.016520

exit_message:

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

id: 161997607

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-14/1776146478",
        "key": "raw/company_dim/2026-04-14/1776146478/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2421743797503243280,
        "service_name": "kepler-normies",
        "span_id": 1607519495074365149,
        "trace_id": 2421743797503243280
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-14 01:02:58
success: True
trace_id: 2421743797503243280

Scan 161940024

duration: 0:00:12.119649

exit_message:

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

id: 161940024

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-13/1776060209",
        "key": "raw/company_dim/2026-04-13/1776060209/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9496661058953712309,
        "service_name": "kepler-normies",
        "span_id": 3467779299107407376,
        "trace_id": 9496661058953712309
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-13 01:03:38
success: True
trace_id: 9496661058953712309

Scan 161890231

duration: 0:00:12.050464

exit_message:

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

id: 161890231

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-12/1775973552",
        "key": "raw/company_dim/2026-04-12/1775973552/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2775647078644782309,
        "service_name": "kepler-normies",
        "span_id": 11740952062289692144,
        "trace_id": 2775647078644782309
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-12 01:01:25
success: True
trace_id: 2775647078644782309

Scan 161838656

duration: 0:00:14.468949

exit_message:

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

id: 161838656

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-11/1775887475",
        "key": "raw/company_dim/2026-04-11/1775887475/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 14360020689996015970,
        "service_name": "kepler-normies",
        "span_id": 6965004227526218159,
        "trace_id": 14360020689996015970
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-11 01:04:38
success: True
trace_id: 14360020689996015970

Scan 161782990

duration: 0:00:14.634300

exit_message:

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

id: 161782990

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-10/1775800917",
        "key": "raw/company_dim/2026-04-10/1775800917/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1127064353351621768,
        "service_name": "kepler-normies",
        "span_id": 4828230838538364734,
        "trace_id": 1127064353351621768
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-10 01:02:01
success: True
trace_id: 1127064353351621768

Scan 161726732

duration: 0:00:14.649508

exit_message:

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

id: 161726732

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-09/1775714059",
        "key": "raw/company_dim/2026-04-09/1775714059/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8231566742266180699,
        "service_name": "kepler-normies",
        "span_id": 8971865455060776431,
        "trace_id": 8231566742266180699
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-09 00:54:30
success: True
trace_id: 8231566742266180699

Scan 161672800

duration: 0:00:14.715649

exit_message:

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

id: 161672800

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-08/1775628560",
        "key": "raw/company_dim/2026-04-08/1775628560/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1059035349708068183,
        "service_name": "kepler-normies",
        "span_id": 6771643578377567788,
        "trace_id": 1059035349708068183
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-08 01:09:29
success: True
trace_id: 1059035349708068183

Scan 161616660

duration: 0:00:12.316039

exit_message:

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

id: 161616660

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-07/1775541745",
        "key": "raw/company_dim/2026-04-07/1775541745/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5345903452969695403,
        "service_name": "kepler-normies",
        "span_id": 3434100705920301917,
        "trace_id": 5345903452969695403
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-07 01:02:38
success: True
trace_id: 5345903452969695403

Scan 161558728

duration: 0:00:14.630848

exit_message:

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

id: 161558728

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-06/1775455340",
        "key": "raw/company_dim/2026-04-06/1775455340/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1746711846426258939,
        "service_name": "kepler-normies",
        "span_id": 12138879570027373293,
        "trace_id": 1746711846426258939
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-06 01:03:09
success: True
trace_id: 1746711846426258939

Scan 161511112

duration: 0:00:14.697168

exit_message:

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

id: 161511112

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-05/1775368407",
        "key": "raw/company_dim/2026-04-05/1775368407/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2567646896972077446,
        "service_name": "kepler-normies",
        "span_id": 10600147837599637299,
        "trace_id": 2567646896972077446
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-05 00:53:36
success: True
trace_id: 2567646896972077446

Scan 161455900

duration: 0:00:14.527270

exit_message:

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

id: 161455900

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-04/1775281910",
        "key": "raw/company_dim/2026-04-04/1775281910/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 13972798690139802790,
        "service_name": "kepler-normies",
        "span_id": 15404781673922509144,
        "trace_id": 13972798690139802790
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-04 00:51:53
success: True
trace_id: 13972798690139802790

Scan 161398086

duration: 0:00:14.715683

exit_message:

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

id: 161398086

payload:

{
    "datatype_dict": {
        "business_phone": "string",
        "company_dim_id": "int",
        "company_name": "string",
        "contact_email": "string",
        "contact_first": "string",
        "contact_last": "string",
        "contact_phone": "string",
        "customer_number": "string",
        "customer_since": "string",
        "deleted": "string",
        "google_analytics_id": "string",
        "migrated_on": "string",
        "notes": "string",
        "provider": "string",
        "provider_id": "string",
        "received_epoch": "bigint",
        "type": "string",
        "url": "string"
    },
    "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/company_dim/2026-04-03/1775195926",
        "key": "raw/company_dim/2026-04-03/1775195926/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_company_dim",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9943489649885952351,
        "service_name": "kepler-normies",
        "span_id": 9595303839288846617,
        "trace_id": 9943489649885952351
    }
}

running: False
schema_name_id: 626
start_time: 2026-04-03 01:00:15
success: True
trace_id: 9943489649885952351

Partitions:

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

Schema:

attributes:

{
    "business_phone": "string",
    "company_dim_id": "int",
    "company_name": "string",
    "contact_email": "string",
    "contact_first": "string",
    "contact_last": "string",
    "contact_phone": "string",
    "customer_number": "string",
    "customer_since": "string",
    "deleted": "string",
    "google_analytics_id": "string",
    "migrated_on": "string",
    "notes": "string",
    "provider": "string",
    "provider_id": "string",
    "received_epoch": "bigint",
    "type": "string",
    "url": "string"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-17/1776405297'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
}

Server:

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

Raw:

{
    "name": {
        "created": "2019-02-12 04:46:23",
        "disabled": false,
        "format": "raw",
        "id": 626,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_company_dim"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "business_phone": "string",
            "company_dim_id": "int",
            "company_name": "string",
            "contact_email": "string",
            "contact_first": "string",
            "contact_last": "string",
            "contact_phone": "string",
            "customer_number": "string",
            "customer_since": "string",
            "deleted": "string",
            "google_analytics_id": "string",
            "migrated_on": "string",
            "notes": "string",
            "provider": "string",
            "provider_id": "string",
            "received_epoch": "bigint",
            "type": "string",
            "url": "string"
        },
        "created": "2026-04-17 00:55:09",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_company_dim`\n(\n `company_dim_id`  int , `provider_id`  string , `provider`  string , `company_name`  string , `customer_number`  string , `customer_since`  string , `contact_first`  string , `contact_last`  string , `contact_email`  string , `contact_phone`  string , `business_phone`  string , `notes`  string , `deleted`  string , `migrated_on`  string , `type`  string , `url`  string , `received_epoch`  bigint , `google_analytics_id`  string \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/company_dim/2026-04-17/1776405297'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_company_dim`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_company_dim"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}