# SQL Tools

The SQL Tools extension allows to explore your Snowflake database from within BlackDiamond Studio, run database queries to retrieve data from your tables, insert data, validate updates, and manage multiples database connections.&#x20;

![](/files/GBOthSTHhBf75xskT3tr)

1. To open the SQL Tools click on the cylinder icon in the left task bar.\
   \
   ![](/files/vf3GXGpou9iCBxtxOKik)<br>
2. Run a query:
   1. To run a query click on the **new SQL file** button.\
      &#x20;![](/files/2c12wSFHGWJpvvta3egL)
   2. Learn more about [Snowflake queries](https://docs.snowflake.com/en/).&#x20;
3. Manage your database connections: <br>
   1. In this extension, you can see the Snowflake connection you [previously set up](/blackdiamond-studio-or-mobilize.net/blackdiamond-studio-documentation/bds-portal/creating-my-first-project/4.-connect-to-snowflake.md) in the [web portal](https://bds.mobilize.net/). \
      ![](/files/eRwQqBWOQEueUCLLqooW)<br>
   2. If you do not have a Snowflake connection, you can add multiple connections by clicking on **Add new connection** button. \
      ![](/files/srAfnD9bJ0ooFvjCviIk)<br>
   3. To add a second connection, click on the cylinder with a plus icon. \
      ![](/files/SAb5sKirLzR2WtK7qd7j)<br>
   4. Click the Snowflake icon.&#x20;

![](/files/TpBeGQyCdgIqZHqiCOsX)

&#x20;     5\.  Fill the required text fields marked with an asterisk. For more information about how to fill the Snowflake connection form, visit the [Connect to Snowflake](/blackdiamond-studio-or-mobilize.net/blackdiamond-studio-documentation/bds-portal/creating-my-first-project/4.-connect-to-snowflake.md) section that explains where to get the right data to complete the required text fields.

![](/files/W3FKYJKwC0zeXWbN1fwW)

&#x20;      6\.  Click **Save Connection.**

![](/files/1NFUvgvGtsHXwchV8vzY)

&#x20;      7\. Your active connection is the one used to deploy to Snowflake. The green dot indicates which is your active connection. To change it double click on the connection you want to make active.&#x20;

![](/files/Y10KLOTPZzYYAmZ7mm4q)


---

# 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.gapvelocity.ai/blackdiamond-studio-or-mobilize.net/blackdiamond-studio-documentation/online-code-editor/sql-tools.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.
