Spatial Extension for Snowflake

Spatial Extension for Snowflake

Getting started

The CARTO Spatial Extension for Snowflake is composed of a set of user-defined functions and procedures organized in a set of modules based on the functionality they offer. There are two types of modules: core modules, which are open source and advanced. Both types of modules are currently freely available while the Spatial Extension is in Beta, but the advanced ones will only be available for CARTO customers when the product becomes generally available.

CARTO Spatial Extension for Snowflake modules

Visit the SQL Reference to see the full list of available modules and functions. Check out the Examples section to find sample code that solves real-world spatial problems.

Keep reading to learn how to access CARTO’s Spatial Extension via Snowflake’s Data Marketplace.

Accessing the Spatial Extension

You can get access to the Spatial Extension for Snowflake through the Snowflake’s Data Marketplace. If you are unsure of how to access the Data Marketplace, you can find detailed instructions in this article of Snowflake’s documentation center.

Once in the Data Marketplace, search for carto spatial extension to find the listing:

Spatial Extension for Snowflake listing

Once you are in the details page of the listing, you may find you can GET the Spatial Extension directly, or REQUEST it, depending on whether or not it has been already deployed in your region.

Requesting access

  1. Click on the REQUEST button on the top right corner of the Data Marketplace listing.

Spatial Extension for Snowflake request

  1. Fill in and send the request form.

Spatial Extension for Snowflake request form

Once your request has been fulfilled by CARTO, you can get access to the Spatial Extension following the steps in the following section. You can always keep track of the status of your request in My Requests.

Snowflake Data Marketplace My Requests

Getting access

  1. Click on the GET DATA button on the top right corner of the Data Marketplace listing.

Spatial Extension for Snowflake get data

  1. Rename the database to SFCARTO, choose all the roles to which you wish to give access to this database, accept the Terms of Use and finally click on “Create Database”.

Spatial Extension for Snowflake get data form

By cicking on “View Database” you will be redirected to the database you just created, where you will be able to browse all the modules (schemas) and functions and procedures available within the Spatial Extension.

Spatial Extension for Snowflake get data form