Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_web_view_monthly_fact

created: 2019-10-31 03:16:17
disabled: False
format: raw
id: 752
is_partitioned: False
is_schema_datatyped: True

name:

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

type: postgres

Schema Versions: 15

Version 1717499

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-17/1776405287'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-17/1776405287
id: 1717499
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 162163974
updated: 2026-04-17 00:55:30

Version 1716266

created: 2026-04-16 01:04:19

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-16/1776319450'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

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

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 162109246
updated: 2026-04-16 01:04:33

Version 1715073

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-15/1776233214'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-15/1776233214
id: 1715073
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 162053390
updated: 2026-04-15 01:07:15

Version 1713881

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-14/1776146537'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-14/1776146537
id: 1713881
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161997586
updated: 2026-04-14 01:02:46

Version 1712640

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-13/1776060219'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-13/1776060219
id: 1712640
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161940030
updated: 2026-04-13 01:03:58

Version 1711454

created: 2026-04-12 01:03:03

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-12/1775973583'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-12/1775973583
id: 1711454
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161890424
updated: 2026-04-12 01:03:14

Version 1710256

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-11/1775887440'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-11/1775887440
id: 1710256
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161838647
updated: 2026-04-11 01:04:15

Version 1709108

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-10/1775800959'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-10/1775800959
id: 1709108
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161783074
updated: 2026-04-10 01:03:17

Version 1707948

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-09/1775714063'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-09/1775714063
id: 1707948
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161726734
updated: 2026-04-09 00:54:47

Version 1706743

created: 2026-04-08 01:08:24

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-08/1775628498'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-08/1775628498
id: 1706743
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161672791
updated: 2026-04-08 01:08:38

Version 1705560

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

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-07/1775541737'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-07/1775541737
id: 1705560
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161616678
updated: 2026-04-07 01:03:02

Version 1704344

created: 2026-04-06 01:04:02

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-06/1775455289'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-06/1775455289
id: 1704344
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161558803
updated: 2026-04-06 01:04:13

Version 1703152

created: 2026-04-05 00:54:54

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-05/1775368472'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-05/1775368472
id: 1703152
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161511151
updated: 2026-04-05 00:55:05

Version 1701963

created: 2026-04-04 00:51:17

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-04/1775281865'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-04/1775281865
id: 1701963
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161455880
updated: 2026-04-04 00:51:31

Version 1700764

created: 2026-04-03 01:03:15

ddl:

[
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-03/1775195995'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
]

hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-03/1775195995
id: 1700764
processed: 1

raw_data:

{
    "company_dim_id": 11,
    "date_dim_id": 13,
    "desktop_sessions": 7,
    "desktop_users": 8,
    "facility_dim_id": 12,
    "mobile_sessions": 9,
    "mobile_users": 10,
    "new_users": 4,
    "page_views": 1,
    "pages_per_session": 6,
    "sessions": 5,
    "unique_page_views": 2,
    "users": 3,
    "web_view_monthly_fact_id": 0
}

schema_attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

schema_name_id: 752
schema_scan_id: 161398505
updated: 2026-04-03 01:03:29

Schema Scans: 15

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

Scan 162163974

duration: 0:00:12.077825

exit_message:

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

id: 162163974

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-17/1776405287",
        "key": "raw/web_view_monthly_fact/2026-04-17/1776405287/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 7023051985785362595,
        "service_name": "kepler-normies",
        "span_id": 2549528606833913258,
        "trace_id": 7023051985785362595
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-17 00:55:18
success: True
trace_id: 7023051985785362595

Scan 162109246

duration: 0:00:14.642892

exit_message:

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

id: 162109246

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-16/1776319450",
        "key": "raw/web_view_monthly_fact/2026-04-16/1776319450/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17086830356568543690,
        "service_name": "kepler-normies",
        "span_id": 2115280251470033350,
        "trace_id": 17086830356568543690
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-16 01:04:18
success: True
trace_id: 17086830356568543690

