Building Dashboards using Snowsight
Thanks for reading my earlier blogs on Snowflake, we are going to learn more about Snowsight — new Web UI. Snowsight is used to build dashboards and used natively with Snowflake.
What is Snowsight?
Snowsight is the snowflake web interface. This is little different than the classic web UI. This UI offers easy to use experience and can perform all activities same as classic UI.
We can create worksheets and run all types of queries same as classic UI. We can also access data marketplace , databases, data same as classic UI.
What is different in Snowsight?
1. With snowsight we can create dashboards leveraging data available. These can be used to build any type of visualization natively with Snowflake. We can also share dashboards created with Snowsight.
2. Snowsight can also be used to monitor all types of activities through activity tab here. We can monitor queries getting executed, query details, view performance of data, explore each step of executed query ( used for analysis), monitor status of data load activities etc.
3. Admin area of Snowsight offers managing snowflake usage, warehouses, managing users, roles, performing administrative activities, setup payments and methods etc.
How to create dashboards using Snowsight?
We can go to dashboard tab of Snowsight and it list down all the dashboards present there and allow us to create new dashboards.
We can use +Dashboard button on top right corner to create new dashboard. It opens up new window to allow us to add different widgets of our choices to build our custom dashboard.
- Click on +Dashboard button , it pops out for dashboard name –
2. Give dashboard name of choice representing which dashboard is getting build. Once create dashboard is hit it opens up new dashboard window –
3. This is dashboard window, click on new tile to add new tiles/widgets to dashboard. Once click on new tile, a window opens where we can explore on datasets/tables/databases we want to use to build dashboards. We can write down queries to create charts.
4. Once query is run, it shows option to create chart as shown below –
5. We can choose chart type — line, bar,heatmap,scoreboard. We can also specify the X, Y axis of graphs .
6. Once chart is selected and drawn, click on return to dashboard on top left corner and it will add this tile/widget to dashboard.
7. We can add multiple tiles to create a dashboard out of it and the same can be shared with users.
I believe, this blog will help to learn Snowsight and building dashboards with Snowsight. In next blog, we will learn more about monitoring, administrative dashboards to help to monitor and manage snowflake accounts for customers as well as self.
About Me :
I am DWBI and Cloud Architect! I am currently working as Senior Data Architect — GCP, Snowflake. I have been working with various Legacy data warehouses, Bigdata Implementations, Cloud platforms/Migrations. I am SnowPro Core certified Data Architect as well as Google certified Google Professional Cloud Architect. You can reach out to me LinkedIn you need any further help on certification, Data Solutions and Implementations!
