Snowflake Outbound Sharing¶
Warning
Data sharing is an advanced feature in Public Preview. Please contact Support for more information.
Snowflake Outbound Sharing allows Observe datasets to be queried from Snowflake using SQL. This allows you to join Observe data with other tables in Snowflake and extract data in larger volumes than supported by the Observe API.
Prerequisites¶
To use Snowflake data sharing with Observe, you must have a Snowflake account in the same cloud or region as your Observe account. The cloud always uses AWS. For most customers, the region is us-west-2 (Oregon).
The examples in this document use Terraform to manage the Observe objects needed to configure outbound sharing. While the feature does not technically require Terraform, Observe currently does not provide a user interface for configuring Outbound Sharing. Instead, use Terraform to interact with Outbound Sharing.
Querying a Dataset¶
After configuring the share and adding a dataset, you can query the dataset from Snowflake. Using the example values provided in earlier steps:
// Grant privileges to SYSADMIN
USE ROLE ACCOUNTADMIN;
GRANT IMPORTED PRIVILEGES ON DATABASE EXAMPLE_SHARED_DB TO ROLE SYSADMIN;
// Switch to role
USE ROLE SYSADMIN;
USE DATABASE EXAMPLE_SHARED_DB;
SELECT * FROM "example_schema"."example_view";
Keep in mind that Snowflake shares are strictly read-only, so you can SELECT
data from a shared dataset and not insert or update it. To change the table’s definition, amend the OPAL query for the dataset in Observe to define the columns as desired.