Scan 162053390

duration: 0:00:14.589240

exit_message:

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

id: 162053390

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-15/1776233214",
        "key": "raw/web_view_monthly_fact/2026-04-15/1776233214/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3731541761169387934,
        "service_name": "kepler-normies",
        "span_id": 3046260534311545010,
        "trace_id": 3731541761169387934
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-15 01:07:01
success: True
trace_id: 3731541761169387934

Scan 161997586

duration: 0:00:14.481897

exit_message:

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

id: 161997586

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-14/1776146537",
        "key": "raw/web_view_monthly_fact/2026-04-14/1776146537/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17731423346315334995,
        "service_name": "kepler-normies",
        "span_id": 5241571222855852095,
        "trace_id": 17731423346315334995
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-14 01:02:31
success: True
trace_id: 17731423346315334995

Scan 161940030

duration: 0:00:14.595448

exit_message:

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

id: 161940030

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-13/1776060219",
        "key": "raw/web_view_monthly_fact/2026-04-13/1776060219/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2763786415198785482,
        "service_name": "kepler-normies",
        "span_id": 15952282381482889573,
        "trace_id": 2763786415198785482
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-13 01:03:44
success: True
trace_id: 2763786415198785482

Scan 161890424

duration: 0:00:11.945325

exit_message:

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

id: 161890424

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-12/1775973583",
        "key": "raw/web_view_monthly_fact/2026-04-12/1775973583/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9922781708997553488,
        "service_name": "kepler-normies",
        "span_id": 14037778516324482883,
        "trace_id": 9922781708997553488
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-12 01:03:02
success: True
trace_id: 9922781708997553488

Scan 161838647

duration: 0:00:12.003263

exit_message:

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

id: 161838647

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-11/1775887440",
        "key": "raw/web_view_monthly_fact/2026-04-11/1775887440/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 6716755688618433594,
        "service_name": "kepler-normies",
        "span_id": 11910332960319300319,
        "trace_id": 6716755688618433594
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-11 01:04:03
success: True
trace_id: 6716755688618433594

Scan 161783074

duration: 0:00:14.516780

exit_message:

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

id: 161783074

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-10/1775800959",
        "key": "raw/web_view_monthly_fact/2026-04-10/1775800959/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2726068571739723716,
        "service_name": "kepler-normies",
        "span_id": 8556529032662413904,
        "trace_id": 2726068571739723716
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-10 01:03:03
success: True
trace_id: 2726068571739723716

Scan 161726734

duration: 0:00:14.610496

exit_message:

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

id: 161726734

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-09/1775714063",
        "key": "raw/web_view_monthly_fact/2026-04-09/1775714063/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 4899971591158139608,
        "service_name": "kepler-normies",
        "span_id": 4054072262721906617,
        "trace_id": 4899971591158139608
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-09 00:54:32
success: True
trace_id: 4899971591158139608

Scan 161672791

duration: 0:00:14.536275

exit_message:

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

id: 161672791

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-08/1775628498",
        "key": "raw/web_view_monthly_fact/2026-04-08/1775628498/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2600107921085054299,
        "service_name": "kepler-normies",
        "span_id": 16980055972653729868,
        "trace_id": 2600107921085054299
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-08 01:08:24
success: True
trace_id: 2600107921085054299

Scan 161616678

duration: 0:00:14.500519

exit_message:

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

id: 161616678

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-07/1775541737",
        "key": "raw/web_view_monthly_fact/2026-04-07/1775541737/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15463253701915587396,
        "service_name": "kepler-normies",
        "span_id": 14400641919017201257,
        "trace_id": 15463253701915587396
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-07 01:02:48
success: True
trace_id: 15463253701915587396

Scan 161558803

duration: 0:00:12.034238

exit_message:

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

