Access data in Snowflake
Last updated
Was this helpful?
Last updated
Was this helpful?
In order to make the Data Observatory subscriptions accessible in your Snowflake account, first of all CARTO needs to create and register your subscriptions in your CARTO account. Once this first step has been done, Admin users of your CARTO organization will be able to see the list of active subscriptions in the Data Observatory section in Settings.
Once your subscriptions have been created, the CARTO team will proceed with the data transfers so to make the data accessible directly on your Snowflake account. Please contact your CARTO representative if you need to start this process on demand (e.g. public data subscriptions).
In order to make your subscriptions available in your Snowflake account, CARTO leverages the native private sharing mechanisms of Snowflake.
CARTO will create and maintain a listing privately shared with your Snowflake account containing the data from all your Data Observatory subscriptions. To be able to create such private share we will need to receive the following information regarding your Snowflake account:
Account ID
Organization ID
Cloud
Region
Once the listing has been shared, users in your Snowflake account with access to Data Products (e.g. Account Admins) will receive an email notification stating that a data product is ready on the Snowflake account.
The data will be ready in the private share a bit later from the time that share is created and you receive the e-mail notification. Once all the data has been transferred, the CARTO team will inform you so you can proceed with the following steps.
On your Snowflake account, navigate to the Data Products section and then select Private Sharing. In that section you will find the different shares that have been shared with you. There you will find the share detailed on the e-mail notification.
Access the private share and then click on "Get". You will be prompted to complete your profile to get data products (if you haven't done it already).
Then, you will be asked to provide a Database name and which roles in addition to ACCOUNTADMIN should be able to access that database. Then click on "Get".
After a few seconds the new database will be created and the data from your subscriptions will be ready to use!.
In order to use the data from your Data Observatory subscriptions that have been transferred directly to your Snowflake account you should not use the Data Observatory tabs in Data Explorer, Workflows or Builder, but directly your own Snowflake connections.
You need to ensure that the database that you have created from the share is accessible from your Snowflake connections.
To learn more about Snowflake connections in CARTO please access this section. For map performance considerations please read these recommendations.
Remember to grant privileges on the database to any Snowflake roles that will need to access and use the data.
