BlackDiamond Studio | Mobilize.Net
  • BlackDiamond Studio Documentation
    • Introduction
    • BDS Portal
      • Sign Up
      • Sign In
      • Reset Password and Multifactor Authentication
      • User Interface
      • Projects List
        • Navigating the Projects List
      • Creating my first project
        • 1. What do you want to do?
        • 2. Name Project
        • 3. Set up Repository
        • 4. Connect to Snowflake
        • 5. Code
          • 1. Select a Template
          • 2. Extract DDL from Snowflake Account
          • 3. Upload my source code
            • Folder Names Not Allowed
      • Project Summary Page
      • Sharing a Project
      • Getting a Project Invite
      • Editing a Project Member's Role
      • Deleting a Project
    • Code Conversions
      • Converting SQL code to Snowflake
        • Conversion settings
      • Converting Scala code using Snowpark
      • Convert Python code using Snowpark (Coming soon)
      • Converting from the IDE
      • Conversion Errors
    • Online Code Editor
      • Running a Streamlit App
      • Writing Scala Code
      • Writing Python Code
      • Source Control (VS Code)
      • Run and Debug
      • Testing
      • Reports Explorer
      • SQL Tools
      • Snow Explorer
      • Metals (Scala)
      • Scala Notebooks
      • Contextual Menu
    • Code Insights
      • What to expect: Insight Reports
      • Language structures support
      • Scripting languages support
      • Reports Explorer
      • Storage of reports in client stage
    • Templates
      • Templates Dependencies
    • Use Cases
      • Assessment with SnowConvert
    • Submitting Bugs and Suggestions
    • Troubleshooting
      • Folder Naming
      • Cloning with GitLab
      • Third-party Cookies used in BlackDiamond Studio
    • System Requirements and Supported Browsers
    • Release Notes
  • Snowconvert Software License Agreement
Powered by GitBook
On this page
  1. BlackDiamond Studio Documentation
  2. Online Code Editor

SQL Tools

PreviousReports ExplorerNextSnow Explorer

Last updated 2 years ago

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.

  1. To open the SQL Tools click on the cylinder icon in the left task bar.

  2. Run a query:

    1. To run a query click on the new SQL file button.

    2. Learn more about .

  3. Manage your database connections:

    1. In this extension, you can see the Snowflake connection you in the .

    2. If you do not have a Snowflake connection, you can add multiple connections by clicking on Add new connection button.

    3. To add a second connection, click on the cylinder with a plus icon.

    4. Click the Snowflake icon.

6. Click Save Connection.

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.

5. Fill the required text fields marked with an asterisk. For more information about how to fill the Snowflake connection form, visit the section that explains where to get the right data to complete the required text fields.

Connect to Snowflake
Snowflake queries
previously set up
web portal