Data Exchange provides a data hub for securely collaborating around data with a selected group of members that you invite. It lets you, as a provider, publish data which can then be discovered by the consumers participating in your…

About Data Exchange

To create a Data Exchange, contact your Snowflake representative or Snowflake Support. Invite members and assign roles After the Data Exchange is set up, you can start inviting accounts as members and designating them as data providers,…

Configure and use a Data Exchange

To access your Data Exchange, sign in to Snowsight. After your Data Exchange is provisioned by Snowflake, you can administer your exchange using Snowsight. See Configure and use a Data Exchange. To add or remove provider profiles, use the…

Access a Data Exchange

To inquire about enabling a data exchange, please contact Snowflake Support. To request a new Data Exchange for your Snowflake account, contact Snowflake Support and provide the following information: Description: Description of the…

Request a new Data Exchange

Rename the CREATE DATA EXCHANGE LISTING privilege to CREATE LISTING Attention This behavior change is in the 2025_03 bundle. For the current status of the bundle, refer to Bundle History. When this behavior change bundle is enabled, the…

Rename the CREATE DATA EXCHANGE LISTING privilege to CREATE LISTING

ISSUE: The show shares; command is commonly used to list all the shares associated with the Snowflake account. In the returned results, the records without values in the listing_global_name column populated are secure direct data shares…

How to determine which shares are direct shares or linked to a specific private data exchange

The Data Exchange has the following requirements: A full Snowflake account to provide or consume data sets; reader accounts are not supported. By default, the ACCOUNTADMIN role can perform provider functions, such as creating a listing,…

Manage provider profiles

FAQ: - You tried running the below SQL command to grant imported privileges to any role (system-defined or custom) on Snowflake Marketplace so that the role can perform certain administrative tasks in Snowflake Marketplace.

SQL compilation error: Data exchange 'SNOWFLAKE_DATA_MARKETPLACE' does not exist or not authorized when trying to grant imported privileges on Snowflake Marketplace to any role

ISSUE: A user trying to request data through the Snowflake Data Exchange is facing the following error: Insufficient privilege to accept DATA_EXCHANGE_LISTING terms. CAUSE: The role in use doesn't have the minimum privileges to request…

Solution to: "Insufficient privilege to accept DATA_EXCHANGE_LISTING terms."

CAUSE: The Database in the share is a secondary database. Secondary databases are read-only and cannot be replicated using Listing Auto-Fulfillment. This can happen if the database has been replicated to the cloud region where the…

The Data Marketplace / Data exchange listing is returning the messaging "The secondary database in the share is not supported for auto-fulfillment." under Region Availability

ISSUE: When adding a Data Product to a Private or Public listing within the Data Marketplace or Data exchange the following messaging appears  "The share includes a reference database. Auto-fulfillment will be unavailable for this listing".…

When creating a Data Marketplace/ Data exchange listing the following messaging is returned:  "The share includes a reference database. Auto-fulfillment will be unavailable for this listing."

ISSUE: When trying to request make a request for a Personalized listing on the Snowflake Marketplace the following error is returned:"Insufficient privilege to accept DATA_EXCHANGE_LISTING terms."  
CAUSE: This error occurs if the role used…

Error "Insufficient privilege to accept DATA_EXCHANGE_LISTING terms".

ISSUE: When a provider approves a personalized data exchange listing after selecting the data objects to share the following error is displayed -

Failed to create secure share. Please try again.

003056 (0A000): SQL compilation error:

A v…

SQL complication error when approving a personalized data exchange listing with object references

Manage data listings
Considerations for creating a listing
Note
These considerations also apply for creating a listing in a remote region.


Since the data is shared between different accounts, data consumers should be able to use shared da…

Manage data listings

Grant privileges to other roles
Snowflake provides a set of privileges for working with listings in the Snowflake Marketplace or a Data Exchange.



Granting administrator privileges in a Data Exchange
By default, only an account administra…

Grant privileges to other roles

Data sharing and collaboration in Snowflake
There are many ways to share data from your Snowflake account with users in other Snowflake accounts, including collaborating with other
parties in a secure environment.

Why share data with Snowf…

Data sharing and collaboration in Snowflake

ISSUE: When trying to create a database from an INBOUND share, the following error is returned:


Share 'SHARE_NAME' cannot be imported because the terms for the associated listing 'GZT0ZXXXXXXXX' in data exchange 'SNOWFLAKE_DATA_MARKETPLAC…

Unable to create a database from an INBOUND share with error "Share 'SHARE_NAME' cannot be imported because the terms for the associated listing 'GZT0ZXXXXXXXX' in data exchange 'SNOWFLAKE_DATA_MARKETPLACE' have not been accepted."

