What is CARTO’s Analytics Toolbox?
CARTO’s Analytics Toolbox is a set of UDFs and Store Procedures to unlock Spatial Analytics directly on top of your cloud data warehouse platform. It is organized in a set of modules based on the functionality they offer.
How can I use the functions available in the Analytics Toolbox?
You can use the functions in the Analytics Toolbox via CARTO Builder, SQL Notebooks, and directly in the console of your cloud data warehouse platform.
To learn how to get access to the toolbox please visit the Documentation page for the:
- Analytics Toolbox for BigQuery (also valid for the CARTO Data Warehouse)
- Analytics Toolbox for Snowflake
- Analytics Toolbox for Redshift
- Analytics Toolbox for Databricks
In CARTO Builder, you can use the Analytics Toolbox functions in your custom SQL queries when adding a source to your map.
Can I use the Analytics Toolbox from the CARTO Data Warehouse connection?
Yes, you can. CARTO Data Warehouse connection works under the hood as a connection to Google BigQuery in the same region in which you have provisioned your CARTO organization account. Follow the same guides and reference for the Analytics Toolbox for BigQuery to use this functionality from your CARTO Data Warehouse connection.
In the Analytics Toolbox for BigQuery, are there differences when using it from different GCP regions?
Yes, there are. The projects in which we install the Analytics Toolbox functions vary depending on the cloud region. In this section of the documentation you can find the BigQuery Project name for the Analytics Toolbox depending on the cloud region to which you have created a connection between CARTO and BigQuery.
For BigQuery connections in US and EU regions, we recommend to use the Analytics Toolbox we have enabled in US multi-region (project name: carto-un) and EU multi-region (project name: carto-un-eu)
Note that this also applies if you want to leverage the Analytics Toolbox from your CARTO Data Warehouse connection.