Tag: analytics

Snowflake Plugin Available NOW on VSCode

Posted on by Daniel Steinhold

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 Snowflake 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.

 

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!

 

With these simple steps, you can now use the Snowflake Plugin on VSCode. If you want to learn about other new features on Snowflake, be sure to check out our blog for new updates.

SnowCompare

Posted on by Philip de Souza

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!

Also, if you want you want to learn about more news or features, be sure to check out our blog on a regular basis.

SnowCompare

Posted on by Philip de Souza

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

Posted on by Philip de Souza

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

Posted on by Philip de Souza

Intro - What is Looker?

Looker is a business intelligence software and big data analytics platform that is designed to analyze both structured and semi-structured data. It is ideal to use with Snowflake, as it allows users to analyze data from disparate sources, transform data into knowledge right at query time, and leverage all the power and flexibility of Snowflake directly from Looker. Additionally, it enables users to make sense of all their data with one tool and to chart, graph, format, and explore data in one place. It also allows users to share data via URL, access data wherever they need it, schedule delivery, and export data locally or directly to Google Drive, Dropbox, or S3. Looker is fully embeddable with SSO and has a responsive mobile design.

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 access from Looker.
  • Define business logic to transform data into knowledge right at query time.
  • Any data that is shared through the Sharehouse is immediately available in Looker. Known datasets can use Looker Blocks™ and extensions to share a data model as well as data.
  • Snowflake’s advanced SQL dialect is rich in features. Leverage all the power and flexibility of Snowflake directly from Looker.

Analyze data from disparate sources:

  • Adapt Looker to fit your data.
  • Direct connection to any SQL database.
  • Virtual, code-based schema applied at query time for flexibility.
  • Make sense of all your data with one tool.

Governance:

  • Centrally-defined, version-controlled business logic lives for everyone to use.
  • Collaboration and versioning with Git.
  • Every analyst gets a sandbox.
  • Every version of your definitions is easily accessible and implementable.

Give everyone immediate access to information:

  • Everyone can self-serve from curated data.
  • Connect directly to the database to explore all your data.
  • Centrally defined and shared metrics.

Chart, graph, format, and explore data in one place:

  • Web-native, interactive visualizations.
  • In-browser visualizations.
  • Drag & drop to create or edit their dashboards.
  • Custom visualizations.

Leverage the Value of Your Data:

  • Sharing via URL.
  • Access your data wherever you need it (Slack, Salesforce, etc.).
  • 100% browser-based.
  • Everyone can schedule delivery.
  • Export locally or export directly to Google Drive, Dropbox, or S3.
  • Fully embeddable with SSO.
  • Responsive mobile design.

Conclusion:

In conclusion, Looker is a powerful business intelligence software that is designed to analyze both structured and semi-structured data. It is particularly useful when used with Snowflake, as it enables users to leverage all the power and flexibility of Snowflake directly from Looker. With its ability to analyze data from disparate sources, transform data into knowledge right at query time, and explore and share data in one place, Looker is an ideal tool for businesses looking to make the most of their data.

If you want more news and information on Snowflake updates, be sure to check out our blog.

Snowflake vs Hadoop

Posted on by Philip de Souza

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

Posted on by Philip de Souza

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 →