About Secure Data Sharing
Secure Data Sharing lets you share selected objects in a database in your account with other Snowflake accounts. You can share the
following Snowflake objects:

Databases
Tables
Dynamic tables
External tables
Apach…

About Secure Data Sharing

Schema:DATA_SHARING_USAGE



LISTING_TELEMETRY_DAILY view
The LISTING_TELEMETRY_DAILY view in the DATA_SHARING_USAGE schema displays daily telemetry data by data exchange and region.
The view returns a row for each data exchange in your org…

LISTING_TELEMETRY_DAILY view

Schema:Data Sharing Usage



LISTING_ACCESS_HISTORY view
Preview Feature — Open
This feature is currently in preview and is available to all users.

This view in the DATA_SHARING_USAGE schema can be used to explore the history of consumers’…

LISTING_ACCESS_HISTORY view

ISSUE: The role that created the listing (listing owner role) is different from the role that created the share (share owner role) and when trying to publish the listing using the listing owner role, the below error is shown:Failed to publi…

Error when trying to publish the listing: "Failed to publish listing. The selected role does not own the Secure Share associated with this listing. Please use the role that owns the Secure Share <share_name> to publish this listing."

Schema:DATA_SHARING_USAGE



LISTING_CONSUMPTION_DAILY view
This view in the DATA_SHARING_USAGE schema can be used to analyze consumption of a Snowflake Native App or shared data associated with listings
in a data exchange, such as the Snow…

LISTING_CONSUMPTION_DAILY view

ISSUE: - ACCOUNTADMIN role is able to add data product to the listing created by them.- Custom role is able to create the listing but is not able to add the data product to the listing created by them. The below error message is shown when …

Error when trying to add data product to the listing using a custom role: "Failed to create secure share. Please try again. SQL access control error: Insufficient privileges to operate on account <account locator>".

Using the Spark Connector
The connector adheres to the standard Spark API, but with the addition of Snowflake-specific options, which are described in this topic.
In this topic, the term COPY refers to both:

