Schema Info
Schema Name: sfdl_dev_redshift.analytics_mart_visitor
- created: 2018-03-26 17:19:29
- disabled: False
- format: raw
- id: 685
- is_partitioned: True
- is_schema_datatyped: False
- name:
{ "database": "sfdl_dev_redshift", "table": "analytics_mart_visitor" } - type: redshift
Schema Versions: 3
-
Version 4669854
- created: 2019-06-09 15:09:16
- ddl:
[ "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_visitor`\n(\n `audit_id` bigint , `visit_day` date , `visit_day_key` int , `visit_time` timestamp , `visitor_key` bigint , `user_agent` varchar(255) , `device_type` varchar(10) , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `ip_address` varchar(20) , `geo_ip_city` varchar(30) , `geo_ip_state` varchar(20) , `geo_ip_zip` varchar(10) , `geo_ip_msa` varchar(150) , `geo_ip_latitude` decimal , `geo_ip_longitude` decimal , `granular_search_key` bigint , `granular_search_street_address` varchar(255) , `granular_search_city` varchar(100) , `granular_search_state` varchar(2) , `granular_search_zip` varchar(6) , `granular_search_latitude` decimal , `granular_search_longitude` decimal , `granular_search_msa` varchar(150) , `cc_delivered_calls` int , `cc_inbound_calls` int , `cc_handled_calls` int , `searches_before_reservation` int , `page_views` int , `unique_facility_clicks` int , `valid_reservations` int , `reconciled_reservations` int , `move_ins` int , `sum_npv` decimal , `confirmed_npv` decimal , `search_type` varchar(50) , `first_reservation_key` varchar(30) , `first_reservation_touchpoint` varchar(10) , `unit_price` decimal , `unit_size` varchar(10) , `unit_key` bigint , `unit_type_key` int , `unit_type` varchar(24) , `unit_vehicle` int , `unit_drive_up` int , `unit_climate_controlled` int , `unit_floor` int , `reservation_time` timestamp , `reservation_move_in_original_day` date , `reservation_move_in_day` date , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_facility_key` bigint , `reservation_facility_name` varchar(255) , `reservation_facility_address` varchar(255) , `reservation_facility_city` varchar(100) , `reservation_facility_state` varchar(2) , `reservation_facility_msa` varchar(150) , `reservation_facility_zip` varchar(6) , `reservation_facility_latitude` decimal , `reservation_facility_longitude` decimal , `reservation_facility_aaa_active` int , `reservation_facility_truck_rental` int , `reservation_facility_free_truck_rental` int , `reservation_facility_listing_type_key` int , `reservation_facility_listing_type` varchar(100) , `reservation_npv` decimal , `facility_client_key` bigint , `facility_client_name` varchar(255) , `landing_page_facility_key` bigint , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_facility_in_directory` int , `landing_page_site_content_key` bigint , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_template_key` int , `landing_page_template_name` varchar(64) , `landing_page_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type_name` varchar(128) , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-04/1559650386'\n", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_visitor`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_visitor`\n(\n `audit_id` bigint , `visit_day` date , `visit_day_key` int , `visit_time` timestamp , `visitor_key` bigint , `user_agent` varchar(255) , `device_type` varchar(10) , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `ip_address` varchar(20) , `geo_ip_city` varchar(30) , `geo_ip_state` varchar(20) , `geo_ip_zip` varchar(10) , `geo_ip_msa` varchar(150) , `geo_ip_latitude` decimal , `geo_ip_longitude` decimal , `granular_search_key` bigint , `granular_search_street_address` varchar(255) , `granular_search_city` varchar(100) , `granular_search_state` varchar(2) , `granular_search_zip` varchar(6) , `granular_search_latitude` decimal , `granular_search_longitude` decimal , `granular_search_msa` varchar(150) , `cc_delivered_calls` int , `cc_inbound_calls` int , `cc_handled_calls` int , `searches_before_reservation` int , `page_views` int , `unique_facility_clicks` int , `valid_reservations` int , `reconciled_reservations` int , `move_ins` int , `sum_npv` decimal , `confirmed_npv` decimal , `search_type` varchar(50) , `first_reservation_key` varchar(30) , `first_reservation_touchpoint` varchar(10) , `unit_price` decimal , `unit_size` varchar(10) , `unit_key` bigint , `unit_type_key` int , `unit_type` varchar(24) , `unit_vehicle` int , `unit_drive_up` int , `unit_climate_controlled` int , `unit_floor` int , `reservation_time` timestamp , `reservation_move_in_original_day` date , `reservation_move_in_day` date , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_facility_key` bigint , `reservation_facility_name` varchar(255) , `reservation_facility_address` varchar(255) , `reservation_facility_city` varchar(100) , `reservation_facility_state` varchar(2) , `reservation_facility_msa` varchar(150) , `reservation_facility_zip` varchar(6) , `reservation_facility_latitude` decimal , `reservation_facility_longitude` decimal , `reservation_facility_aaa_active` int , `reservation_facility_truck_rental` int , `reservation_facility_free_truck_rental` int , `reservation_facility_listing_type_key` int , `reservation_facility_listing_type` varchar(100) , `reservation_npv` decimal , `facility_client_key` bigint , `facility_client_name` varchar(255) , `landing_page_facility_key` bigint , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_facility_in_directory` int , `landing_page_site_content_key` bigint , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_template_key` int , `landing_page_template_name` varchar(64) , `landing_page_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type_name` varchar(128) , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_visitor" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818
- id: 4669854
- processed: 1
- raw_data:
{ "_origin": "84", "annotations": "83", "audit_id": "0", "cc_delivered_calls": "26", "cc_handled_calls": "28", "cc_inbound_calls": "27", "confirmed_npv": "36", "device_type": "6", "facility_client_key": "69", "facility_client_name": "70", "first_reservation_key": "38", "first_reservation_touchpoint": "39", "geo_ip_city": "12", "geo_ip_latitude": "16", "geo_ip_longitude": "17", "geo_ip_msa": "15", "geo_ip_state": "13", "geo_ip_zip": "14", "granular_search_city": "20", "granular_search_key": "18", "granular_search_latitude": "23", "granular_search_longitude": "24", "granular_search_msa": "25", "granular_search_state": "21", "granular_search_street_address": "19", "granular_search_zip": "22", "ip_address": "11", "landing_page_client_key": "73", "landing_page_facility_in_directory": "74", "landing_page_facility_key": "71", "landing_page_facility_name": "72", "landing_page_page_type_key": "81", "landing_page_page_type_name": "82", "landing_page_site_content_key": "75", "landing_page_site_content_title": "76", "landing_page_site_content_uri": "77", "landing_page_template_key": "78", "landing_page_template_name": "79", "landing_page_template_type": "80", "move_ins": "34", "page_views": "30", "reconciled_reservations": "33", "reservation_auto_state": "53", "reservation_facility_aaa_active": "63", "reservation_facility_address": "56", "reservation_facility_city": "57", "reservation_facility_free_truck_rental": "65", "reservation_facility_key": "54", "reservation_facility_latitude": "61", "reservation_facility_listing_type": "67", "reservation_facility_listing_type_key": "66", "reservation_facility_longitude": "62", "reservation_facility_msa": "59", "reservation_facility_name": "55", "reservation_facility_state": "58", "reservation_facility_truck_rental": "64", "reservation_facility_zip": "60", "reservation_move_in_day": "51", "reservation_move_in_original_day": "50", "reservation_npv": "68", "reservation_state": "52", "reservation_time": "49", "search_type": "37", "searches_before_reservation": "29", "site": "8", "site_key": "7", "sum_npv": "35", "traffic_source": "10", "traffic_source_key": "9", "unique_facility_clicks": "31", "unit_climate_controlled": "47", "unit_drive_up": "46", "unit_floor": "48", "unit_key": "42", "unit_price": "40", "unit_size": "41", "unit_type": "44", "unit_type_key": "43", "unit_vehicle": "45", "user_agent": "5", "valid_reservations": "32", "visit_day": "1", "visit_day_key": "2", "visit_time": "3", "visitor_key": "4" } - schema_attributes:
{ "_origin": "string", "annotations": "varchar(2048)", "audit_id": "bigint", "cc_delivered_calls": "int", "cc_handled_calls": "int", "cc_inbound_calls": "int", "confirmed_npv": "decimal", "device_type": "varchar(10)", "facility_client_key": "bigint", "facility_client_name": "varchar(255)", "first_reservation_key": "varchar(30)", "first_reservation_touchpoint": "varchar(10)", "geo_ip_city": "varchar(30)", "geo_ip_latitude": "decimal", "geo_ip_longitude": "decimal", "geo_ip_msa": "varchar(150)", "geo_ip_state": "varchar(20)", "geo_ip_zip": "varchar(10)", "granular_search_city": "varchar(100)", "granular_search_key": "bigint", "granular_search_latitude": "decimal", "granular_search_longitude": "decimal", "granular_search_msa": "varchar(150)", "granular_search_state": "varchar(2)", "granular_search_street_address": "varchar(255)", "granular_search_zip": "varchar(6)", "ip_address": "varchar(20)", "landing_page_client_key": "bigint", "landing_page_facility_in_directory": "int", "landing_page_facility_key": "bigint", "landing_page_facility_name": "varchar(255)", "landing_page_page_type_key": "int", "landing_page_page_type_name": "varchar(128)", "landing_page_site_content_key": "bigint", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "landing_page_template_key": "int", "landing_page_template_name": "varchar(64)", "landing_page_template_type": "varchar(64)", "move_ins": "int", "page_views": "int", "reconciled_reservations": "int", "reservation_auto_state": "varchar(20)", "reservation_facility_aaa_active": "int", "reservation_facility_address": "varchar(255)", "reservation_facility_city": "varchar(100)", "reservation_facility_free_truck_rental": "int", "reservation_facility_key": "bigint", "reservation_facility_latitude": "decimal", "reservation_facility_listing_type": "varchar(100)", "reservation_facility_listing_type_key": "int", "reservation_facility_longitude": "decimal", "reservation_facility_msa": "varchar(150)", "reservation_facility_name": "varchar(255)", "reservation_facility_state": "varchar(2)", "reservation_facility_truck_rental": "int", "reservation_facility_zip": "varchar(6)", "reservation_move_in_day": "date", "reservation_move_in_original_day": "date", "reservation_npv": "decimal", "reservation_state": "varchar(20)", "reservation_time": "timestamp", "search_type": "varchar(50)", "searches_before_reservation": "int", "site": "varchar(255)", "site_key": "int", "sum_npv": "decimal", "traffic_source": "varchar(128)", "traffic_source_key": "int", "unique_facility_clicks": "int", "unit_climate_controlled": "int", "unit_drive_up": "int", "unit_floor": "int", "unit_key": "bigint", "unit_price": "decimal", "unit_size": "varchar(10)", "unit_type": "varchar(24)", "unit_type_key": "int", "unit_vehicle": "int", "user_agent": "varchar(255)", "valid_reservations": "int", "visit_day": "date", "visit_day_key": "int", "visit_time": "timestamp", "visitor_key": "bigint" } - schema_name_id: 685
- schema_scan_id: None
- updated: 2019-06-09 15:17:12
-
Version 4669648
- created: 2019-06-04 07:46:16
- ddl:
[ "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_visitor`\n(\n `audit_id` bigint , `visit_day` date , `visit_day_key` int , `visit_time` timestamp , `visitor_key` bigint , `user_agent` varchar(255) , `device_type` varchar(10) , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `ip_address` varchar(20) , `geo_ip_city` varchar(30) , `geo_ip_state` varchar(20) , `geo_ip_zip` varchar(10) , `geo_ip_msa` varchar(150) , `geo_ip_latitude` decimal , `geo_ip_longitude` decimal , `granular_search_key` bigint , `granular_search_street_address` varchar(255) , `granular_search_city` varchar(100) , `granular_search_state` varchar(2) , `granular_search_zip` varchar(6) , `granular_search_latitude` decimal , `granular_search_longitude` decimal , `granular_search_msa` varchar(150) , `cc_delivered_calls` int , `cc_inbound_calls` int , `cc_handled_calls` int , `searches_before_reservation` int , `page_views` int , `unique_facility_clicks` int , `valid_reservations` int , `reconciled_reservations` int , `move_ins` int , `sum_npv` decimal , `confirmed_npv` decimal , `search_type` varchar(50) , `first_reservation_key` varchar(30) , `first_reservation_touchpoint` varchar(10) , `unit_price` decimal , `unit_size` varchar(10) , `unit_key` bigint , `unit_type_key` int , `unit_type` varchar(24) , `unit_vehicle` int , `unit_drive_up` int , `unit_climate_controlled` int , `unit_floor` int , `reservation_time` timestamp , `reservation_move_in_original_day` date , `reservation_move_in_day` date , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_facility_key` bigint , `reservation_facility_name` varchar(255) , `reservation_facility_address` varchar(255) , `reservation_facility_city` varchar(100) , `reservation_facility_state` varchar(2) , `reservation_facility_msa` varchar(150) , `reservation_facility_zip` varchar(6) , `reservation_facility_latitude` decimal , `reservation_facility_longitude` decimal , `reservation_facility_aaa_active` int , `reservation_facility_truck_rental` int , `reservation_facility_free_truck_rental` int , `reservation_facility_listing_type_key` int , `reservation_facility_listing_type` varchar(100) , `reservation_npv` decimal , `facility_client_key` bigint , `facility_client_name` varchar(255) , `landing_page_facility_key` bigint , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_facility_in_directory` int , `landing_page_site_content_key` bigint , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_template_key` int , `landing_page_template_name` varchar(64) , `landing_page_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type_name` varchar(128) , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-05-26/1558897218'\n", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_visitor`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_visitor`\n(\n `audit_id` bigint , `visit_day` date , `visit_day_key` int , `visit_time` timestamp , `visitor_key` bigint , `user_agent` varchar(255) , `device_type` varchar(10) , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `ip_address` varchar(20) , `geo_ip_city` varchar(30) , `geo_ip_state` varchar(20) , `geo_ip_zip` varchar(10) , `geo_ip_msa` varchar(150) , `geo_ip_latitude` decimal , `geo_ip_longitude` decimal , `granular_search_key` bigint , `granular_search_street_address` varchar(255) , `granular_search_city` varchar(100) , `granular_search_state` varchar(2) , `granular_search_zip` varchar(6) , `granular_search_latitude` decimal , `granular_search_longitude` decimal , `granular_search_msa` varchar(150) , `cc_delivered_calls` int , `cc_inbound_calls` int , `cc_handled_calls` int , `searches_before_reservation` int , `page_views` int , `unique_facility_clicks` int , `valid_reservations` int , `reconciled_reservations` int , `move_ins` int , `sum_npv` decimal , `confirmed_npv` decimal , `search_type` varchar(50) , `first_reservation_key` varchar(30) , `first_reservation_touchpoint` varchar(10) , `unit_price` decimal , `unit_size` varchar(10) , `unit_key` bigint , `unit_type_key` int , `unit_type` varchar(24) , `unit_vehicle` int , `unit_drive_up` int , `unit_climate_controlled` int , `unit_floor` int , `reservation_time` timestamp , `reservation_move_in_original_day` date , `reservation_move_in_day` date , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_facility_key` bigint , `reservation_facility_name` varchar(255) , `reservation_facility_address` varchar(255) , `reservation_facility_city` varchar(100) , `reservation_facility_state` varchar(2) , `reservation_facility_msa` varchar(150) , `reservation_facility_zip` varchar(6) , `reservation_facility_latitude` decimal , `reservation_facility_longitude` decimal , `reservation_facility_aaa_active` int , `reservation_facility_truck_rental` int , `reservation_facility_free_truck_rental` int , `reservation_facility_listing_type_key` int , `reservation_facility_listing_type` varchar(100) , `reservation_npv` decimal , `facility_client_key` bigint , `facility_client_name` varchar(255) , `landing_page_facility_key` bigint , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_facility_in_directory` int , `landing_page_site_content_key` bigint , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_template_key` int , `landing_page_template_name` varchar(64) , `landing_page_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type_name` varchar(128) , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-04/1559650386'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_visitor" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-04/1559650386
- id: 4669648
- processed: 1
- raw_data:
{ "_origin": "84", "annotations": "83", "audit_id": "0", "cc_delivered_calls": "26", "cc_handled_calls": "28", "cc_inbound_calls": "27", "confirmed_npv": "36", "device_type": "6", "facility_client_key": "69", "facility_client_name": "70", "first_reservation_key": "38", "first_reservation_touchpoint": "39", "geo_ip_city": "12", "geo_ip_latitude": "16", "geo_ip_longitude": "17", "geo_ip_msa": "15", "geo_ip_state": "13", "geo_ip_zip": "14", "granular_search_city": "20", "granular_search_key": "18", "granular_search_latitude": "23", "granular_search_longitude": "24", "granular_search_msa": "25", "granular_search_state": "21", "granular_search_street_address": "19", "granular_search_zip": "22", "ip_address": "11", "landing_page_client_key": "73", "landing_page_facility_in_directory": "74", "landing_page_facility_key": "71", "landing_page_facility_name": "72", "landing_page_page_type_key": "81", "landing_page_page_type_name": "82", "landing_page_site_content_key": "75", "landing_page_site_content_title": "76", "landing_page_site_content_uri": "77", "landing_page_template_key": "78", "landing_page_template_name": "79", "landing_page_template_type": "80", "move_ins": "34", "page_views": "30", "reconciled_reservations": "33", "reservation_auto_state": "53", "reservation_facility_aaa_active": "63", "reservation_facility_address": "56", "reservation_facility_city": "57", "reservation_facility_free_truck_rental": "65", "reservation_facility_key": "54", "reservation_facility_latitude": "61", "reservation_facility_listing_type": "67", "reservation_facility_listing_type_key": "66", "reservation_facility_longitude": "62", "reservation_facility_msa": "59", "reservation_facility_name": "55", "reservation_facility_state": "58", "reservation_facility_truck_rental": "64", "reservation_facility_zip": "60", "reservation_move_in_day": "51", "reservation_move_in_original_day": "50", "reservation_npv": "68", "reservation_state": "52", "reservation_time": "49", "search_type": "37", "searches_before_reservation": "29", "site": "8", "site_key": "7", "sum_npv": "35", "traffic_source": "10", "traffic_source_key": "9", "unique_facility_clicks": "31", "unit_climate_controlled": "47", "unit_drive_up": "46", "unit_floor": "48", "unit_key": "42", "unit_price": "40", "unit_size": "41", "unit_type": "44", "unit_type_key": "43", "unit_vehicle": "45", "user_agent": "5", "valid_reservations": "32", "visit_day": "1", "visit_day_key": "2", "visit_time": "3", "visitor_key": "4" } - schema_attributes:
{ "_origin": "string", "annotations": "varchar(2048)", "audit_id": "bigint", "cc_delivered_calls": "int", "cc_handled_calls": "int", "cc_inbound_calls": "int", "confirmed_npv": "decimal", "device_type": "varchar(10)", "facility_client_key": "bigint", "facility_client_name": "varchar(255)", "first_reservation_key": "varchar(30)", "first_reservation_touchpoint": "varchar(10)", "geo_ip_city": "varchar(30)", "geo_ip_latitude": "decimal", "geo_ip_longitude": "decimal", "geo_ip_msa": "varchar(150)", "geo_ip_state": "varchar(20)", "geo_ip_zip": "varchar(10)", "granular_search_city": "varchar(100)", "granular_search_key": "bigint", "granular_search_latitude": "decimal", "granular_search_longitude": "decimal", "granular_search_msa": "varchar(150)", "granular_search_state": "varchar(2)", "granular_search_street_address": "varchar(255)", "granular_search_zip": "varchar(6)", "ip_address": "varchar(20)", "landing_page_client_key": "bigint", "landing_page_facility_in_directory": "int", "landing_page_facility_key": "bigint", "landing_page_facility_name": "varchar(255)", "landing_page_page_type_key": "int", "landing_page_page_type_name": "varchar(128)", "landing_page_site_content_key": "bigint", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "landing_page_template_key": "int", "landing_page_template_name": "varchar(64)", "landing_page_template_type": "varchar(64)", "move_ins": "int", "page_views": "int", "reconciled_reservations": "int", "reservation_auto_state": "varchar(20)", "reservation_facility_aaa_active": "int", "reservation_facility_address": "varchar(255)", "reservation_facility_city": "varchar(100)", "reservation_facility_free_truck_rental": "int", "reservation_facility_key": "bigint", "reservation_facility_latitude": "decimal", "reservation_facility_listing_type": "varchar(100)", "reservation_facility_listing_type_key": "int", "reservation_facility_longitude": "decimal", "reservation_facility_msa": "varchar(150)", "reservation_facility_name": "varchar(255)", "reservation_facility_state": "varchar(2)", "reservation_facility_truck_rental": "int", "reservation_facility_zip": "varchar(6)", "reservation_move_in_day": "date", "reservation_move_in_original_day": "date", "reservation_npv": "decimal", "reservation_state": "varchar(20)", "reservation_time": "timestamp", "search_type": "varchar(50)", "searches_before_reservation": "int", "site": "varchar(255)", "site_key": "int", "sum_npv": "decimal", "traffic_source": "varchar(128)", "traffic_source_key": "int", "unique_facility_clicks": "int", "unit_climate_controlled": "int", "unit_drive_up": "int", "unit_floor": "int", "unit_key": "bigint", "unit_price": "decimal", "unit_size": "varchar(10)", "unit_type": "varchar(24)", "unit_type_key": "int", "unit_vehicle": "int", "user_agent": "varchar(255)", "valid_reservations": "int", "visit_day": "date", "visit_day_key": "int", "visit_time": "timestamp", "visitor_key": "bigint" } - schema_name_id: 685
- schema_scan_id: None
- updated: 2019-06-04 07:53:58
-
Version 4669423
- created: 2019-05-26 15:10:04
- ddl:
[ "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_visitor`\n(\n `audit_id` bigint , `visit_day` date , `visit_day_key` int , `visit_time` timestamp , `visitor_key` bigint , `user_agent` varchar(255) , `device_type` varchar(10) , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `ip_address` varchar(20) , `geo_ip_city` varchar(30) , `geo_ip_state` varchar(20) , `geo_ip_zip` varchar(10) , `geo_ip_msa` varchar(150) , `geo_ip_latitude` decimal , `geo_ip_longitude` decimal , `granular_search_key` bigint , `granular_search_street_address` varchar(255) , `granular_search_city` varchar(100) , `granular_search_state` varchar(2) , `granular_search_zip` varchar(6) , `granular_search_latitude` decimal , `granular_search_longitude` decimal , `granular_search_msa` varchar(150) , `cc_delivered_calls` int , `cc_inbound_calls` int , `cc_handled_calls` int , `searches_before_reservation` int , `page_views` int , `unique_facility_clicks` int , `valid_reservations` int , `reconciled_reservations` int , `move_ins` int , `sum_npv` decimal , `confirmed_npv` decimal , `search_type` varchar(50) , `first_reservation_key` varchar(30) , `first_reservation_touchpoint` varchar(10) , `unit_price` decimal , `unit_size` varchar(10) , `unit_key` bigint , `unit_type_key` int , `unit_type` varchar(24) , `unit_vehicle` int , `unit_drive_up` int , `unit_climate_controlled` int , `unit_floor` int , `reservation_time` timestamp , `reservation_move_in_original_day` date , `reservation_move_in_day` date , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_facility_key` bigint , `reservation_facility_name` varchar(255) , `reservation_facility_address` varchar(255) , `reservation_facility_city` varchar(100) , `reservation_facility_state` varchar(2) , `reservation_facility_msa` varchar(150) , `reservation_facility_zip` varchar(6) , `reservation_facility_latitude` decimal , `reservation_facility_longitude` decimal , `reservation_facility_aaa_active` int , `reservation_facility_truck_rental` int , `reservation_facility_free_truck_rental` int , `reservation_facility_listing_type_key` int , `reservation_facility_listing_type` varchar(100) , `reservation_npv` decimal , `facility_client_key` bigint , `facility_client_name` varchar(255) , `landing_page_facility_key` bigint , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_facility_in_directory` int , `landing_page_site_content_key` bigint , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_template_key` int , `landing_page_template_name` varchar(64) , `landing_page_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type_name` varchar(128) , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-05-19/1558292421'\n", "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_visitor`", "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_visitor`\n(\n `audit_id` bigint , `visit_day` date , `visit_day_key` int , `visit_time` timestamp , `visitor_key` bigint , `user_agent` varchar(255) , `device_type` varchar(10) , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `ip_address` varchar(20) , `geo_ip_city` varchar(30) , `geo_ip_state` varchar(20) , `geo_ip_zip` varchar(10) , `geo_ip_msa` varchar(150) , `geo_ip_latitude` decimal , `geo_ip_longitude` decimal , `granular_search_key` bigint , `granular_search_street_address` varchar(255) , `granular_search_city` varchar(100) , `granular_search_state` varchar(2) , `granular_search_zip` varchar(6) , `granular_search_latitude` decimal , `granular_search_longitude` decimal , `granular_search_msa` varchar(150) , `cc_delivered_calls` int , `cc_inbound_calls` int , `cc_handled_calls` int , `searches_before_reservation` int , `page_views` int , `unique_facility_clicks` int , `valid_reservations` int , `reconciled_reservations` int , `move_ins` int , `sum_npv` decimal , `confirmed_npv` decimal , `search_type` varchar(50) , `first_reservation_key` varchar(30) , `first_reservation_touchpoint` varchar(10) , `unit_price` decimal , `unit_size` varchar(10) , `unit_key` bigint , `unit_type_key` int , `unit_type` varchar(24) , `unit_vehicle` int , `unit_drive_up` int , `unit_climate_controlled` int , `unit_floor` int , `reservation_time` timestamp , `reservation_move_in_original_day` date , `reservation_move_in_day` date , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_facility_key` bigint , `reservation_facility_name` varchar(255) , `reservation_facility_address` varchar(255) , `reservation_facility_city` varchar(100) , `reservation_facility_state` varchar(2) , `reservation_facility_msa` varchar(150) , `reservation_facility_zip` varchar(6) , `reservation_facility_latitude` decimal , `reservation_facility_longitude` decimal , `reservation_facility_aaa_active` int , `reservation_facility_truck_rental` int , `reservation_facility_free_truck_rental` int , `reservation_facility_listing_type_key` int , `reservation_facility_listing_type` varchar(100) , `reservation_npv` decimal , `facility_client_key` bigint , `facility_client_name` varchar(255) , `landing_page_facility_key` bigint , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_facility_in_directory` int , `landing_page_site_content_key` bigint , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_template_key` int , `landing_page_template_name` varchar(64) , `landing_page_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type_name` varchar(128) , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-05-26/1558897218'\n", "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_visitor" ] - hive_path: s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-05-26/1558897218
- id: 4669423
- processed: 1
- raw_data:
{ "_origin": "84", "annotations": "83", "audit_id": "0", "cc_delivered_calls": "26", "cc_handled_calls": "28", "cc_inbound_calls": "27", "confirmed_npv": "36", "device_type": "6", "facility_client_key": "69", "facility_client_name": "70", "first_reservation_key": "38", "first_reservation_touchpoint": "39", "geo_ip_city": "12", "geo_ip_latitude": "16", "geo_ip_longitude": "17", "geo_ip_msa": "15", "geo_ip_state": "13", "geo_ip_zip": "14", "granular_search_city": "20", "granular_search_key": "18", "granular_search_latitude": "23", "granular_search_longitude": "24", "granular_search_msa": "25", "granular_search_state": "21", "granular_search_street_address": "19", "granular_search_zip": "22", "ip_address": "11", "landing_page_client_key": "73", "landing_page_facility_in_directory": "74", "landing_page_facility_key": "71", "landing_page_facility_name": "72", "landing_page_page_type_key": "81", "landing_page_page_type_name": "82", "landing_page_site_content_key": "75", "landing_page_site_content_title": "76", "landing_page_site_content_uri": "77", "landing_page_template_key": "78", "landing_page_template_name": "79", "landing_page_template_type": "80", "move_ins": "34", "page_views": "30", "reconciled_reservations": "33", "reservation_auto_state": "53", "reservation_facility_aaa_active": "63", "reservation_facility_address": "56", "reservation_facility_city": "57", "reservation_facility_free_truck_rental": "65", "reservation_facility_key": "54", "reservation_facility_latitude": "61", "reservation_facility_listing_type": "67", "reservation_facility_listing_type_key": "66", "reservation_facility_longitude": "62", "reservation_facility_msa": "59", "reservation_facility_name": "55", "reservation_facility_state": "58", "reservation_facility_truck_rental": "64", "reservation_facility_zip": "60", "reservation_move_in_day": "51", "reservation_move_in_original_day": "50", "reservation_npv": "68", "reservation_state": "52", "reservation_time": "49", "search_type": "37", "searches_before_reservation": "29", "site": "8", "site_key": "7", "sum_npv": "35", "traffic_source": "10", "traffic_source_key": "9", "unique_facility_clicks": "31", "unit_climate_controlled": "47", "unit_drive_up": "46", "unit_floor": "48", "unit_key": "42", "unit_price": "40", "unit_size": "41", "unit_type": "44", "unit_type_key": "43", "unit_vehicle": "45", "user_agent": "5", "valid_reservations": "32", "visit_day": "1", "visit_day_key": "2", "visit_time": "3", "visitor_key": "4" } - schema_attributes:
{ "_origin": "string", "annotations": "varchar(2048)", "audit_id": "bigint", "cc_delivered_calls": "int", "cc_handled_calls": "int", "cc_inbound_calls": "int", "confirmed_npv": "decimal", "device_type": "varchar(10)", "facility_client_key": "bigint", "facility_client_name": "varchar(255)", "first_reservation_key": "varchar(30)", "first_reservation_touchpoint": "varchar(10)", "geo_ip_city": "varchar(30)", "geo_ip_latitude": "decimal", "geo_ip_longitude": "decimal", "geo_ip_msa": "varchar(150)", "geo_ip_state": "varchar(20)", "geo_ip_zip": "varchar(10)", "granular_search_city": "varchar(100)", "granular_search_key": "bigint", "granular_search_latitude": "decimal", "granular_search_longitude": "decimal", "granular_search_msa": "varchar(150)", "granular_search_state": "varchar(2)", "granular_search_street_address": "varchar(255)", "granular_search_zip": "varchar(6)", "ip_address": "varchar(20)", "landing_page_client_key": "bigint", "landing_page_facility_in_directory": "int", "landing_page_facility_key": "bigint", "landing_page_facility_name": "varchar(255)", "landing_page_page_type_key": "int", "landing_page_page_type_name": "varchar(128)", "landing_page_site_content_key": "bigint", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "landing_page_template_key": "int", "landing_page_template_name": "varchar(64)", "landing_page_template_type": "varchar(64)", "move_ins": "int", "page_views": "int", "reconciled_reservations": "int", "reservation_auto_state": "varchar(20)", "reservation_facility_aaa_active": "int", "reservation_facility_address": "varchar(255)", "reservation_facility_city": "varchar(100)", "reservation_facility_free_truck_rental": "int", "reservation_facility_key": "bigint", "reservation_facility_latitude": "decimal", "reservation_facility_listing_type": "varchar(100)", "reservation_facility_listing_type_key": "int", "reservation_facility_longitude": "decimal", "reservation_facility_msa": "varchar(150)", "reservation_facility_name": "varchar(255)", "reservation_facility_state": "varchar(2)", "reservation_facility_truck_rental": "int", "reservation_facility_zip": "varchar(6)", "reservation_move_in_day": "date", "reservation_move_in_original_day": "date", "reservation_npv": "decimal", "reservation_state": "varchar(20)", "reservation_time": "timestamp", "search_type": "varchar(50)", "searches_before_reservation": "int", "site": "varchar(255)", "site_key": "int", "sum_npv": "decimal", "traffic_source": "varchar(128)", "traffic_source_key": "int", "unique_facility_clicks": "int", "unit_climate_controlled": "int", "unit_drive_up": "int", "unit_floor": "int", "unit_key": "bigint", "unit_price": "decimal", "unit_size": "varchar(10)", "unit_type": "varchar(24)", "unit_type_key": "int", "unit_vehicle": "int", "user_agent": "varchar(255)", "valid_reservations": "int", "visit_day": "date", "visit_day_key": "int", "visit_time": "timestamp", "visitor_key": "bigint" } - schema_name_id: 685
- schema_scan_id: None
- updated: 2019-05-26 15:18:00
Schema Scans: 0
- count: 21
- ddl:
[ "ALTER TABLE\n `sfdl_dev_redshift.analytics_mart_visitor`\nADD\n\n\n PARTITION (dt='2019-05-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-19/'\n PARTITION (dt='2019-05-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-20/'\n PARTITION (dt='2019-05-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-21/'\n PARTITION (dt='2019-05-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-22/'\n PARTITION (dt='2019-05-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-23/'\n PARTITION (dt='2019-05-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-24/'\n PARTITION (dt='2019-05-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-25/'\n PARTITION (dt='2019-05-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-26/'\n PARTITION (dt='2019-05-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-27/'\n PARTITION (dt='2019-05-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-28/'\n PARTITION (dt='2019-05-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-29/'\n PARTITION (dt='2019-05-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-30/'\n PARTITION (dt='2019-05-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-31/'\n PARTITION (dt='2019-06-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-01/'\n PARTITION (dt='2019-06-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-02/'\n PARTITION (dt='2019-06-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-03/'\n PARTITION (dt='2019-06-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-04/'\n PARTITION (dt='2019-06-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-05/'\n PARTITION (dt='2019-06-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-06/'\n PARTITION (dt='2019-06-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-07/'\n PARTITION (dt='2019-06-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-08/'\n;" ] - name: dt
- state:
[ { "info": { "id": 140457, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-19/", "name": "dt", "value": "2019-05-19" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-05-26 15:10:27", "last_data": "2019-06-09 15:09:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140460, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-20/", "name": "dt", "value": "2019-05-20" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-05-26 15:10:49", "last_data": "2019-06-09 15:09:54" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140455, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-21/", "name": "dt", "value": "2019-05-21" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-05-26 15:10:21", "last_data": "2019-06-09 15:09:41" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140459, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-22/", "name": "dt", "value": "2019-05-22" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-05-26 15:10:39", "last_data": "2019-06-09 15:09:27" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140458, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-23/", "name": "dt", "value": "2019-05-23" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-05-26 15:10:30", "last_data": "2019-06-09 15:09:49" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140456, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-24/", "name": "dt", "value": "2019-05-24" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-05-26 15:10:26", "last_data": "2019-06-09 15:09:44" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140454, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-25/", "name": "dt", "value": "2019-05-25" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-05-26 15:10:11", "last_data": "2019-06-09 15:09:53" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140931, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-26/", "name": "dt", "value": "2019-05-26" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:46:21", "last_data": "2019-06-09 15:09:33" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140938, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-27/", "name": "dt", "value": "2019-05-27" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:47:00", "last_data": "2019-06-09 15:09:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140936, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-28/", "name": "dt", "value": "2019-05-28" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:46:51", "last_data": "2019-06-09 15:09:21" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140934, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-29/", "name": "dt", "value": "2019-05-29" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:46:32", "last_data": "2019-06-09 15:09:34" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140930, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-30/", "name": "dt", "value": "2019-05-30" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:46:19", "last_data": "2019-06-09 15:10:00" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140933, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-31/", "name": "dt", "value": "2019-05-31" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:46:27", "last_data": "2019-06-09 15:09:42" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140937, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-01/", "name": "dt", "value": "2019-06-01" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:46:58", "last_data": "2019-06-09 15:10:02" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140932, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-02/", "name": "dt", "value": "2019-06-02" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:46:23", "last_data": "2019-06-09 15:09:43" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 140935, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-03/", "name": "dt", "value": "2019-06-03" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-04 07:46:36", "last_data": "2019-06-09 15:09:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 141153, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-04/", "name": "dt", "value": "2019-06-04" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-09 15:09:22", "last_data": "2019-06-09 15:09:22" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 141154, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-05/", "name": "dt", "value": "2019-06-05" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-09 15:09:52", "last_data": "2019-06-09 15:09:52" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 141157, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-06/", "name": "dt", "value": "2019-06-06" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-09 15:10:05", "last_data": "2019-06-09 15:10:05" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 141155, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-07/", "name": "dt", "value": "2019-06-07" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-09 15:09:58", "last_data": "2019-06-09 15:09:58" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } }, { "info": { "id": 141156, "location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-08/", "name": "dt", "value": "2019-06-08" }, "state": { "arrival": { "athena_discovery": true, "first_data": "2019-06-09 15:10:03", "last_data": "2019-06-09 15:10:03" }, "parquet": { "first_performed": null, "in_progress": null, "job_id": null, "last_performed": null, "queued": false } } } ] - type: string
- attributes:
{ "_origin": "string", "annotations": "varchar(2048)", "audit_id": "bigint", "cc_delivered_calls": "int", "cc_handled_calls": "int", "cc_inbound_calls": "int", "confirmed_npv": "decimal", "device_type": "varchar(10)", "facility_client_key": "bigint", "facility_client_name": "varchar(255)", "first_reservation_key": "varchar(30)", "first_reservation_touchpoint": "varchar(10)", "geo_ip_city": "varchar(30)", "geo_ip_latitude": "decimal", "geo_ip_longitude": "decimal", "geo_ip_msa": "varchar(150)", "geo_ip_state": "varchar(20)", "geo_ip_zip": "varchar(10)", "granular_search_city": "varchar(100)", "granular_search_key": "bigint", "granular_search_latitude": "decimal", "granular_search_longitude": "decimal", "granular_search_msa": "varchar(150)", "granular_search_state": "varchar(2)", "granular_search_street_address": "varchar(255)", "granular_search_zip": "varchar(6)", "ip_address": "varchar(20)", "landing_page_client_key": "bigint", "landing_page_facility_in_directory": "int", "landing_page_facility_key": "bigint", "landing_page_facility_name": "varchar(255)", "landing_page_page_type_key": "int", "landing_page_page_type_name": "varchar(128)", "landing_page_site_content_key": "bigint", "landing_page_site_content_title": "varchar(255)", "landing_page_site_content_uri": "varchar(128)", "landing_page_template_key": "int", "landing_page_template_name": "varchar(64)", "landing_page_template_type": "varchar(64)", "move_ins": "int", "page_views": "int", "reconciled_reservations": "int", "reservation_auto_state": "varchar(20)", "reservation_facility_aaa_active": "int", "reservation_facility_address": "varchar(255)", "reservation_facility_city": "varchar(100)", "reservation_facility_free_truck_rental": "int", "reservation_facility_key": "bigint", "reservation_facility_latitude": "decimal", "reservation_facility_listing_type": "varchar(100)", "reservation_facility_listing_type_key": "int", "reservation_facility_longitude": "decimal", "reservation_facility_msa": "varchar(150)", "reservation_facility_name": "varchar(255)", "reservation_facility_state": "varchar(2)", "reservation_facility_truck_rental": "int", "reservation_facility_zip": "varchar(6)", "reservation_move_in_day": "date", "reservation_move_in_original_day": "date", "reservation_npv": "decimal", "reservation_state": "varchar(20)", "reservation_time": "timestamp", "search_type": "varchar(50)", "searches_before_reservation": "int", "site": "varchar(255)", "site_key": "int", "sum_npv": "decimal", "traffic_source": "varchar(128)", "traffic_source_key": "int", "unique_facility_clicks": "int", "unit_climate_controlled": "int", "unit_drive_up": "int", "unit_floor": "int", "unit_key": "bigint", "unit_price": "decimal", "unit_size": "varchar(10)", "unit_type": "varchar(24)", "unit_type_key": "int", "unit_vehicle": "int", "user_agent": "varchar(255)", "valid_reservations": "int", "visit_day": "date", "visit_day_key": "int", "visit_time": "timestamp", "visitor_key": "bigint" } - created: 2019-06-09 15:09:16
- ddl:
{ "create_database": false, "create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_visitor`\n(\n `audit_id` bigint , `visit_day` date , `visit_day_key` int , `visit_time` timestamp , `visitor_key` bigint , `user_agent` varchar(255) , `device_type` varchar(10) , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `ip_address` varchar(20) , `geo_ip_city` varchar(30) , `geo_ip_state` varchar(20) , `geo_ip_zip` varchar(10) , `geo_ip_msa` varchar(150) , `geo_ip_latitude` decimal , `geo_ip_longitude` decimal , `granular_search_key` bigint , `granular_search_street_address` varchar(255) , `granular_search_city` varchar(100) , `granular_search_state` varchar(2) , `granular_search_zip` varchar(6) , `granular_search_latitude` decimal , `granular_search_longitude` decimal , `granular_search_msa` varchar(150) , `cc_delivered_calls` int , `cc_inbound_calls` int , `cc_handled_calls` int , `searches_before_reservation` int , `page_views` int , `unique_facility_clicks` int , `valid_reservations` int , `reconciled_reservations` int , `move_ins` int , `sum_npv` decimal , `confirmed_npv` decimal , `search_type` varchar(50) , `first_reservation_key` varchar(30) , `first_reservation_touchpoint` varchar(10) , `unit_price` decimal , `unit_size` varchar(10) , `unit_key` bigint , `unit_type_key` int , `unit_type` varchar(24) , `unit_vehicle` int , `unit_drive_up` int , `unit_climate_controlled` int , `unit_floor` int , `reservation_time` timestamp , `reservation_move_in_original_day` date , `reservation_move_in_day` date , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_facility_key` bigint , `reservation_facility_name` varchar(255) , `reservation_facility_address` varchar(255) , `reservation_facility_city` varchar(100) , `reservation_facility_state` varchar(2) , `reservation_facility_msa` varchar(150) , `reservation_facility_zip` varchar(6) , `reservation_facility_latitude` decimal , `reservation_facility_longitude` decimal , `reservation_facility_aaa_active` int , `reservation_facility_truck_rental` int , `reservation_facility_free_truck_rental` int , `reservation_facility_listing_type_key` int , `reservation_facility_listing_type` varchar(100) , `reservation_npv` decimal , `facility_client_key` bigint , `facility_client_name` varchar(255) , `landing_page_facility_key` bigint , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_facility_in_directory` int , `landing_page_site_content_key` bigint , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_template_key` int , `landing_page_template_name` varchar(64) , `landing_page_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type_name` varchar(128) , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818'\n", "drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_visitor`", "repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_visitor" }
- hostname: schemamanager-5447774fc6-4w58v
- name: schema_manager
- process_start: 2026-04-02 21:43:44
- sf_env: dev
- version: 2427328685
{
"name": {
"created": "2018-03-26 17:19:29",
"disabled": false,
"format": "raw",
"id": 685,
"is_partitioned": true,
"is_schema_datatyped": false,
"name": {
"database": "sfdl_dev_redshift",
"table": "analytics_mart_visitor"
},
"type": "redshift"
},
"partition": {
"count": 21,
"ddl": [
"ALTER TABLE\n `sfdl_dev_redshift.analytics_mart_visitor`\nADD\n\n\n PARTITION (dt='2019-05-19') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-19/'\n PARTITION (dt='2019-05-20') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-20/'\n PARTITION (dt='2019-05-21') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-21/'\n PARTITION (dt='2019-05-22') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-22/'\n PARTITION (dt='2019-05-23') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-23/'\n PARTITION (dt='2019-05-24') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-24/'\n PARTITION (dt='2019-05-25') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-25/'\n PARTITION (dt='2019-05-26') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-26/'\n PARTITION (dt='2019-05-27') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-27/'\n PARTITION (dt='2019-05-28') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-28/'\n PARTITION (dt='2019-05-29') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-29/'\n PARTITION (dt='2019-05-30') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-30/'\n PARTITION (dt='2019-05-31') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-31/'\n PARTITION (dt='2019-06-01') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-01/'\n PARTITION (dt='2019-06-02') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-02/'\n PARTITION (dt='2019-06-03') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-03/'\n PARTITION (dt='2019-06-04') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-04/'\n PARTITION (dt='2019-06-05') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-05/'\n PARTITION (dt='2019-06-06') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-06/'\n PARTITION (dt='2019-06-07') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-07/'\n PARTITION (dt='2019-06-08') location 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-08/'\n;"
],
"name": "dt",
"state": [
{
"info": {
"id": 140457,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-19/",
"name": "dt",
"value": "2019-05-19"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-05-26 15:10:27",
"last_data": "2019-06-09 15:09:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140460,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-20/",
"name": "dt",
"value": "2019-05-20"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-05-26 15:10:49",
"last_data": "2019-06-09 15:09:54"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140455,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-21/",
"name": "dt",
"value": "2019-05-21"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-05-26 15:10:21",
"last_data": "2019-06-09 15:09:41"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140459,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-22/",
"name": "dt",
"value": "2019-05-22"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-05-26 15:10:39",
"last_data": "2019-06-09 15:09:27"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140458,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-23/",
"name": "dt",
"value": "2019-05-23"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-05-26 15:10:30",
"last_data": "2019-06-09 15:09:49"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140456,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-24/",
"name": "dt",
"value": "2019-05-24"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-05-26 15:10:26",
"last_data": "2019-06-09 15:09:44"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140454,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-25/",
"name": "dt",
"value": "2019-05-25"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-05-26 15:10:11",
"last_data": "2019-06-09 15:09:53"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140931,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-26/",
"name": "dt",
"value": "2019-05-26"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:46:21",
"last_data": "2019-06-09 15:09:33"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140938,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-27/",
"name": "dt",
"value": "2019-05-27"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:47:00",
"last_data": "2019-06-09 15:09:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140936,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-28/",
"name": "dt",
"value": "2019-05-28"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:46:51",
"last_data": "2019-06-09 15:09:21"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140934,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-29/",
"name": "dt",
"value": "2019-05-29"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:46:32",
"last_data": "2019-06-09 15:09:34"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140930,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-30/",
"name": "dt",
"value": "2019-05-30"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:46:19",
"last_data": "2019-06-09 15:10:00"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140933,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-05-31/",
"name": "dt",
"value": "2019-05-31"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:46:27",
"last_data": "2019-06-09 15:09:42"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140937,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-01/",
"name": "dt",
"value": "2019-06-01"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:46:58",
"last_data": "2019-06-09 15:10:02"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140932,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-02/",
"name": "dt",
"value": "2019-06-02"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:46:23",
"last_data": "2019-06-09 15:09:43"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 140935,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-03/",
"name": "dt",
"value": "2019-06-03"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-04 07:46:36",
"last_data": "2019-06-09 15:09:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 141153,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-04/",
"name": "dt",
"value": "2019-06-04"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-09 15:09:22",
"last_data": "2019-06-09 15:09:22"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 141154,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-05/",
"name": "dt",
"value": "2019-06-05"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-09 15:09:52",
"last_data": "2019-06-09 15:09:52"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 141157,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-06/",
"name": "dt",
"value": "2019-06-06"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-09 15:10:05",
"last_data": "2019-06-09 15:10:05"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 141155,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-07/",
"name": "dt",
"value": "2019-06-07"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-09 15:09:58",
"last_data": "2019-06-09 15:09:58"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
},
{
"info": {
"id": 141156,
"location": "s3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818/dt=2019-06-08/",
"name": "dt",
"value": "2019-06-08"
},
"state": {
"arrival": {
"athena_discovery": true,
"first_data": "2019-06-09 15:10:03",
"last_data": "2019-06-09 15:10:03"
},
"parquet": {
"first_performed": null,
"in_progress": null,
"job_id": null,
"last_performed": null,
"queued": false
}
}
}
],
"type": "string"
},
"schema": {
"attributes": {
"_origin": "string",
"annotations": "varchar(2048)",
"audit_id": "bigint",
"cc_delivered_calls": "int",
"cc_handled_calls": "int",
"cc_inbound_calls": "int",
"confirmed_npv": "decimal",
"device_type": "varchar(10)",
"facility_client_key": "bigint",
"facility_client_name": "varchar(255)",
"first_reservation_key": "varchar(30)",
"first_reservation_touchpoint": "varchar(10)",
"geo_ip_city": "varchar(30)",
"geo_ip_latitude": "decimal",
"geo_ip_longitude": "decimal",
"geo_ip_msa": "varchar(150)",
"geo_ip_state": "varchar(20)",
"geo_ip_zip": "varchar(10)",
"granular_search_city": "varchar(100)",
"granular_search_key": "bigint",
"granular_search_latitude": "decimal",
"granular_search_longitude": "decimal",
"granular_search_msa": "varchar(150)",
"granular_search_state": "varchar(2)",
"granular_search_street_address": "varchar(255)",
"granular_search_zip": "varchar(6)",
"ip_address": "varchar(20)",
"landing_page_client_key": "bigint",
"landing_page_facility_in_directory": "int",
"landing_page_facility_key": "bigint",
"landing_page_facility_name": "varchar(255)",
"landing_page_page_type_key": "int",
"landing_page_page_type_name": "varchar(128)",
"landing_page_site_content_key": "bigint",
"landing_page_site_content_title": "varchar(255)",
"landing_page_site_content_uri": "varchar(128)",
"landing_page_template_key": "int",
"landing_page_template_name": "varchar(64)",
"landing_page_template_type": "varchar(64)",
"move_ins": "int",
"page_views": "int",
"reconciled_reservations": "int",
"reservation_auto_state": "varchar(20)",
"reservation_facility_aaa_active": "int",
"reservation_facility_address": "varchar(255)",
"reservation_facility_city": "varchar(100)",
"reservation_facility_free_truck_rental": "int",
"reservation_facility_key": "bigint",
"reservation_facility_latitude": "decimal",
"reservation_facility_listing_type": "varchar(100)",
"reservation_facility_listing_type_key": "int",
"reservation_facility_longitude": "decimal",
"reservation_facility_msa": "varchar(150)",
"reservation_facility_name": "varchar(255)",
"reservation_facility_state": "varchar(2)",
"reservation_facility_truck_rental": "int",
"reservation_facility_zip": "varchar(6)",
"reservation_move_in_day": "date",
"reservation_move_in_original_day": "date",
"reservation_npv": "decimal",
"reservation_state": "varchar(20)",
"reservation_time": "timestamp",
"search_type": "varchar(50)",
"searches_before_reservation": "int",
"site": "varchar(255)",
"site_key": "int",
"sum_npv": "decimal",
"traffic_source": "varchar(128)",
"traffic_source_key": "int",
"unique_facility_clicks": "int",
"unit_climate_controlled": "int",
"unit_drive_up": "int",
"unit_floor": "int",
"unit_key": "bigint",
"unit_price": "decimal",
"unit_size": "varchar(10)",
"unit_type": "varchar(24)",
"unit_type_key": "int",
"unit_vehicle": "int",
"user_agent": "varchar(255)",
"valid_reservations": "int",
"visit_day": "date",
"visit_day_key": "int",
"visit_time": "timestamp",
"visitor_key": "bigint"
},
"created": "2019-06-09 15:09:16",
"ddl": {
"create_database": false,
"create_table": "CREATE EXTERNAL TABLE IF NOT EXISTS\n`sfdl_dev_redshift.analytics_mart_visitor`\n(\n `audit_id` bigint , `visit_day` date , `visit_day_key` int , `visit_time` timestamp , `visitor_key` bigint , `user_agent` varchar(255) , `device_type` varchar(10) , `site_key` int , `site` varchar(255) , `traffic_source_key` int , `traffic_source` varchar(128) , `ip_address` varchar(20) , `geo_ip_city` varchar(30) , `geo_ip_state` varchar(20) , `geo_ip_zip` varchar(10) , `geo_ip_msa` varchar(150) , `geo_ip_latitude` decimal , `geo_ip_longitude` decimal , `granular_search_key` bigint , `granular_search_street_address` varchar(255) , `granular_search_city` varchar(100) , `granular_search_state` varchar(2) , `granular_search_zip` varchar(6) , `granular_search_latitude` decimal , `granular_search_longitude` decimal , `granular_search_msa` varchar(150) , `cc_delivered_calls` int , `cc_inbound_calls` int , `cc_handled_calls` int , `searches_before_reservation` int , `page_views` int , `unique_facility_clicks` int , `valid_reservations` int , `reconciled_reservations` int , `move_ins` int , `sum_npv` decimal , `confirmed_npv` decimal , `search_type` varchar(50) , `first_reservation_key` varchar(30) , `first_reservation_touchpoint` varchar(10) , `unit_price` decimal , `unit_size` varchar(10) , `unit_key` bigint , `unit_type_key` int , `unit_type` varchar(24) , `unit_vehicle` int , `unit_drive_up` int , `unit_climate_controlled` int , `unit_floor` int , `reservation_time` timestamp , `reservation_move_in_original_day` date , `reservation_move_in_day` date , `reservation_state` varchar(20) , `reservation_auto_state` varchar(20) , `reservation_facility_key` bigint , `reservation_facility_name` varchar(255) , `reservation_facility_address` varchar(255) , `reservation_facility_city` varchar(100) , `reservation_facility_state` varchar(2) , `reservation_facility_msa` varchar(150) , `reservation_facility_zip` varchar(6) , `reservation_facility_latitude` decimal , `reservation_facility_longitude` decimal , `reservation_facility_aaa_active` int , `reservation_facility_truck_rental` int , `reservation_facility_free_truck_rental` int , `reservation_facility_listing_type_key` int , `reservation_facility_listing_type` varchar(100) , `reservation_npv` decimal , `facility_client_key` bigint , `facility_client_name` varchar(255) , `landing_page_facility_key` bigint , `landing_page_facility_name` varchar(255) , `landing_page_client_key` bigint , `landing_page_facility_in_directory` int , `landing_page_site_content_key` bigint , `landing_page_site_content_title` varchar(255) , `landing_page_site_content_uri` varchar(128) , `landing_page_template_key` int , `landing_page_template_name` varchar(64) , `landing_page_template_type` varchar(64) , `landing_page_page_type_key` int , `landing_page_page_type_name` varchar(128) , `annotations` varchar(2048) , `_origin` string \n)\nPARTITIONED BY (dt string)\nROW FORMAT SERDE\n'org.apache.hadoop.hive.serde2.lazy.LazySimpleSerDe'\n WITH SERDEPROPERTIES ( 'quote.delim' = '\"', 'escape.delim' = '\\\\', 'field.delim' = '\u0001')\nSTORED AS INPUTFORMAT\n 'org.apache.hadoop.mapred.TextInputFormat'\nOUTPUTFORMAT\n 'org.apache.hadoop.hive.ql.io.HiveIgnoreKeyTextOutputFormat'\nLOCATION\n 's3://sfdl-redshift-analytics-dev/separated_dt/mart_visitor/2019-06-09/1560106818'\n",
"drop_table": "DROP TABLE IF EXISTS `sfdl_dev_redshift.analytics_mart_visitor`",
"repair_table": "MSCK REPAIR TABLE sfdl_dev_redshift.analytics_mart_visitor"
}
},
"server": {
"hostname": "schemamanager-5447774fc6-4w58v",
"name": "schema_manager",
"process_start": "2026-04-02 21:43:44",
"sf_env": "dev",
"version": "2427328685"
}
}