Snowflake Connector for Google Data Studio

This topic describes how to use the Snowflake Connector for Google Data Studio.

In this Topic:

The Snowflake Connector for Google Data Studio provides an interface to Google Data Studio, data visualization software used to transform your raw data into the metrics and dimensions needed to create reports and dashboards.

This connector is available to anyone with a Google account as a Partner Connector within Google Data Studio.

For more information about Google Data Studio, see the Google Data Studio documentation.

Connecting Your Snowflake Account to Google Data Studio

  1. Sign in to Google Data Studio.

  2. Click +, then select Data Source.

  3. Under the Partner Connectors section, select the Snowflake connector (the connector with the Snowflake logo).

  4. If required, authorize Google Data Studio to use this community connector.

  5. Enter the following Snowflake user credentials to connect to Snowflake:

    • Username

    • Password

  6. Click Submit.

  7. Provide the following parameters required to connect to your Snowflake account:

    • Account URL

    • Role

    • Warehouse

    • Database

    • Schema

    • SQL query

    Note

    The SQL query cannot end with a semi-colon.

  8. Click Connect.

    A page containing data source fields displays.

  9. Click Create Report or Explore to visualize your data.

If you encounter problems while connecting to your Snowflake account, perform the following to revoking access:

  1. Sign in to Google Data Studio.

  2. Select Data Sources.

  3. Browse or search for the Snowflake connector, then click More options.

  4. Click Revoke access.

After revoking access you can follow the steps in this section again to connect to your Snowflake account.

Mapping Snowflake Data Types to Data Studio Data Types

The connector maps your Snowflake database data types to a unified set of data types as follows:

Snowflake Data Type

Google Data Studio Data Type

BOOLEAN

BOOLEAN

FIXED

NUMBER

REAL

NUMBER

BINARY

TEXT

TEXT

TEXT

GEOGRAPHY

TEXT *

DATE

YEAR_MONTH_DAY

TIMESTAMP_LTZ

YEAR_MONTH_DAY_SECOND

TIMESTAMP_NTZ

YEAR_MONTH_DAY_SECOND

TIMESTAMP_TZ

YEAR_MONTH_DAY_SECOND

TIME

TEXT

OBJECT

TEXT *

VARIANT

TEXT *

ARRAY

TEXT *

*

Google Data Studio does not support complex spatial types, so they are represented as text. The text format allows you to freely process data in custom visualizations.

Note

If Google Data Studio encounters a column in a table or query of an unsupported type, it does not create a field for that column.

See Data Types for more information about Snowflake data types.

Network Policy Access

Connections from Google Data Studio to Snowflake come from ephemeral Google servers with no fixed IP addresses. If your network uses network policies, you may need to open up the policy for the Data Studio user to either allow ALL IP addresses (0.0.0.0/0) or use this shell script to get a list of possible GCP IP addresses with subnets.

Identifying Connector Queries in Your Query History

The Snowflake Connector for Google Data Studio uses user-provided SQL statements as an inner SELECT statement for each generated query to a database. Due to this, you may see some more optimized queries in your query history that differ from the queries you entered when configuring a data source.

In your query history, the queries from the connector will include this inner SELECT statement.

Supported SQL Queries

Only the SELECT, SHOW, and DESCRIBE SQL statements are supported. The connector only supports specifying a single SQL statement as the query. It does not support selecting tables and views from a list.

Limitations

  • The connector only supports authentication using a username and password due to a limitation in Google Data Studio. OAuth and key-pair authorization are not supported.

  • The current login flow only supports a single login (username and password), which only works for different accounts if all accounts use the same username and password. The connector does not support using multiple logins to different or the same Snowflake account.

  • Google limits the returned data set to 1 million rows and 50 MB of data. You may see unexpected errors when trying to return more data.

  • Column headers (field names) must use ASCII characters only. Non-ASCII characters are not supported.

  • Reports containing REGEXP_PARTIAL_MATCH and REGEXP_EXACT_MATCH operators are not optimized by pushdown filters. because Snowflake and Google Data Studio supports different regexp types.

  • Pushdown filters are not supported for the SHOW and DESCRIBE statements.

Back to top