Snowsight is open for all accounts running on Amazon Web Services and Microsoft Azure, while Google Cloud Platform is planned to be supported.
Snowflake has recently introduced a new, desktop-quality web user interface for ad-hoc data analysis and verification that supports fast querying, SQL auto-completion, automatic stats, and various charts for data visualization. The application is still in preview mode, meaning the account admins need to click on the Preview App menu and enable Snowsight. As of writing the article, Snowsight is open for all accounts running on Amazon Web Services and Microsoft Azure, while Google Cloud Platform is planned to be supported.
According to Snowflake, the main use cases for Snowsight are data validation, explorative SQL queries, and "quick charts" to share with team members, while the classic BI tools such as Tableau, Qlik, or Power BI are more geared towards corporate reporting needs, business users and complex dashboards
_Figure 1: When to use Snowsight (Source: Snowsight Academy) _
One of the most attractive features of Snowsight compared to the classic Worksheet is that it supports context-sensitive auto-completion.
For instance, if you are typing a SELECT statement and start entering curr, Snowsight will recommend matching SQL functions that can be used in that place.
Figure 2: Auto-completion with SQL functions
Or, in the FROM section of the SQL statement, you can choose the names of the available tables offered by auto-completion:
Figure 3: Auto-completion with table names
When the SQL queries are executed, the Results section contains the data retrieved by the query and in addition to that, Snowsight will also provide statistics such as how many rows have been retuned, how long running the query took, how well the columns in the table are populated, etc. This can help system admins or data analysts to quickly identify potential data quality issues.
SQL stands for Structured Query Language. SQL is a scripting language expected to store, control, and inquiry information put away in social databases. The main manifestation of SQL showed up in 1974, when a gathering in IBM built up the principal model of a social database. The primary business social database was discharged by Relational Software later turning out to be Oracle.
‘Data is the new science. Big Data holds the key answers’ - Pat Gelsinger The biggest advantage that the enhancement of modern technology has brought
We need no rocket science in understanding that every business, irrespective of their size in the modern-day business world, needs data insights for its expansion. Big data analytics is essential when it comes to understanding the needs and wants of a significant section of the audience.
In this article, see the role of big data in healthcare and look at the new healthcare dynamics. Big Data is creating a revolution in healthcare, providing better outcomes while eliminating fraud and abuse, which contributes to a large percentage of healthcare costs.
Big Data Analytics is the next big thing in business, and it is a reality that is slowly dawning amongst companies. With this article, we have tried to show you the importance of Big Data in business and urge you to take advantage of this immense...