Sign inGet started
← Back to all guides

How to share queries in Snowflake

By Nick Barth

Updated on March 6, 2024

Snowflake is a comprehensive cloud data platform that enables data storage, processing, and analytic solutions. It provides a multitude of services including the sharing of data and collaborative query editing. When it comes to sharing queries created inside Snowflake, one efficient method is using Deepnote.

Deepnote is a collaborative data notebook that integrates well with Snowflake and many other data sources. It offers real-time collaboration, similar to Google Docs, making it an ideal environment for teams to work together on data queries and analysis.

Here's how to share queries in Snowflake using Deepnote:

Step 1: Set up Snowflake integration

Before sharing your queries, ensure that you have integrated Snowflake with Deepnote. To do this:

  1. Go to your Deepnote project.
  2. Click on 'Integrations' in the left sidebar.
  3. Select Snowflake and follow the instructions to connect your account by entering the required connection details such as account name, username, password, warehouse, database, and schema.

Step 2: Write your query in Deepnote

Once the integration is complete, you can write and execute your Snowflake queries directly in Deepnote.

  1. Create a new notebook or open an existing one in your Deepnote project.
  2. Write your SQL query within a code cell.
  3. Execute the query to ensure it runs correctly on Snowflake. This will also save the query in your Snowflake history.

Step 3: Share your Deepnote project

With your query written and tested, you can now share your Deepnote project with collaborators:

  1. Click on 'Share' at the top of your Deepnote notebook.
  2. Choose what access level you would like to grant: View, Comment, or Edit.
  3. You can share the project via a link, email invitation, or through Deepnote teams if you have a team set up within the platform.

Step 4: Collaborate in real-time

After your collaborators have access, they can work with you in real time:

  1. Edits are synchronized instantly, so all collaborators can see the changes as they happen.
  2. Comments can be made on specific lines of code for easy communication about the queries.
  3. Version history allows you to track changes and restore to previous query versions if necessary.

Step 5: Manage permissions

Deepnote provides a robust permission system. You can:

  • Change permissions or revoke access at any time.
  • Set your notebook to 'public' if you want to share it more widely, although this doesn't allow for interactive collaboration.

Conclusion:

By using Deepnote, teams working with Snowflake can collaborate on their SQL queries in a dynamic and effective manner. Anyone from content creators to data analysts can utilize this method for sharing complex data queries, getting immediate feedback, and improving productivity.

Happy querying!

Note: Make sure that every member of the team has the necessary permissions in both Snowflake and Deepnote to access and run the queries. This ensures a smooth and secure collaborative environment.

Nick Barth

Product Engineer

Nick has been interested in data science ever since he recorded all his poops in spreadsheet, and found that on average, he pooped 1.41 times per day. When he isn't coding, or writing content, he spends his time enjoying various leisurely pursuits.

Follow Nick on LinkedIn and GitHub

That’s it, time to try Deepnote

Get started – it’s free
Book a demo

Footer

Solutions

  • Notebook
  • Data apps
  • Machine learning
  • Data teams

Product

Company

Comparisons

Resources

  • Privacy
  • Terms

© Deepnote