id: 161558803

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-06/1775455289",
        "key": "raw/web_view_monthly_fact/2026-04-06/1775455289/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 654495901021685704,
        "service_name": "kepler-normies",
        "span_id": 7953939742040138145,
        "trace_id": 654495901021685704
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-06 01:04:01
success: True
trace_id: 654495901021685704

Scan 161511151

duration: 0:00:11.921984

exit_message:

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

id: 161511151

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-05/1775368472",
        "key": "raw/web_view_monthly_fact/2026-04-05/1775368472/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 5886103106407770343,
        "service_name": "kepler-normies",
        "span_id": 3445349228751636890,
        "trace_id": 5886103106407770343
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-05 00:54:53
success: True
trace_id: 5886103106407770343

Scan 161455880

duration: 0:00:14.502843

exit_message:

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

id: 161455880

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-04/1775281865",
        "key": "raw/web_view_monthly_fact/2026-04-04/1775281865/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1088478607844409795,
        "service_name": "kepler-normies",
        "span_id": 3774816435330251820,
        "trace_id": 1088478607844409795
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-04 00:51:17
success: True
trace_id: 1088478607844409795

Scan 161398505

duration: 0:00:14.694450

exit_message:

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

id: 161398505

payload:

{
    "datatype_dict": {
        "company_dim_id": "int",
        "date_dim_id": "int",
        "desktop_sessions": "int",
        "desktop_users": "int",
        "facility_dim_id": "int",
        "mobile_sessions": "int",
        "mobile_users": "int",
        "new_users": "int",
        "page_views": "int",
        "pages_per_session": "int",
        "sessions": "int",
        "unique_page_views": "int",
        "users": "int",
        "web_view_monthly_fact_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/web_view_monthly_fact/2026-04-03/1775195995",
        "key": "raw/web_view_monthly_fact/2026-04-03/1775195995/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_monthly_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 1410497664825385621,
        "service_name": "kepler-normies",
        "span_id": 13477850406438440057,
        "trace_id": 1410497664825385621
    }
}

running: False
schema_name_id: 752
start_time: 2026-04-03 01:03:14
success: True
trace_id: 1410497664825385621

Partitions:

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

Schema:

attributes:

{
    "company_dim_id": "int",
    "date_dim_id": "int",
    "desktop_sessions": "int",
    "desktop_users": "int",
    "facility_dim_id": "int",
    "mobile_sessions": "int",
    "mobile_users": "int",
    "new_users": "int",
    "page_views": "int",
    "pages_per_session": "int",
    "sessions": "int",
    "unique_page_views": "int",
    "users": "int",
    "web_view_monthly_fact_id": "int"
}

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

ddl:

{
    "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-17/1776405287'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_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": "2019-10-31 03:16:17",
        "disabled": false,
        "format": "raw",
        "id": 752,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_web_view_monthly_fact"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "company_dim_id": "int",
            "date_dim_id": "int",
            "desktop_sessions": "int",
            "desktop_users": "int",
            "facility_dim_id": "int",
            "mobile_sessions": "int",
            "mobile_users": "int",
            "new_users": "int",
            "page_views": "int",
            "pages_per_session": "int",
            "sessions": "int",
            "unique_page_views": "int",
            "users": "int",
            "web_view_monthly_fact_id": "int"
        },
        "created": "2026-04-17 00:55:18",
        "ddl": {
            "create_database": "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
            "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_monthly_fact`\n(\n `web_view_monthly_fact_id`  int , `page_views`  int , `unique_page_views`  int , `users`  int , `new_users`  int , `sessions`  int , `pages_per_session`  int , `desktop_sessions`  int , `desktop_users`  int , `mobile_sessions`  int , `mobile_users`  int , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int \n)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'field.delim' = '\u0001', 'quote.delim' = '\"', 'escape.delim' = '\\\\')\nSTORED AS INPUTFORMAT\n  'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n  'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n  's3://sfdl-postgres-keplernormies-prod/raw/web_view_monthly_fact/2026-04-17/1776405287'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_monthly_fact`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_monthly_fact"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}