Snowflake is an analytic data warehouse provided as Software-as-a-Service (SaaS). Snowflake houses Verizon Connect Analytics 2.0 Platform with over 130 pre-built key performance indicators (KPIs), as well as our analytics tools. This combination of tools lets your teams collaborate better with one another, giving them actionable insights they can use to drive business transformation.
Fleet Analytics Reports, Fleet Scorecards, Fleet Scorecard Reports, Fleet Dashboards, Coach and Spotlight all use data from Verizon Connect Analytics 2.0 Platform.
Note
For guidance on Snowflake's version support, refer to https://docs.snowflake.com/en/release-notes/requirements.
Snowflake’s data warehouse is not built on an existing database or “big data” software platform, such as Hadoop. The Snowflake data warehouse uses a new SQL database engine with a unique architecture designed for the cloud.
Snowflake’s data warehouse is a true SaaS offering. More specifically:
-
You do not need to select, install, configure, or manage any hardware.
-
You do not need to install, configure, or manage any software.
-
Snowflake handles ongoing maintenance, management, and tuning.
Snowflake runs completely on cloud infrastructure. All components of Snowflake’s service (other than an optional command line client), run in a public cloud infrastructure.
A reader account enables Verizon Connect Fleet Ultimate customers to access and query data on Snowflake warehouse, with no setup or usage costs, and no requirements to sign a licensing agreement with Snowflake.
Reader Account allows Verizon Connect Fleet Ultimate customers to build configurable reports and dashboards using their preferred BI tool, by connecting to the Verizon Connect’s data warehouse provided by Snowflake.
The reader account is created, owned, and managed by Verizon Connect, which assumes all responsibility for credit charges incurred by users in the reader account. Verizon Connect uses shares to share databases with reader accounts; however, a reader account can consume data only from the provider account that created it.
When your reader account is set up, we assign a default role for you to use, named CUSTOMER_ADMIN. This role gives you unrestricted access to all views available in the reader account, and lets you manage additional roles and users within the account.
If you require users with specific sets of permissions, you can create additional roles that can be granted to new users as needed. For example, if you want a user to have access to the VZC database and the views within it, they can be assigned a role that has those permissions explicitly granted.
For more information, see the How Do I Create a New Role With Certain Permissions? article, or consult the Role Management section in the official Snowflake documentation.
A reader account is intended primarily for querying data shared by Verizon Connect. Adding new data to the account and updating shared data in the account are not supported. Additionally, you cannot create any objects in the shared database. You can create an additional database with a set of views that work for you, sourcing the data from the shared database. This would allow you to set up permissions according to your needs. As such, the following DML and DDL commands are not allowed:
-
INSERT
-
UPDATE
-
DELETE
-
MERGE
-
COPY INTO <table>
-
CREATE PIPE
-
CREATE SHARE
As the provider of the account, Verizon Connect fields questions and requests from users in the account and responds as appropriate. Reach out to your support team if you experience issues with your reader account or have any questions.
There are many ways to work with Snowflake. The default way of interaction is via the Snowflake UI using the link provided by Verizon Connect. You can familiarize yourself with it right after you complete the initial setup of your account. Additionally, there are several options when working with Snowflake database:
-
Overview of the Ecosystem: Overview of the third party tools and technologies, as well as the Snowflake-provided clients, in the Snowflake ecosystem:
-
Snowflake Partner Connect: A list of Snowflake partners who offer free trials for connecting to and using Snowflake; includes instructions for starting a trial through the Snowflake web interface. Individual partners provide more detailed instructions and trial terms.
-
General Configuration (All Clients): General configuration instructions that apply to all Snowflake-provided clients (CLI, connectors, and drivers):
-
SnowSQL (CLI Client): Detailed instructions for installing, configuring, and using the Snowflake command-line client:
-
Connectors & Drivers: Detailed instructions for installing, configuring, and using the Snowflake-provided drivers and connectors for Python, Spark, JDBC, ODBC, and other clients:
Snowflake provides several options when it comes to exporting (or unloading) data from its database. We recommend that you read the information in the following Snowflake user guide pages to learn about best practices and the key concepts of exporting data from Snowflake:
The Snowflake user guide also contains some additional information on the supported data file formats, recommendations, and an option of creating your own named file format.
The following links contain detailed instructions for exporting data to one of the following destinations:
Comments
0 comments
Article is closed for comments.