What privilege does a user need in order to receive or request data from the Snowflake Marketplace?
What privilege does a user need in order to receive or request data from the Snowflake Marketplace?
To access and use data from the Snowflake Marketplace, a user needs the IMPORT SHARE privilege. This privilege allows the user to view and import shares, which are necessary for receiving or requesting data from the marketplace. Additionally, users with this privilege can create databases from these shares. The IMPORT SHARE privilege is essential for importing data that has been shared through the marketplace, enabling users to access and utilize the shared data effectively.
IMPORTED PRIVILEGES is the right answer. https://docs.snowflake.com/en/user-guide/security-access-control-privileges#:~:text=Usage-,IMPORTED%20PRIVILEGES,-Enables%20roles%20other
IMPORTED PRIVILEGES Imported Privileges - Enables roles other than the owning role to manage a Snowflake Marketplace or Data Exchange. Verified
IMPORT SHARE - Applies to data consumers. Grants the ability to view shares shared with your account. Also grants the ability to create databases from the shares. IMPORTED PRIVILEGES - manage a Snowflake Marketplace or Data Exchange
C - IMPORT SHARE You must use the ACCOUNTADMIN role (or a role granted the IMPORT SHARE global privilege) to perform these tasks. For more details about the IMPORT SHARE privilege, see Enabling non-ACCOUNTADMIN roles to perform data sharing tasks.
D :IMPORTED PRIVILEGES
Answer C as per this documentation https://other-docs.snowflake.com/en/collaboration/consumer-becoming#:~:text=To%20access%20a%20listing%2C%20you%20must%20use%20the%20ACCOUNTADMIN%20role%20or%20another%20role%20with%20the%20CREATE%20DATABASE%20and%20IMPORT%20SHARE%20privileges
https://docs.snowflake.com/en/user-guide/security-access-control-privileges#data-exchange-privileges it is asking not about shares, but listings
The IMPORT SHARE privilege allows a user to import a data share into their account, including data shared through the Snowflake Marketplace. This privilege enables users to access and use data shared by other Snowflake users or providers through the Marketplace.
C There are several ways of sharing data on Snowflake, such as: - Direct share - Listings (Snowflake Marketplace) - Data exchange The question is asking about Snowflake Marketplace, where you can have listings The question is NOT asking about data shares or data exchanges. https://other-docs.snowflake.com/en/collaboration/consumer-becoming#set-up-required-privileges Get a listing for your account, then grant the IMPORTED PRIVILEGES privilege on the database created from the listing to a role on your account. This lets you access the data in the listing without having access to get any listing on the Snowflake Marketplace or privately. The answer should be C. IMPORT SHARE privileges to a role on your account allows you get access to listings and therefore, receive and request data from Snowflake Marketplace. Once you do get listing for your account, then you would need IMPORTED PRIVILEGES to access it.
To support delegating these tasks to other users, the IMPORTED PRIVILEGES privilege can be granted on a Data Exchange to other roles. IMPORT SHARE & CREATE DATABASE
the question is not asking about data exchange. It is asking about Snowflake Marketplace and listing. Please see the difference here: https://docs.snowflake.com/en/user-guide/data-sharing-intro
C. When logging in to the Data Exchange as a consumer: All roles can browse data listings. All roles with the ACCOUNTADMIN role can request and get data. All roles with the IMPORT SHARE and CREATE DATABASE privileges can get and request data. https://docs.snowflake.com/en/user-guide/data-exchange-accessing
D. it's about the listing
change to C. if you use other role instead accountadmin, the role must granted IMPORTED PRIVILEGES
A https://docs.snowflake.com/en/user-guide/data-exchange-marketplace-privileges#label-create-data-exchange-listing-on-account If the global CREATE DATA EXCHANGE LISTING privilege is granted to a role, any user with the role can create a listing or provider profile. As the creator and, therefore owner of the listing, the role can be used to perform all tasks on the listing, including: Create listings Modify listings properties View listings View incoming listing access requests Reject listing requests Submit listings for approval/publishing listings Create and view provider profiles
https://docs.snowflake.com/en/user-guide/data-share-consumers
To access a listing, you must use the ACCOUNTADMIN role or another role with the CREATE DATABASE and IMPORT SHARE privileges. https://other-docs.snowflake.com/en/collaboration/consumer-becoming.html#set-up-required-privileges