Schema Info

Schema Name: sfdl_prod_postgres.keplernormies_web_view_fact
  • created: 2019-01-29 18:12:01
  • disabled: False
  • format: raw
  • id: 615
  • is_partitioned: False
  • is_schema_datatyped: True
  • name: 
    {
    "database": "sfdl_prod_postgres",
    "table": "keplernormies_web_view_fact"
}
  • type: postgres
Schema Versions: 15
    • created: 2026-04-17 01:14:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-17/1776406387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-17/1776406387
    • id: 1717521
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 162165053
    • updated: 2026-04-17 01:14:20
    • created: 2026-04-16 01:16:38
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-16/1776320136'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-16/1776320136
    • id: 1716284
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 162109285
    • updated: 2026-04-16 01:16:49
    • created: 2026-04-15 01:19:45
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-15/1776233913'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-15/1776233913
    • id: 1715092
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 162053428
    • updated: 2026-04-15 01:19:59
    • created: 2026-04-14 01:10:52
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-14/1776146983'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-14/1776146983
    • id: 1713899
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161997633
    • updated: 2026-04-14 01:11:05
    • created: 2026-04-13 01:12:51
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-13/1776060714'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-13/1776060714
    • id: 1712663
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161940079
    • updated: 2026-04-13 01:13:05
    • created: 2026-04-12 01:08:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-12/1775974049'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-12/1775974049
    • id: 1711460
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161890552
    • updated: 2026-04-12 01:08:35
    • created: 2026-04-11 01:16:28
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-11/1775888117'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-11/1775888117
    • id: 1710269
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161838676
    • updated: 2026-04-11 01:16:42
    • created: 2026-04-10 01:22:22
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-10/1775802073'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-10/1775802073
    • id: 1709119
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161783152
    • updated: 2026-04-10 01:22:36
    • created: 2026-04-09 01:22:24
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-09/1775715671'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-09/1775715671
    • id: 1707975
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161727980
    • updated: 2026-04-09 01:22:35
    • created: 2026-04-08 01:14:08
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-08/1775628791'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-08/1775628791
    • id: 1706765
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161672817
    • updated: 2026-04-08 01:14:20
    • created: 2026-04-07 01:10:56
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-07/1775542193'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-07/1775542193
    • id: 1705578
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161616739
    • updated: 2026-04-07 01:11:10
    • created: 2026-04-06 01:20:19
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-06/1775456357'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-06/1775456357
    • id: 1704352
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161558875
    • updated: 2026-04-06 01:20:33
    • created: 2026-04-05 01:11:07
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-05/1775369401'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-05/1775369401
    • id: 1703161
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161512423
    • updated: 2026-04-05 01:11:19
    • created: 2026-04-04 01:20:41
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-04/1775283581'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-04/1775283581
    • id: 1701988
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161457457
    • updated: 2026-04-04 01:20:55
    • created: 2026-04-03 01:15:20
    • ddl: 
      [
    "CREATE DATABASE IF NOT EXISTS `sfdl_prod_postgres`",
    "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_prod_postgres.keplernormies_web_view_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-03/1775196861'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
]
    • hive_path: s3://sfdl-postgres-keplernormies-prod/raw/web_view_fact/2026-04-03/1775196861
    • id: 1700780
    • processed: 1
    • raw_data: 
      {
    "browser": 2,
    "browser_version": 3,
    "canonical": 11,
    "city": 8,
    "company_dim_id": 16,
    "country": 10,
    "date_dim_id": 18,
    "device": 5,
    "facility_dim_id": 17,
    "operating_system": 4,
    "provider": 14,
    "provider_id": 15,
    "referrer": 12,
    "referrer_domain": 19,
    "region": 9,
    "screen_height": 7,
    "screen_width": 6,
    "session_id": 1,
    "timestamp": 13,
    "web_view_fact_id": 0
}
    • schema_attributes: 
      {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
    • schema_name_id: 615
    • schema_scan_id: 161398695
    • updated: 2026-04-03 01:15:33
Schema Scans: 15
Last at 2026-04-17 01:14:02
    • duration: 0:00:18.843615
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162165053
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-17/1776406387",
        "key": "raw/web_view_fact/2026-04-17/1776406387/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 3927924709390116039,
        "service_name": "kepler-normies",
        "span_id": 8760863646476136507,
        "trace_id": 3927924709390116039
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-17 01:14:02
    • success: True
    • trace_id: 3927924709390116039
    • duration: 0:00:15.702516
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162109285
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-16/1776320136",
        "key": "raw/web_view_fact/2026-04-16/1776320136/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 6106756276153162141,
        "service_name": "kepler-normies",
        "span_id": 17705077695518845222,
        "trace_id": 6106756276153162141
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-16 01:16:34
    • success: True
    • trace_id: 6106756276153162141
    • duration: 0:00:17.939082
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 162053428
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-15/1776233913",
        "key": "raw/web_view_fact/2026-04-15/1776233913/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 8645273923443865649,
        "service_name": "kepler-normies",
        "span_id": 17785882236011662885,
        "trace_id": 8645273923443865649
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-15 01:19:41
    • success: True
    • trace_id: 8645273923443865649
    • duration: 0:00:17.997318
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161997633
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-14/1776146983",
        "key": "raw/web_view_fact/2026-04-14/1776146983/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 14175456486898364857,
        "service_name": "kepler-normies",
        "span_id": 18162613381491785279,
        "trace_id": 14175456486898364857
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-14 01:10:47
    • success: True
    • trace_id: 14175456486898364857
    • duration: 0:00:17.933056
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161940079
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-13/1776060714",
        "key": "raw/web_view_fact/2026-04-13/1776060714/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 9143463071732309456,
        "service_name": "kepler-normies",
        "span_id": 16542657623955277603,
        "trace_id": 9143463071732309456
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-13 01:12:47
    • success: True
    • trace_id: 9143463071732309456
    • duration: 0:00:15.367692
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161890552
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-12/1775974049",
        "key": "raw/web_view_fact/2026-04-12/1775974049/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 7028410376141655889,
        "service_name": "kepler-normies",
        "span_id": 4497629342899779552,
        "trace_id": 7028410376141655889
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-12 01:08:20
    • success: True
    • trace_id: 7028410376141655889
    • duration: 0:00:18.107133
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161838676
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-11/1775888117",
        "key": "raw/web_view_fact/2026-04-11/1775888117/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 11755072409581696663,
        "service_name": "kepler-normies",
        "span_id": 14775192718926407322,
        "trace_id": 11755072409581696663
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-11 01:16:24
    • success: True
    • trace_id: 11755072409581696663
    • duration: 0:00:17.909636
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161783152
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-10/1775802073",
        "key": "raw/web_view_fact/2026-04-10/1775802073/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 7384013806726652647,
        "service_name": "kepler-normies",
        "span_id": 13224907643276378020,
        "trace_id": 7384013806726652647
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-10 01:22:18
    • success: True
    • trace_id: 7384013806726652647
    • duration: 0:00:15.443831
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161727980
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-09/1775715671",
        "key": "raw/web_view_fact/2026-04-09/1775715671/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15250430890573642202,
        "service_name": "kepler-normies",
        "span_id": 10310758550568633074,
        "trace_id": 15250430890573642202
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-09 01:22:20
    • success: True
    • trace_id: 15250430890573642202
    • duration: 0:00:15.495003
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161672817
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-08/1775628791",
        "key": "raw/web_view_fact/2026-04-08/1775628791/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 15470029961572692294,
        "service_name": "kepler-normies",
        "span_id": 6312149543678924143,
        "trace_id": 15470029961572692294
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-08 01:14:04
    • success: True
    • trace_id: 15470029961572692294
    • duration: 0:00:18.037731
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161616739
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-07/1775542193",
        "key": "raw/web_view_fact/2026-04-07/1775542193/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 10023499817674484929,
        "service_name": "kepler-normies",
        "span_id": 510771484428000043,
        "trace_id": 10023499817674484929
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-07 01:10:52
    • success: True
    • trace_id: 10023499817674484929
    • duration: 0:00:17.993598
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161558875
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-06/1775456357",
        "key": "raw/web_view_fact/2026-04-06/1775456357/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 16576313724883859109,
        "service_name": "kepler-normies",
        "span_id": 8122530514737261379,
        "trace_id": 16576313724883859109
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-06 01:20:15
    • success: True
    • trace_id: 16576313724883859109
    • duration: 0:00:15.385817
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161512423
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-05/1775369401",
        "key": "raw/web_view_fact/2026-04-05/1775369401/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 18080859041331565590,
        "service_name": "kepler-normies",
        "span_id": 751752125475005352,
        "trace_id": 18080859041331565590
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-05 01:11:03
    • success: True
    • trace_id: 18080859041331565590
    • duration: 0:00:18.232807
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161457457
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-04/1775283581",
        "key": "raw/web_view_fact/2026-04-04/1775283581/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 17608107889190351367,
        "service_name": "kepler-normies",
        "span_id": 7484343559620695241,
        "trace_id": 17608107889190351367
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-04 01:20:37
    • success: True
    • trace_id: 17608107889190351367
    • duration: 0:00:18.267562
    • exit_message: 
      {
    "ddl_changed": true,
    "partitions_applied": false,
    "success": true
}
    • id: 161398695
    • payload: 
      {
    "datatype_dict": {
        "browser": "string",
        "browser_version": "string",
        "canonical": "string",
        "city": "string",
        "company_dim_id": "int",
        "country": "string",
        "date_dim_id": "int",
        "device": "string",
        "facility_dim_id": "int",
        "operating_system": "string",
        "provider": "string",
        "provider_id": "string",
        "referrer": "string",
        "referrer_domain": "string",
        "region": "string",
        "screen_height": "int",
        "screen_width": "int",
        "session_id": "string",
        "timestamp": "bigint",
        "web_view_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_fact/2026-04-03/1775196861",
        "key": "raw/web_view_fact/2026-04-03/1775196861/data_0.csv.gz"
    },
    "schema": {
        "name": "sfdl_prod_postgres.keplernormies_web_view_fact",
        "type": "postgres"
    },
    "trace_context": {
        "parent_id": 2328865944706716024,
        "service_name": "kepler-normies",
        "span_id": 17639902738084332369,
        "trace_id": 2328865944706716024
    }
}
    • running: False
    • schema_name_id: 615
    • start_time: 2026-04-03 01:15:15
    • success: True
    • trace_id: 2328865944706716024
Partitions:
  • count: 0
  • ddl: None
  • name: None
  • state: 
    []
  • type: None
Schema:
  • attributes: 
    {
    "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
    "1024": "string",
    "1080": "string",
    "108920": "string",
    "109": "string",
    "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
    "10federalstorage": "string",
    "110471": "string",
    "113": "string",
    "114": "string",
    "1148196": "string",
    "11768": "string",
    "1217304": "string",
    "1280": "string",
    "13847": "string",
    "13_1": "string",
    "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
    "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
    "1440": "string",
    "15_6": "string",
    "16": "string",
    "1604": "string",
    "1685079065143": "string",
    "1685724674473": "string",
    "1685759966014": "string",
    "1685805578936": "string",
    "1685812957114": "string",
    "1685820778835": "string",
    "1686253117472": "string",
    "1686281443010": "string",
    "1686316576656": "string",
    "1686790829065": "string",
    "1686838332462": "string",
    "1687118098651": "string",
    "1687461303888": "string",
    "1687641062880": "string",
    "1687812839912": "string",
    "1687916801380": "string",
    "1688450224967": "string",
    "1688656904394": "string",
    "1688762437207": "string",
    "1688862725230": "string",
    "1688874596251": "string",
    "1689900005007": "string",
    "1689904385436": "string",
    "16_2": "string",
    "16_5": "string",
    "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
    "181": "string",
    "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
    "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
    "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
    "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
    "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
    "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
    "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
    "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
    "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
    "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
    "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
    "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
    "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
    "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
    "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
    "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
    "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
    "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
    "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
    "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
    "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
    "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
    "1920": "string",
    "1993360": "string",
    "20230526": "string",
    "20230602": "string",
    "20230603": "string",
    "20230608": "string",
    "20230609": "string",
    "20230614": "string",
    "20230615": "string",
    "20230618": "string",
    "20230622": "string",
    "20230624": "string",
    "20230626": "string",
    "20230627": "string",
    "20230704": "string",
    "20230706": "string",
    "20230707": "string",
    "20230708": "string",
    "20230720": "string",
    "23120": "string",
    "2667386": "string",
    "29225": "string",
    "296": "string",
    "31766": "string",
    "3205944": "string",
    "3376785": "string",
    "35199": "string",
    "35924": "string",
    "360": "string",
    "375": "string",
    "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
    "390": "string",
    "39422": "string",
    "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
    "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
    "412": "string",
    "414": "string",
    "428": "string",
    "432": "string",
    "439548": "string",
    "476752827": "string",
    "483345665": "string",
    "484031247": "string",
    "484406191": "string",
    "484565935": "string",
    "484756917": "string",
    "490625997": "string",
    "491007628": "string",
    "491236281": "string",
    "497014588": "string",
    "497321133": "string",
    "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
    "500625709": "string",
    "505210826": "string",
    "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
    "507731310": "string",
    "509985236": "string",
    "511433066": "string",
    "516184945": "string",
    "517696209": "string",
    "518679562": "string",
    "519376441": "string",
    "519376573": "string",
    "526296479": "string",
    "526296595": "string",
    "58133": "string",
    "600": "string",
    "628149": "string",
    "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
    "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
    "6587": "string",
    "667": "string",
    "68858": "string",
    "69491": "string",
    "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
    "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
    "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
    "72290": "string",
    "736": "string",
    "75920": "string",
    "768": "string",
    "768579": "string",
    "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
    "788694": "string",
    "79121": "string",
    "800": "string",
    "823": "string",
    "823312": "string",
    "831": "string",
    "844": "string",
    "87": "string",
    "87272": "string",
    "89": "string",
    "900": "string",
    "915": "string",
    "926": "string",
    "94": "string",
    "960": "string",
    "97": "string",
    "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
    "Android": "string",
    "Arizona": "string",
    "Ashburn": "string",
    "CN": "string",
    "Chrome": "string",
    "Chrome_iOS": "string",
    "Columbia": "string",
    "Dallas": "string",
    "District_of_Columbia": "string",
    "Hawaii": "string",
    "Honolulu": "string",
    "IN": "string",
    "Jodhpur": "string",
    "Kansas_City": "string",
    "Mac_OS_X": "string",
    "Minneapolis": "string",
    "Minnesota": "string",
    "Missouri": "string",
    "Mobile_Safari": "string",
    "New_York": "string",
    "North_Carolina": "string",
    "Phoenix": "string",
    "Rajasthan": "string",
    "Royse_City": "string",
    "Safari": "string",
    "South_Carolina": "string",
    "Texas": "string",
    "US": "string",
    "Virginia": "string",
    "Washington": "string",
    "Windows": "string",
    "Winston_Salem": "string",
    "Zimmerman": "string",
    "_": "string",
    "_149_park_ave_brockport_ny_14559": "string",
    "_1622_bobcat_dr_bozeman_mt_59718": "string",
    "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
    "_187_highway_601_s_lugoff_sc_29078": "string",
    "_1930_hwy_42_s_mcdonough_ga_30252": "string",
    "_355_w_main_st_norristown_pa_19401": "string",
    "_6108_s_000_rd_berne_in_46711": "string",
    "_690_burmont_rd_drexel_hill_pa_19026": "string",
    "_9273_67th_st_nw_annandale_mn_55302": "string",
    "_contact_us": "string",
    "_payonline": "string",
    "_self_storage": "string",
    "_self_storage_bozeman_mt_272002": "string",
    "_self_storage_caddo_mills_tx_f1540": "string",
    "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
    "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
    "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
    "axisstorage": "string",
    "baidu": "string",
    "baidu_com": "string",
    "blueskiesstorage": "string",
    "brockportstorage": "string",
    "browser": "string",
    "browser_version": "string",
    "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
    "canonical": "string",
    "city": "string",
    "company_dim_id": "int",
    "country": "string",
    "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
    "date_dim_id": "int",
    "device": "string",
    "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
    "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
    "facility_dim_id": "int",
    "gladstoneselfstorage": "string",
    "google": "string",
    "hawaiiselfstorage": "string",
    "iOS": "string",
    "iPad": "string",
    "iPhone": "string",
    "mixpanel": "string",
    "mnbigtoystorage": "string",
    "operating_system": "string",
    "provider": "string",
    "provider_id": "string",
    "referrer": "string",
    "referrer_domain": "string",
    "region": "string",
    "screen_height": "int",
    "screen_width": "int",
    "session_id": "string",
    "storagecenter": "string",
    "timestamp": "bigint",
    "web_view_fact_id": "int",
    "www_10federalstorage_com": "string",
    "www_axisstorage_com": "string",
    "www_blueskiesstorage_com": "string",
    "www_brockportstorage_com": "string",
    "www_gladstoneselfstorage_com": "string",
    "www_google_com": "string",
    "www_hawaiiselfstorage_com": "string",
    "www_mnbigtoystorage_com": "string",
    "www_storagecenter_com": "string"
}
  • created: 2026-04-17 01:14:07
  • 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_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-17/1776406387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
    "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
    "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_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-01-29 18:12:01",
        "disabled": false,
        "format": "raw",
        "id": 615,
        "is_partitioned": false,
        "is_schema_datatyped": true,
        "name": {
            "database": "sfdl_prod_postgres",
            "table": "keplernormies_web_view_fact"
        },
        "type": "postgres"
    },
    "partition": {
        "count": 0,
        "ddl": null,
        "name": null,
        "state": [],
        "type": null
    },
    "schema": {
        "attributes": {
            "0bfccb7fc85482c26632d2f90614de54b2212dd10ee2b08acd90ba315605afe1": "string",
            "1024": "string",
            "1080": "string",
            "108920": "string",
            "109": "string",
            "10aa44f868d9da901bc9d7612569020e71622043b4bd2515197156809cc585c3": "string",
            "10federalstorage": "string",
            "110471": "string",
            "113": "string",
            "114": "string",
            "1148196": "string",
            "11768": "string",
            "1217304": "string",
            "1280": "string",
            "13847": "string",
            "13_1": "string",
            "13a15a595f78d24411a59363412ba2d3db3677f274ef5f4fabff83ea1c0a8c02": "string",
            "143d37a143c880d39505694f892d6af21ac85796b363b44a3a494f12d0f11c3b": "string",
            "1440": "string",
            "15_6": "string",
            "16": "string",
            "1604": "string",
            "1685079065143": "string",
            "1685724674473": "string",
            "1685759966014": "string",
            "1685805578936": "string",
            "1685812957114": "string",
            "1685820778835": "string",
            "1686253117472": "string",
            "1686281443010": "string",
            "1686316576656": "string",
            "1686790829065": "string",
            "1686838332462": "string",
            "1687118098651": "string",
            "1687461303888": "string",
            "1687641062880": "string",
            "1687812839912": "string",
            "1687916801380": "string",
            "1688450224967": "string",
            "1688656904394": "string",
            "1688762437207": "string",
            "1688862725230": "string",
            "1688874596251": "string",
            "1689900005007": "string",
            "1689904385436": "string",
            "16_2": "string",
            "16_5": "string",
            "17a154b6fed450_0ce6e659ad69e2_3373266_1fa400_17a154b6fee13ae": "string",
            "181": "string",
            "188568a0233bc_0a94f6c66812c3_607f5047_52c84_188568a0234a55": "string",
            "1887d0539a6176f_0452a60faa4d72_296e4a30_505c8_1887d0539a722d9": "string",
            "1887f1fa24d20d_0e48b06d7aba21_1457c77_3d10d_1887f1fa24e5c6": "string",
            "1887f62bc8e241_0a53f2c2da6795_296e4a30_60c28_1887f62bc8f271c": "string",
            "18882bfa94c5e7_0c90f66c246bfb_72005b4d_75300_18882bfa94d395": "string",
            "1889912ef254ba_0d0c5430946dd88_48796c45_4a640_1889912ef27b95": "string",
            "1889c849fd0bad_0657f85e5b2c3a_1633685c_13c680_1889c849fd1958": "string",
            "1889e34bfdacba_015f6256a80fcd8_296e4d37_60c28_1889e34bfdb236a": "string",
            "188bc9173fe1c1_04c326a03a06b8_6501541e_3d10d_188bc917400213": "string",
            "188bf65d70a13c7_02ae9151271bed_296e4a30_60c28_188bf65d70b1c54": "string",
            "188d013168e25_0e7dd77da7ce0d_b457654_46500_188d013168fdf2": "string",
            "188e48816495e4_00e984bafd579a_b457654_5c094_188e488164aced": "string",
            "188ef1f1db6278_01a26fcfc4f2498_4d1e6d65_c0000_188ef1f1db7c39": "string",
            "188f97c19d498_0874b90c79bd25_26031d51_140000_188f97c19d562": "string",
            "188ffae6d5f2f5_057df0d609296d_1633685c_13c680_188ffae6d607ef": "string",
            "1891177fd5ca5_0ad81f282b9196_b457654_65400_1891177fd5da59": "string",
            "1891f79d34192d_0d85b538903ad2_607f5047_52c84_1891f79d342947": "string",
            "18931e136de4a1_0575bfe1d45b94_7c7f3361_505c8_18931e136dfee4": "string",
            "1893810146848e_0f53c9d5b3e341_607f5047_52c84_18938101469c68": "string",
            "18938c3fafa61_0a70fbe2aae3c8_573e0332_46500_18938c3fafb1e": "string",
            "18975e3b68bcd0_06c37572852cdd_607f5047_52c84_18975e3b68cd81": "string",
            "18976268d991b5d_02fd7234af13d9_2467e76_505c8_18976268d9a21fc": "string",
            "1920": "string",
            "1993360": "string",
            "20230526": "string",
            "20230602": "string",
            "20230603": "string",
            "20230608": "string",
            "20230609": "string",
            "20230614": "string",
            "20230615": "string",
            "20230618": "string",
            "20230622": "string",
            "20230624": "string",
            "20230626": "string",
            "20230627": "string",
            "20230704": "string",
            "20230706": "string",
            "20230707": "string",
            "20230708": "string",
            "20230720": "string",
            "23120": "string",
            "2667386": "string",
            "29225": "string",
            "296": "string",
            "31766": "string",
            "3205944": "string",
            "3376785": "string",
            "35199": "string",
            "35924": "string",
            "360": "string",
            "375": "string",
            "38c2297577f50e306e46b343a714e278989e21cad063722a340d70493332c930": "string",
            "390": "string",
            "39422": "string",
            "3ab1f7f77ca403362dc1397957068f98660af364bd6fe0079c787833d3c93545": "string",
            "3f51ca704202a29372c99b0cebba25b3af4617a9d29035549b697b69dcd5e618": "string",
            "412": "string",
            "414": "string",
            "428": "string",
            "432": "string",
            "439548": "string",
            "476752827": "string",
            "483345665": "string",
            "484031247": "string",
            "484406191": "string",
            "484565935": "string",
            "484756917": "string",
            "490625997": "string",
            "491007628": "string",
            "491236281": "string",
            "497014588": "string",
            "497321133": "string",
            "4f46ab16ed4d4555d64db78fe5a8f77d8c09a687728f6ca9e0fd70ae1780aa08": "string",
            "500625709": "string",
            "505210826": "string",
            "505a67f48491b38dc00dbf59c3419dde59691ec4b48c2dc980efb4c865e8ea84": "string",
            "507731310": "string",
            "509985236": "string",
            "511433066": "string",
            "516184945": "string",
            "517696209": "string",
            "518679562": "string",
            "519376441": "string",
            "519376573": "string",
            "526296479": "string",
            "526296595": "string",
            "58133": "string",
            "600": "string",
            "628149": "string",
            "629660209b6db98d819511a8d834a97ca83e4b9eaac7f44a0ab8b5a3bd58a2b7": "string",
            "65449e96f602be1951d769fbfad25eefe472ff6c9c3915953eab2191ad5a4f23": "string",
            "6587": "string",
            "667": "string",
            "68858": "string",
            "69491": "string",
            "6b7b18c6cf492b040473ec0b15adf1b53ba57afedd2a43f749222f6a59a4f38b": "string",
            "705844316365c1a6374fb0071ffa23c64d235d16b22ba7918d2d4bcf8dccd5a6": "string",
            "71dc982c1b43376c966f242eb9a11919e8c10acbc15198579ef5f38eb1b341dd": "string",
            "72290": "string",
            "736": "string",
            "75920": "string",
            "768": "string",
            "768579": "string",
            "78038e9f885bac70c06a9f295061e00a91743701bccf0694a4da8a0659be9787": "string",
            "788694": "string",
            "79121": "string",
            "800": "string",
            "823": "string",
            "823312": "string",
            "831": "string",
            "844": "string",
            "87": "string",
            "87272": "string",
            "89": "string",
            "900": "string",
            "915": "string",
            "926": "string",
            "94": "string",
            "960": "string",
            "97": "string",
            "9ac763221e61e2581cd77b25968b9ae3433b03dddb41375175e7d5a4c6b83c6d": "string",
            "Android": "string",
            "Arizona": "string",
            "Ashburn": "string",
            "CN": "string",
            "Chrome": "string",
            "Chrome_iOS": "string",
            "Columbia": "string",
            "Dallas": "string",
            "District_of_Columbia": "string",
            "Hawaii": "string",
            "Honolulu": "string",
            "IN": "string",
            "Jodhpur": "string",
            "Kansas_City": "string",
            "Mac_OS_X": "string",
            "Minneapolis": "string",
            "Minnesota": "string",
            "Missouri": "string",
            "Mobile_Safari": "string",
            "New_York": "string",
            "North_Carolina": "string",
            "Phoenix": "string",
            "Rajasthan": "string",
            "Royse_City": "string",
            "Safari": "string",
            "South_Carolina": "string",
            "Texas": "string",
            "US": "string",
            "Virginia": "string",
            "Washington": "string",
            "Windows": "string",
            "Winston_Salem": "string",
            "Zimmerman": "string",
            "_": "string",
            "_149_park_ave_brockport_ny_14559": "string",
            "_1622_bobcat_dr_bozeman_mt_59718": "string",
            "_17730_e_state_hwy_56_honey_grove_tx_75446_": "string",
            "_187_highway_601_s_lugoff_sc_29078": "string",
            "_1930_hwy_42_s_mcdonough_ga_30252": "string",
            "_355_w_main_st_norristown_pa_19401": "string",
            "_6108_s_000_rd_berne_in_46711": "string",
            "_690_burmont_rd_drexel_hill_pa_19026": "string",
            "_9273_67th_st_nw_annandale_mn_55302": "string",
            "_contact_us": "string",
            "_payonline": "string",
            "_self_storage": "string",
            "_self_storage_bozeman_mt_272002": "string",
            "_self_storage_caddo_mills_tx_f1540": "string",
            "a48c34036d8fff1bcb504054cc4bb8a67870a841d815452a31f45c462d8b12bf": "string",
            "ac77d841e69f553ea3ea69cc0338366fdc98a01fa3d320ec1a21cb0d7015eca0": "string",
            "ad86c9d76a55731ad2a1206bdf6e0b21630c5a6779f9786d9ba1a1e5cce0dfdd": "string",
            "axisstorage": "string",
            "baidu": "string",
            "baidu_com": "string",
            "blueskiesstorage": "string",
            "brockportstorage": "string",
            "browser": "string",
            "browser_version": "string",
            "c5296e6cb0ef3a16a6cbf30dc4b960f949185e053481c3d10a98260106ed2f84": "string",
            "canonical": "string",
            "city": "string",
            "company_dim_id": "int",
            "country": "string",
            "d035dd18e69f0a59511256223f6139641ccdbf88b7dc7eaf08f622868189b4bc": "string",
            "date_dim_id": "int",
            "device": "string",
            "f69261dadff579089026b56de2ca62995fd6ddf9d934bfce5aac1e08ba082ddf": "string",
            "fa2eea39c167b10ba11a2e4d3a81f1bc0e17e68357b276ea91633c4f5726cca9": "string",
            "facility_dim_id": "int",
            "gladstoneselfstorage": "string",
            "google": "string",
            "hawaiiselfstorage": "string",
            "iOS": "string",
            "iPad": "string",
            "iPhone": "string",
            "mixpanel": "string",
            "mnbigtoystorage": "string",
            "operating_system": "string",
            "provider": "string",
            "provider_id": "string",
            "referrer": "string",
            "referrer_domain": "string",
            "region": "string",
            "screen_height": "int",
            "screen_width": "int",
            "session_id": "string",
            "storagecenter": "string",
            "timestamp": "bigint",
            "web_view_fact_id": "int",
            "www_10federalstorage_com": "string",
            "www_axisstorage_com": "string",
            "www_blueskiesstorage_com": "string",
            "www_brockportstorage_com": "string",
            "www_gladstoneselfstorage_com": "string",
            "www_google_com": "string",
            "www_hawaiiselfstorage_com": "string",
            "www_mnbigtoystorage_com": "string",
            "www_storagecenter_com": "string"
        },
        "created": "2026-04-17 01:14:07",
        "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_fact`\n(\n `web_view_fact_id`  int , `session_id`  string , `browser`  string , `browser_version`  string , `operating_system`  string , `device`  string , `screen_width`  int , `screen_height`  int , `city`  string , `region`  string , `country`  string , `canonical`  string , `referrer`  string , `timestamp`  bigint , `provider`  string , `provider_id`  string , `company_dim_id`  int , `facility_dim_id`  int , `date_dim_id`  int , `referrer_domain`  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/web_view_fact/2026-04-17/1776406387'\nTBLPROPERTIES ('skip.header.line.count' = '1')",
            "drop_table": "DROP TABLE IF EXISTS `sfdl_prod_postgres.keplernormies_web_view_fact`",
            "repair_table": "MSCK REPAIR TABLE sfdl_prod_postgres.keplernormies_web_view_fact"
        }
    },
    "server": {
        "hostname": "schemamanager-5475496c57-7dpqb",
        "name": "schema_manager",
        "process_start": "2026-01-09 11:27:47",
        "sf_env": "prod",
        "version": "2112174301"
    }
}
©2019 SpareFoot Data Platform