Running queries from Builder
Once you have created your BigQuery connection in the CARTO Workspace (see Getting Access for details), you can create custom SQL layers in Builder that make use of the Analytics Toolbox for BigQuery.
The Analytics Toolbox functions are available from the
carto-un-eu BigQuery projects. These projects are deployed in the US and EU multi-regions, respectively, and you may choose one or the other depending on the location of your data.
To get started, let’s run a simple example query to cluster a set of points using the
ST_CLUSTERKMEANS function from the clustering module.
- Click on the Add source from button in Builder, that can be found at the bottom left of the screen.
- Select the second tab Custom Query (SQL) and pick the BigQuery or CARTO Data Warehouse connection that you will use to run the query.
- Click on Add source. A SQL console will be displayed.
- Copy and paste the following query:
Run the query. This query computes five clusters from the points of the
sample_customer_home_locationstable. As a result, each point is assigned a
Style the layer by the