Snowflake Reader Account Views Overview – Verizon Connect Enterprise Help

Views Overview

View Name	Description	View Type	Join Fields
address	Contains key details related to an address, including state, city, and suburb. Note that addresses are immutable.	Dimension	address_id
app_event	Contains details of events from miscellaneous mobile applications within the platform.	Fact	app_event_key, driver_key, event_type_key
condition	Contains data around the configured conditions that can trigger Insight Alerts.	Dimension	condition_key, condition_id
device	Contains information about the devices (hardware) installed in vehicles.	Dimension	device_id
device_link_history	Contains information about the link history of devices with units.	Fact	unit_id, device_id
driver	Contains key details related to a driver, including hierarchy information and other user details.	Dimension	driver_key
driver_day	Contains day-level aggregate KPIs related to a driver.	Fact	driver_key
driver_form_instance	Contains information about the driver forms related to the customer account.	Fact	form_instance_xml_id
eld_driving_period	Contains key details related to ELD driving period, including start time, end time and events.	Fact	driving_period_id, vehicle_key, unit_id
eld_driving_period_action	Contains key details related to ELD driving period actions including time of action and action_id.	Fact	driving_period_action_id, driving_period_id
event	Contains individual event data relating to units.	Fact	unit_id
hierarchy_node	Contains information about the hierarchy configured for an account.	Dimension	hierarchy_node_id
insight_alert	Contains data around Insight Alerts that have been triggered in the VZC Fleet platform.	Fact	condition_id, condition_key, vehicle_key, driver_key
install_type_diagnostic_parameter	Contains information about the diagnostic parameters configured for a particular install type.	Dimension	install_type_id
job_pva	Contains planned vs actual details for a job including its status, associated route and territory.	Fact	job_id, route_id, territory_key, marker_key
marker	Contains details of the markers for an account, including category and geometry details.	Dimension	marker_key
mobile_event_type	Contains details of the different mobile event types that can be present in the app_event fact	Dimension	mobile_event_type_key
nru_event	Details around time periods where units were determined to be non-reporting.	Fact	unit_id, vehicle_key, driver_id, driver_key
point_with_vehicle	Contains point data from vehicles, including GPS location, diagnostics, and other sensor data.	Fact	vehicle_key
point_with_vehicle_and_driver	Contains point data from vehicles, including driver, GPS location, diagnostics, and other sensor data.	Fact	driver_key, vehicle_key
route_pva	Contains planned vs actual details for a route including its status, job count and territory.	Fact	route_id, territory_key, vehicle_key, driver_key
territory	Contains details of the territory for an account, including its name and timezone.	Dimension	territory_key
time_on_site	Contains details about the duration a vehicle spent within markers at certain times.	Fact	vehicle_key, marker_key
trip	Contains trip-level aggregate KPIs related to a driver and associated vehicle.	Fact	driver_key, vehicle_key
trip_by_state	Contains trip-level aggregate KPIs related to a driver and associated vehicle. The data is the same as in the “trip” fact, with the exception that rows are further split when the vehicle crosses a state boundary.	Fact	driver_key, vehicle_key
unit_driver_history	Contains information relating to the assignment of drivers to vehicles.	Fact	unit_id, driver_id
vehicle	Contains key details related to a vehicle, including year, make, model, and time zone.	Dimension	vehicle_key, unit_id
vehicle_day	Contains day-level aggregate KPIs related to a vehicle.	Fact	vehicle_key
video_course	Contains information about video courses that may be taken by a driver via the Coach app.	Dimension	video_course_key

Note

The data available through Self-Service Analytics is shared using secure views and not tables. Querying with analytics tools that are trying to find the primary and foreign keys to map the relationships between tables does not work. Data and structure can change at any time, without notice.

Snowflake Reader Account

Views Overview

Note

Related articles