Skip to main content
Snowflake Secure Data Sharing lets Thanx share your data directly into your Snowflake account using Snowflake’s native sharing capability. Data is shared account-to-account within Snowflake — no copying, no external pipeline, and no third-party data-loading service.
This option is distinct from Thanx Connex. Connex loads data into a variety of destinations through a managed data-loading service, whereas Snowflake Secure Data Sharing is a direct Snowflake-to-Snowflake share. Because no external service is involved, Thanx does not charge for Snowflake Secure Data Sharing.

​
How it works

Thanx maintains your data in a Snowflake account and grants your Snowflake account access to a secure share. You create a database from that share in your own account and query it like any other database. Because the data is never duplicated, you always read the latest data Thanx has published, and you only pay Snowflake for the compute you use to query it.

​
Requirements

  • Snowflake account — You must have your own Snowflake account that can consume a share (i.e., a standard Snowflake account, not a reader account provisioned by another provider).
  • AWS us-east-1 account — Snowflake direct shares can only be made between accounts in the same Snowflake region and cloud platform. The Thanx provider account is on AWS US East (N. Virginia), us-east-1, so your Snowflake account must also be on AWS us-east-1. Accounts in other regions or on other cloud platforms (Azure, GCP) cannot consume the share — cross-region and cross-cloud sharing would require Snowflake replication or listings, which are outside the scope of this offering.
  • Account identifier — You will need to provide your Snowflake account identifier (organization and account name) so Thanx can add your account as a consumer of the share.
  • ACCOUNTADMIN (or a role with IMPORT SHARE / CREATE DATABASE privileges) — Creating a database from an inbound share requires sufficient privileges in your account.
Only AWS us-east-1 is supportedBecause direct shares cannot cross regions or cloud platforms, Thanx can only share data with Snowflake accounts hosted on AWS us-east-1. If your Snowflake account is in another region or on Azure or GCP, this option is not available — consider Thanx Connex or SFTP exports instead.
Confirming your regionTo confirm the region and cloud platform of your Snowflake account, run:
SELECT CURRENT_REGION();
The result must be AWS_US_EAST_1 to be eligible for Snowflake Secure Data Sharing with Thanx. Share this value with your Thanx success manager before setup begins.

​
Setup

This is a manual, one-time configuration coordinated with your Thanx success manager.
1

Notify Thanx success

Let your success manager know you’d like to receive Thanx data via Snowflake Secure Data Sharing.
2

Confirm region compatibility

Provide the output of SELECT CURRENT_REGION(); and your Snowflake account identifier. The region must be AWS_US_EAST_1 — Thanx can only share with accounts on AWS us-east-1.
3

Thanx grants the share

Thanx adds your account as a consumer of the secure share containing your Thanx data.
4

Create a database from the share

In your Snowflake account, create a database from the inbound share. You can find the inbound share under Data » Private Sharing, or create the database directly:
-- list inbound shares to confirm the share is available
SHOW SHARES;

-- create a database from the inbound share
CREATE DATABASE THANX_DATA FROM SHARE <thanx_provider_account>.<share_name>;

-- grant access to the roles that will query the data
GRANT IMPORTED PRIVILEGES ON DATABASE THANX_DATA TO ROLE <your_role>;
5

Query your data

Query the shared database like any other Snowflake database. Updates Thanx publishes to the share are reflected automatically — there is no sync delay from a copy step.