Snowflake Plugin Available NOW on VSCode

We have great news! Snowflake has released its own VSCode Plugin! It’s currently in Public Preview (PuPr) and you can download it from the Microsoft Visual Studio Extension marketplace. With the plugin, you will have access to some features such as:

 

  • Accounts and Sessions: the plugin allows you to connect to and easily switch between multiple Snowflake accounts. And (this is cool) you can share a single session between multiple open VSCode editor windows! Support for Single Sign On (SSO) is available.
  • Snowflake SQL Intellisense: autocomplete for object names, keywords, and built-in functions, with signature help for function calls. Links to documentation for keywords and built-in functions on hover.
  • Database Explorer: a treeview-based panel that lets you drill down into object definitions and details.
  • Query Execution: not just single statements, but multiple statement executions!
  • Query Results and History panel: View and sort query results and export results to CSV format. Review prior statement history and results, and copy/paste support on previous queries.

 

Here is a quick guide on how to install the Snowflake plugin on VSCode.

 

  1. Launch VSCode and head over to the Extensions Marketplace tab

     2. Type in “Snowflake” and select the verified Snowflake extension (It should have the verification checkmark)

     3. Click on the Snowflake icon to log in. The extension will ask for your account’s URL however this part can be tricky. Instead of inputting the whole URL just add the part before .snowflakecomputing.com

 

For example, if your account URL is https://ja13154.east-us-2.azure.snowflakecomputing.com/, enter ja13154.east-us-2.azure in the Account Name/URL box.

 

                                 

 

    4. As a final step add your username and password and you are all set to go!

SnowCompare

SnowCompare is the easiest and fastest way to compare & deploy Snowflake data from one database or schema to another.

For example, when you clone a database several times and you want to understand the differences between the clone and the original database, you can use SnowCompare to easily view the difference.

Even though Snowflake allows you to code and write SQL to compare data,  it’s still regularly cumbersome for a regular user or analyst. Therefore, we highly recommend using SnowCompare since it is easier to use.
Get on the waiting list for this free tool!  We plan to release it in October.

Find out more about all the benefits SnowAdmin has to offer you and your business. Sign up for a free proof of concept!

SnowCompare

SnowCompare

SnowCompare is the easiest and fastest way to compare & deploy Snowflake data from one database or schema to another.
While Snowflake allows you to code and write SQL to compare data it’s still regularly cumbersome for a regular user or analyst.
Zero Copy Cloning is so easy in Snowflake but what happens when you cloned a database several times and you want to understand the differences between the clone and the original database?
This is where SnowCompare comes in and makes this super easy to visually see the differences.
Get on the waiting list for this free tool!  We plan to release in October.

Find out more about all the benefits SnowCompare has to offer you and your business. Sign up for a free proof of concept!

SnowSheets

SnowSheets

SnowSheets allows you to connect Google Sheets to a Snowflake database.

You can:
  • View (select) Snowflake data within Google Sheets.
  • Create tables, update, insert, and delete rows from tables and keep Google Sheets synchronized with Snowflake.
  • Allows for easier editing of data within Snowflake.

Get on the waiting list for this free tool! We plan to release in September.

Find out more about all the benefits SnowSheets has to offer you and your business. Sign up for a free proof of concept!

Looker

Looker is a business intelligence software and big data analytics platform that helps you explore, analyze and share real-time business analytics easily.

Looker is the ideal tool to use with Snowflake:

  • Analyze both structured and semi-structured data with ease
  • Leave your data in Snowflake, granularly control Continue reading

Snowflake vs Hadoop

Snowflake vs Hadoop

Lots of people are aware of Hadoop for its advantages, like ease of data loading and scaling, but more and more are becoming increasingly aware of its limitations, like Continue reading

Localytics: Data Sharing with Snowflake

Localytics: Data Sharing with Snowflake

Localytics provides market engagement analysis services to makers of apps far and wide. Being a data company, and given the prevalence of mobile apps today, plus with how many clients were making use of their SDK, the scale of their data requirements climbed into the Petabytes. The costs for this level of data, using their legacy data warehousing system, shot into territory that just no longer made sense for them as a business (to say nothing for an ever growing latency issue as well). Continue reading