# Running queries from Builder

Once you have created your Redshift connection in the CARTO Workspace (see [*Getting Access*](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-redshift/overview/getting-access) for details), you can create custom SQL layers in Builder that make use of the Analytics Toolbox for Redshift.

To get started, let’s run a simple example query to compute the paths that interconnect a set of points using the [`ST_GREATCIRCLE`](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-redshift/sql-reference/transformations#st_greatcircle) function from the *transformations* module.

1. Click on the *Add source from* button in Builder, that can be found at the bottom left of the screen.

   <figure><img src="/files/ixXe0PRAe51EdMgSq98E" alt=""><figcaption></figcaption></figure>
2. Select the second tab *Custom Query (SQL)* and pick the Redshift connection that you will use to run the query. Please make sure this connection has access to the Analytics Toolbox database.

   <figure><img src="/files/5e6RufnuV0120iFVcgX6" alt=""><figcaption></figcaption></figure>
3. Click on *Add source*. A SQL console will be displayed.

   <figure><img src="/files/0AuKAo7DbOasoZdGMJJI" alt=""><figcaption></figcaption></figure>
4. Copy and paste the following query:

   ```sql
   WITH data AS(
      select  'JKF' as iata, 'John_F_Kennedy_International_Airport' as name, ST_POINT(-73.77890, 40.63980) as geom 
      union all select 'LAX','Los_Angeles_International_Airport', ST_POINT(-118.40800,33.94250) 
      union all select 'SEA','Seattle_Tacoma_International_Airport',ST_POINT(-122.30900,47.44900) 
      union all select 'MIA','Miami_International_Airport',ST_POINT(-80.29060,25.79320)
   )
   SELECT t1.iata as iata1, t2.iata as iata2, carto.ST_GREATCIRCLE(t1.geom, t2.geom, 25) AS geom
   FROM data AS t1
   CROSS JOIN data AS t2
   WHERE t1.iata != t2.iata
   ```

   You can also take advantage of this function directly from a table from your database:

   ```sql
   WITH data AS(
       SELECT *
       FROM mydatabase.myschema.table
   )
   SELECT t1.column as column1, t2.column as column2, carto.ST_GREATCIRCLE(t1.geom, t2.geom, 25) AS geom
   FROM data AS t1
   CROSS JOIN data AS t2
   WHERE t1.column != t2.column
   ```
5. Run the first query. In this example we will showcase how easily we can compute all the paths that interconnect the main four US airports using the Analytics Toolbox.

   <figure><img src="/files/6xUSRysntAr2zJVu4NEt" alt=""><figcaption></figcaption></figure>

This query first creates all the possible combinations between airports and then generates the paths between them using the `ST_GREATCIRCLE` function. The resulting paths contain 25 points, but you can set the number of points in order to make the lines smoother if needed.

{% hint style="info" %}
**More Examples**

For more examples, visit the [Examples](https://academy.carto.com/advanced-spatial-analytics/spatial-analytics-for-redshift/step-by-step-tutorials) section in our Academy or try executing any of the queries included in every function definition in the [SQL Reference](https://docs.carto.com/data-and-analysis/analytics-toolbox-for-redshift/sql-reference).
{% endhint %}


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.carto.com/data-and-analysis/analytics-toolbox-for-redshift/guides/running-queries-from-builder.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.