page58
40
Query Profile Overview
In this section, you will learn how to utilize SnowSight to access the query profiler. I am
assuming your Snowflake account is available and ready for use.
In this section, you will use the imported share
SNOWFLAKE_SAMPLE_DATA
database,
which is provisioned on account creation.
First, within your new worksheet, change the role to
ACCOUNTADMIN
:
USE ROLE accountadmin;
Your database tab should refresh to display the database
SNOWFLAKE_SAMPLE_DATA
.
Figure 3-1 shows the database
SNOWFLAKE_SAMPLE_DATA
within the database browser.
Hover the mouse over the three dots […] outlined in red in the figure; you’ll see the pop-
up window showing details of the database
SNOWFLAKE_SAMPLE_DATA
. You can see the
imported database is a share.
Figure 3-1.
SNOWFLAKE_SAMPLE_DATA database
Many Snowflake accounts drop the imported
SNOWFLAKE_SAMPLE_DATA
database. If
your account does not show
SNOWFLAKE_SAMPLE_DATA
within the database browser while
using the role
ACCOUNTADMIN
, you may want to either create a new trial account or follow
the instructions at
https://docs.snowflake.com/en/user-guide/sample-data-using
to reimport the dropped share.
ChapTer 3
The Query profiler