How do I run a query in Snowsight?

345 viewsSnowsight and Classic UI

How do I run a query in Snowsight?

Daniel Steinhold Asked question October 27, 2023

To run a query in Snowsight (or a similar tool), you would typically follow these steps:

  1. Log In: Log in to your Snowsight account using your credentials. You'll need appropriate access permissions to query data.
  2. Connect to a Database: In Snowsight, you'll need to connect to a database where your data is stored. Depending on your setup, this might involve configuring a connection to your Snowflake data warehouse or another supported database.
  3. Access Your Data: After connecting to the database, you should be able to access the tables and datasets that you want to query. These tables will typically be listed in the user interface.
  4. Write Your Query:
    • Click on the SQL or Query Editor.
    • Write your SQL query in the editor. For example:
    SELECT * FROM your_table
    WHERE condition;

    Replace your_table with the actual table name and condition with your filtering criteria.

  5. Run the Query:
    • Click the "Run" button or a similar option to execute your query.
    • The results of your query should be displayed in the results pane.
  6. Review Results:
    • Examine the results of your query in the results pane. You can typically export the results or perform additional actions on the data as needed.
  7. Save or Share the Query:
    • If you want to save the query for future use or share it with others, Snowsight may provide options for saving and managing queries.
  8. Log Out: Don't forget to log out of your Snowsight account for security purposes.

Please note that the specific steps and features can vary based on the version of Snowsight and your organization's setup. I recommend referring to the official Snowsight documentation or contacting your organization's IT or data team for detailed and up-to-date guidance on using Snowsight for querying your data.

Daniel Steinhold Changed status to publish October 27, 2023
Feedback on Q&A