Analytics Toolbox for BigQuery
Examples
In this section we provide a set of examples that showcase how to leverage the functions of our Analytics Toolbox to unlock advanced spatial analyses in your data warehouse platform. They cover a broad range of use cases with methods for data transformations, enrichment, spatial indexing in Quadkey and H3, statistics, clustering, spatial data science methods and more.
The Analytics Toolbox can be leveraged from the SQL Query editor in Builder, your data warehouse console, or in SQL and Python Notebooks using the SQL clients provided by the different cloud platforms.
In this example we are going to use some of the functions included in CARTO's Analytics Toolbox in order to highlight zones prone to earthquakes, using a BigQuery public dataset.
In this example we are going to showcase the extent of quadkey tiles at different resolutions. For this purpose we are using the United Kingdom census areas dataset from CARTO's Data Observatory.