COPY INTO <table> (used to tran…

Using the Spark Connector

ISSUE: When a data provider tries to add or remove consumers on a share linked to a listing using the ALTER SHARE command, they would encounter the error message: Cannot add or remove individual consumers for a share that is associated with…

Cannot add or remove consumers on a share associated with a listing

Pay for listings
Before making a purchase on Snowflake Marketplace, use the topics on this page to learn how to make and manage your purchases on Snowflake Marketplace.
If you want to request trial access before making a purchase,
see Explo…

Pay for listings

Modify published listings
This topic describes how to modify listings after they have been published to the Snowflake Marketplace or shared with consumers as a private listing.



Privileges required to edit listings
To modify listings, you…

Modify published listings

Access control privileges
This topic describes the privileges that are available in the Snowflake access control model. privileges are granted to roles, and roles are
granted to users, to specify the operations that the users can perform on…

Access control privileges

Consume imported data
This topic describes the tasks associated with creating databases from shares made available by data providers and then using the databases
for queries and other operations.
You must use the ACCOUNTADMIN role (or a rol…

Consume imported data

Schema:DATA_SHARING_USAGE



LISTING_EVENTS_DAILY view
The LISTING_EVENTS_DAILY view in the DATA_SHARING_USAGE schema lets you query the daily history of
consumer activity on listings for the Snowflake Marketplace and data exchanges, includ…

LISTING_EVENTS_DAILY view

Installing and Configuring the Spark Connector
Multiple versions of the connector are supported; however, Snowflake strongly recommends using the most recent version of the connector. To view release information
about the latest version, se…

Installing and Configuring the Spark Connector

Data Sharing Usage
In the SNOWFLAKE database, the DATA_SHARING_USAGE schema includes views that display information about listings published in the
Snowflake Marketplace or a data exchange. This includes telemetry data (number of clicks), a…

Data Sharing Usage

Schema:DATA_SHARING_USAGE



APPLICATION_STATE view
Feature — Generally Available
The Snowflake Native App Framework is generally available on supported cloud platforms. For additional information, see
Support for private connectivity, VPS,…

APPLICATION_STATE view

2025_03 Bundle
Bundle History
Attention
To determine the current status of bundles in your account,
see SYSTEM$SHOW_ACTIVE_BEHAVIOR_CHANGE_BUNDLES.
For more information, see
Behavior change management.


Introduced in the 9.12 release (May …

2025_03 Bundle

ISSUE: This article describes the process a data consumer can follow to cancel an existing data request that was previously submitted to a data provider.  
CAUSE: For various reasons, a data consumer might be asked by a data provider to sub…

How to cancel an existing data request submitted to a data provider in Snowflake Data Marketplace

Explore and manage database objects in Snowsight
You can explore and manage your database objects in Snowsight using the database object explorer. The database object
explorer contains a hierarchical view of all databases in your account, t…

Explore and manage database objects in Snowsight

Categories:Information Schema , Table functions



LISTING_REFRESH_HISTORY
Returns the past 14 days of refresh history for a cross-cloud auto-fulfillment listing.
The information returned contains replication details for refresh events wher…

LISTING_REFRESH_HISTORY

Snowpark Container Services: Working with services
Feature — Generally Available
Snowpark Container Services is available to accounts in AWS, Microsoft Azure, and Google Cloud Platform commercial regions, with some exceptions. For more info…

Snowpark Container Services: Working with services

About listing consumers
To access listings shared privately or on the Snowflake Marketplace, become a Snowflake consumer. You can also access data shared
as part of direct shares or data exchanges, which offer more limited data sharing capa…

About listing consumers

Listing manifest reference
Creating Snowflake listings programmatically requires a manifest, written in YAML
(https://yaml.org/spec/). Use the information provided here to learn about the manifest format and its individual
sections.

See al…

Listing manifest reference

Configure Snowflake OAuth for custom clients
This topic describes how to configure OAuth support for custom clients.



Workflow
The following high-level steps are required to configure OAuth for custom clients:

Register your client with S…

Configure Snowflake OAuth for custom clients

FAQ: The argument passphrase in functions ENCRYPT/DECRYPT is not used directly to encrypt/decrypt the input. Instead, this argument is used to derive an encryption/decryption key, which is always the same for the same passphrase.Snowflake u…

How to exchange encrypted data between Snowflake and other databases

DESCRIBE USER
Describes a user, including the current and default values of the properties of the
user.
DESCRIBE can be abbreviated to DESC.

See also:DROP USER , ALTER USER , CREATE USER , SHOW USERS



Syntax
{ DESC | DESCRIBE } USER <nam…

DESCRIBE USER

Manage organizational listings
You can alter a listing to add, change, or remove the settings of the organizational listing,
such as the title, ULL, target accounts or roles, auto-fulfillment, and more.

View available organizational listin…

Manage organizational listings

Schema:ACCOUNT_USAGE



OBJECT_ACCESS_REQUEST_HISTORY view
This Account Usage view allows consumers to access audit logs that track the submission, rejection, and approval of object access requests through the Internal Marketplace to mainta…

OBJECT_ACCESS_REQUEST_HISTORY view

Create an organizational listing
Create an organizational listing to share data products securely within your organization. Before you create an organizational listing, review the prerequisites, known limitations, and considerations.

Prere…

Create an organizational listing

GRANT <privileges> … TO ROLE
Grants one or more access privileges on a securable object to a role or database role. The privileges that can be granted are object-specific.
For information on granting privileges on securable objects to a sha…

GRANT <privileges> … TO ROLE

SNOWFLAKE database
Snowflake provides a system-defined, read-only shared database named SNOWFLAKE that contains metadata and historical usage data
about the objects in your organization and accounts.
The SNOWFLAKE database is an example of …

SNOWFLAKE database

Organization accounts
Enterprise Edition Feature
This feature requires Enterprise Edition (or higher). To inquire about upgrading, please contact Snowflake Support.


Feature — Generally Available
Not available in government regions.

The o…

Organization accounts

Manage your provider profile
This topic provides information on managing your provider profile.



Provider profile fields
When you create or modify your provider profile, you can change a number of fields. The following table describes the…

Manage your provider profile

Schema:ACCOUNT_USAGE



APPLICATION_DAILY_USAGE_HISTORY view
Use this view to return the daily credit and storage usage for Snowflake Native Apps in an account within the last 365 days
(1 year).

Columns
The following table provides definit…

APPLICATION_DAILY_USAGE_HISTORY view

Access and install listings as a consumer
Whether you explored listings on the Snowflake Marketplace and found a listing that you want to access or purchase, or a provider shared a
private listing with you, this topic guides you through acc…

Access and install listings as a consumer

CREATE SECURITY INTEGRATION (Snowflake OAuth)
Creates a new Snowflake OAuth security integration in the account or replaces an existing integration. A Snowflake OAuth security
integration enables clients that support OAuth to redirect users…

CREATE SECURITY INTEGRATION (Snowflake OAuth)

Categories:Window function syntax and usage (Ranking)



NTILE
Divides an ordered data set equally into the number of buckets specified by constant_value. Buckets are sequentially numbered 1 through constant_value.

Syntax
NTILE( <constant_…

NTILE

REVOKE <privileges> … FROM ROLE
Removes one or more privileges on a securable object from a role or database role. The privileges that can be revoked are object-specific.

Roles:
The privileges that can be revoked from roles are grouped int…

REVOKE <privileges> … FROM ROLE

FetchSFTP 2025.10.2.19
Feature — Generally Available
Openflow is available to all accounts in AWS Commercial Regions.



Bundle
org.apache.nifi | nifi-standard-nar


Description
Fetches the content of a file from a remote SFTP server and ov…

FetchSFTP 2025.10.2.19

ALTER SECURITY INTEGRATION (Snowflake OAuth)
Modifies the properties of an existing security integration created for a Snowflake OAuth client. For information about modifying other
types of security integrations (e.g. External OAuth), see A…

ALTER SECURITY INTEGRATION (Snowflake OAuth)

GRANT <privileges> … TO USER
Grants one or more access privileges on a securable object to a user. The privileges that can be granted are object-specific.
For more information about roles and securable objects, see Overview of Access Contro…

GRANT <privileges> … TO USER

PutSFTP 2025.10.2.19
Feature — Generally Available
Openflow is available to all accounts in AWS Commercial Regions.



Bundle
org.apache.nifi | nifi-standard-nar


Description
Sends FlowFiles to an SFTP Server


Tags
archive, copy, egress, …

PutSFTP 2025.10.2.19

ListSFTP 2025.10.2.19
Feature — Generally Available
Openflow is available to all accounts in AWS Commercial Regions.



Bundle
org.apache.nifi | nifi-standard-nar


Description
Performs a listing of the files residing on an SFTP server. For…

ListSFTP 2025.10.2.19

GetSFTP 2025.10.2.19
Feature — Generally Available
Openflow is available to all accounts in AWS Commercial Regions.



Bundle
org.apache.nifi | nifi-standard-nar


Description
Fetches files from an SFTP Server and creates FlowFiles from the…

GetSFTP 2025.10.2.19

DeleteSFTP 2025.10.2.19
Feature — Generally Available
Openflow is available to all accounts in AWS Commercial Regions.



Bundle
org.apache.nifi | nifi-standard-nar


Description
Deletes a file residing on an SFTP server.


Tags
delete, rem…

DeleteSFTP 2025.10.2.19

ISSUE: PowerBI desktop using ODBC driver would fail with SSL  certificate problem,Error returned: 'OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Snowflake][Snowflake] (25) Result download worker error: Worker error: [Snowflake][Sn…

CURLerror 'SSL peer certificate or SSH remote key was not OK'  using ODBC driver connection to Snowflake from PowerBI desktop

REVOKE <privileges> … FROM USER
Removes one or more privileges on a securable object from a user. The privileges that can be revoked are object-specific.
See also:

GRANT <privileges> … TO USER


Syntax
REVOKE [ GRANT OPTION FOR ]
    {
   …

REVOKE <privileges> … FROM USER

ISSUE: Sometimes, even after following the below KB correctly, a user cannot successfully request the Access Token from Azure AD while configuring it as an external OAuth server for Snowflake access.How To: Create External OAuth Token Using…

OAuth 2.0 Authorization Code Grant (with PKCE) to Snowflake with Entra

Snowpipe Streaming API REST endpoints
Note
We recommend that you begin with the Snowpipe Streaming SDK over the REST API to benefit from the improved performance and getting-started experience.

The Snowpipe Streaming REST API is designed f…

Snowpipe Streaming API REST endpoints

Manage listings with SQL as a consumer - examples
The following are examples of the common tasks that consumers can complete programmatically with SQL commands:

Show available listings
DESCRIBE AVAILABLE LISTING
Request a listing and autom…

Manage listings with SQL as a consumer - examples

ISSUE: This issue can be seen if a newly created database is created from a trial listing and then dropped. If the database is dropped the INBOUND share is no longer visible by running 'show shares'.

How can the share be recreated? 
CAUSE:…

After dropping the database associated with a Snowflake Marketplace trial listing the share is no longer available

FAQ: If there are connectivity issues, support will ask whether the URLs (as mentioned in https://docs.snowflake.net/manuals/sql-reference/functions/system_allowlist.html) can be connected correctly, by checking every URL with curl -v -k cU…

Normal responses on curl -v -k requests

Install an app from a listing
Feature — Generally Available
The Snowflake Native App Framework is generally available on supported cloud platforms. For additional information, see
Support for private connectivity, VPS, and government region…

Install an app from a listing

SQL data types reference
Snowflake supports most basic SQL data types (with some restrictions) for use in columns, local variables, expressions, parameters,
and any other appropriate locations.

Note
You can also load unstructured data into…

SQL data types reference

Querying Semi-structured Data
This topic explains how to use special operators and functions to query complex hierarchical data stored in a VARIANT.
(For simple examples of how to extract values from ARRAYs and OBJECTs, see Accessing elemen…

Search results for "Data Exchange"