Top 9 Snowflake Productivity Tools in 2021

#1 - SnowSQL CLI client

SnowSQL is the command-line client to execute SQL queries and perform all DDL and DML operations, including loading data into and unloading data out of snowflake tables.

Pros:

  • SnowSQL can be run as an interactive shell or in batch mode through stdin or using the -f option.
  • Supports Windows, Mac and Linux
  • You can integrate it with EverSQL APIs to perform Snowflake cost optimization

#2 - DBeaver

Pros:

  • NoSQL and Snowflake support (Commercial Edition Only)
  • Simple steps to connect to your Snowflake database
  • Multi-Platform Databases
  • Intuitive and very easy to use user interface.
  • Free to download, licensed under GPL.
  • You can Render ERDs to visual your database
  • Easy Import/Export/Backup
  • Mock Data Generator
  • Visual Query Builder (Enterprise Edition Only)
  • Analytical charts (Enterprise Edition Only)
  • Query History (Enterprise Edition Only)
  • Cross-platform - versions available for Windows, Linux and Mac OS.
  • Easy way to export your schema and perform Automatic Database Tuning with EverSQL

Cons:

  • Sometimes large queries can’t be stopped and have to be forcefully killed. In some cases, the entire application has to be killed.

Price: Free for basic usage. Commercial Lite Edition starts at $99 a year

#3 - EverSQL Cost Optimization for Snowflake

EverSQL is an AI-based Cost Optimization solution that helps you to speed up the query and reduce the cost.

Pros:

  • Automatic query rewrite
  • Supports basic and complex queries
  • Can reduce the query cost by 30% or more.
  • Holistic warehouse cost analysis
  • Analysts friendly. Doesn't require DBA expertise
  • Easy way to reduce your Snowflake cost

Cons:

Price: Free for basic usage.

#4 Partner Connect by Snowflake

Snowflake offers an official marketplace that will help you connect 3rd party software vendors

Pros:

  • List of Snowflake-specific partners that you can integrate with your Warehouses.
  • Reduce time to integrate.
  • Requires an AccountAdmin before you can use it.
  • Easy way to run Snowflake cost optimization with EverSQL

Cons:

  • Not all Snowflake tools are listed

Price: Depends on the specific partner

#5 - FiveTran

 

 

 

 

FiveTran stream data into your warehouse for advanced analytics. Fivetran was built to enable analysts to access their business data.

Pros:

Price: Free 14-days trial, $1 to $2 per credit/minute.

#6 - SQLMorph

 

 

 

 

 

 

SQL Morph is a free SQL Translator to Snowflake

Pros:

  • A great way to migrate your legacy code for one database to another
  • Reduce human errors

Cons:

Price: Free for basic usage.

 #7 - DataGrip by JetBrain

Pros:

  • Very fast auto-complete
  • Plug-ins available - Large marketplace with many useful add-ons
  • Notifications when long queries have completed
  • Refactorings that work in SQL files and schemas - Enable you to change column names and perform mass updates
  • Version control integration
  • Multi-Platform Databases, Including Snowflake
  • Built-in support for all popular databases
  • Easy flow to download relevant drivers
  • Diff viewer for routines
  • Introspection - You can observe collections and fields in the database explorer.
  • Cross-platform - versions available for Windows, Linux and Mac OS.
  • Easy way to export your schema and perform Automatic Database Tuning with EverSQL

Cons:

  • No Free version. Only 30 days trial

Price: Starts at $199.00

#8 - ETL Tools (ETL EcoSystem)

 

 

 

 

ETL are essential tools for any Snowflake implementation. If you are not sure what ETL stands for, here is the explanation:

  • Extract - Exporting data from specified data sources.
  • Transform - Modifying the source data (as needed), using rules, merges, lookup tables or other conversion methods, to match the target.
  • Load - Importing the resulting transformed data into a target database.

If you are not sure which ETL Tool is the right tool for you, check out Snowflake documentation with their list of approved ETL solutions.

Pros:

  • A great large dataset that can help you improve your Snowflakes expertise
  • Enrichment data for specific use-cases

Price: Depends on the specific vendor.

#9 - Snowflake Free Public Datasets

 

 

Need good sample datasets? You can now access third-party data to provide deeper insights to your organization, and get your own data from SaaS vendors you already work with, directly into your Snowflake account.
It gives you access to more than 375 live and ready-to-query data sets from more than 125 third-party data providers and data service providers (as of January, 2021).

Pros:

  • A good list with system requirements and detailed resources.

Price: Free