Use the Snowflake Connector for Google Looker Studio

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

Note

The Snowflake Connector for Google Looker Studio is subject to the Connector Terms.

Note

This topic provides information about using Google Looker Studio. For information about querying Snowflake data from Google Looker, see Using the Looker Data Platform to Query Snowflake.

The Snowflake Connector for Google Looker Studio provides an interface to Google Looker Studio, data visualization software you can use 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 Looker Studio.

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

Connect your Snowflake account to Google Looker Studio

  1. Sign in to Google Looker Studio.

  2. Click +, and 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 Looker 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 semicolon.

  8. Click Connect.

    A page containing data source fields is displayed.

  9. To visualize your data, click Create Report or Explore.

Note

If you have trouble connecting to your Snowflake account, use the following procedure to revoke access, and then try to connect again.

Revoke access

  1. Sign in to Google Looker Studio.

  2. Select Data Sources.

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

  4. Click Revoke access.

Mapping Snowflake data types to Looker Studio data types

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

Snowflake data type

Google Looker 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 *

Note

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

For more information about Snowflake data types, see Data Types.

Network policy access

Connections from Google Looker 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 Looker Studio user to either allow all IP addresses (0.0.0.0/0) or use this shell script to get a list of possible Google Cloud IP addresses with subnets.

Identifying Connector queries in your query history

The Snowflake Connector for Google Looker Studio uses user-provided SQL statements as an inner SELECT statement for each generated query to a database. Therefore, your query history may contain optimized queries 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 Looker Studio. OAuth and key-pair authorization are not supported.

  • The current sign-in flow only supports a single sign-in (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 sign-ins to the same or different Snowflake accounts.

  • Google limits the returned data set to 1 million rows and 50 MB of data. Unexpected errors may occur when you try 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 Looker Studio support different regexp types.

  • Pushdown filters are not supported for the SHOW and DESCRIBE statements and for DATE, TIME, and TIMESTAMP columns.

Language: English