What is SHOW function in Snowflake?

Are you looking to find what is the SHOW function within the Snowflake cloud data warehouse or maybe you are looking for a solution on how to use the show function in the Snowflake? You may also be wondering how to view or list the various objects like table, views, procedure, stages, pipes, roles, user, and many others, then you have landed on the correct page. I will also explain to you in detail what is the show function when to use it, how to use in step by step manner with practical examples. So don’t waste time let’s start understanding the show in Snowflake through step by step guide.

What is SHOW Function in Snowflake?

Show function in Snowflake is used to list out the objects for which it has been used. For example Show tables, will list out all the tables available within the selected database and schema based on your current role.

How to use SHOW Function in Snowflake?

Many times you wanted to get the list of the various Snowflake objects like tables, stages, views, procedures, tasks, roles and etc. Show function helps you to display all these items for the mentioned object type.

Show output includes metadata for the objects, including common properties ( name, comment, creation timestamp ) and Object-specific properties.

What is the Syntax of the SHOW function in Snowflake?

-- Syntax : 

SHOW OBJECT [ LIKE ‘pattern’ ] [ IN object_type [ object_name ] ] 

Here OBJECT can be anything like tables, stages, views, tasks, procedures, roles, etc.

LIKE [‘pattern’] is optional. You can use the like clause to filter out the list of the object to return based on the condition.

Key Features of the output of SHOW function in Snowflake

  • SHOW commands do not require a running warehouse to execute.
  • SHOW commands only return the objects for which the current user’s current role has been granted the necessary access privileges. For example :
    • SHOW DATABASES output includes the databases for which the user’s role has the OWNERSHIP or USAGE.
    • SHOW SCHEMAS output includes the Schemas for which the user’s role has the OWNERSHIP or USAGE.
    • SHOW TABLES output includes the tables for which the user’s role has the OWNERSHIP or USAGE. The role must also have USAGE privilege on the parent schema and database.
  • To command returns a maximum of 10k records for the specified object type.

When you should use the SHOW() Function in Snowflake?

There are certain use case scenarios when it is recommended to use the SHOW function within the Snowflake cloud data warehouse which are as follows:

  • You want to get information about the databases, Schemas, Tables, Views and many more. For example, I want to know, how many databases are present including with their names.

Real World Use Case Scenarios for SHOW Function in Snowflake

  • You wanted to fetch all the details about a mall in which we will be having many stores, each store represents a specific product.
  • People living in an Apartment or in Community.

SHOW() Snowflake Official Documentation Link

Examples of Show function:

How to show the database in Snowflake with example?

You can get the list of the database available in the Snowflake using the Show database SQL command as follows.

SHOW DATABASES;
+-------------------------------+-----------------------+------------+------------+-------------------------+--------------+---------------------------------------------------+---------+----------------+
| created_on                    | name                  | is_default | is_current | origin                  | owner        | comment                                           | options | retention_time |
|-------------------------------+-----------------------+------------+------------+-------------------------+--------------+---------------------------------------------------+---------+----------------|
| 2021-12-14 22:14:06.323 -0800 | DEMO                  | N          | N          |                         | SYSADMIN     |                                                   |         | 1              |
| 2021-12-14 21:54:46.657 -0800 | SNOWFLAKE_SAMPLE_DATA | N          | N          | SFC_SAMPLES.SAMPLE_DATA | ACCOUNTADMIN | Provided by Snowflake during account provisioning |         | 1              |
+-------------------------------+-----------------------+------------+------------+-------------------------+--------------+---------------------------------------------------+---------+----------------+


How to show the tables in a Snowflake with an example?

You can get the list of the tables available in the Snowflake using the Show tables SQL command as follows.

SHOW TABLES;

+-------------------------------+-----------------+---------------+-------------+-----------+---------+------------+------+-------+----------+----------------+----------------------+-----------------+-------------+
| created_on                    | name            | database_name | schema_name | kind      | comment | cluster_by | rows | bytes | owner    | retention_time | automatic_clustering | change_tracking | is_external |
|-------------------------------+-----------------+---------------+-------------+-----------+---------+------------+------+-------+----------+----------------+----------------------+-----------------+-------------|
| 2021-12-31 15:09:59.264 -0800 | BINARY_TABLE    | DEMO          | PUBLIC      | TABLE     |         |            |    1 |  1536 | SYSADMIN | 1              | OFF                  | OFF             | N           |
| 2021-12-20 01:52:32.203 -0800 | DUMMY_EMP       | DEMO          | PUBLIC      | TABLE     |         |            |    1 |  1024 | SYSADMIN | 1              | OFF                  | OFF             | N           |
| 2021-12-14 22:14:14.114 -0800 | EMP             | DEMO          | PUBLIC      | TABLE     |         |            |    3 |  1536 | SYSADMIN | 1              | OFF                  | OFF             | N           |
| 2021-12-14 22:56:21.693 -0800 | EMP_ONE         | DEMO          | PUBLIC      | TABLE     |         |            |    5 |  1024 | SYSADMIN | 1              | OFF                  | OFF             | N           |
| 2022-01-12 12:28:14.094 -0800 | REPLACE_EXAMPLE | DEMO          | PUBLIC      | TABLE     |         |            |    2 |  1536 | SYSADMIN | 1              | OFF                  | OFF             | N           |
| 2022-01-12 19:40:24.643 -0800 | RND1            | DEMO          | PUBLIC      | TEMPORARY |         |            |    4 |  1024 | SYSADMIN | 1              | OFF                  | OFF             | N           |
+-------------------------------+-----------------+---------------+-------------+-----------+---------+------------+------+-------+----------+----------------+----------------------+-----------------+-------------+


How to show tasks in Snowflake with an example?

You can get the list of the tasks available in the Snowflake using the Show tasks SQL command as follows.

show TASKS;

+-------------------------------+-----------+--------------------------------------+---------------+-------------+--------------+---------+-----------+--------------------------+--------------+-----------+---------------------------------------------------+-----------+-----------------------------+
| created_on                    | name      | id                                   | database_name | schema_name | owner        | comment | warehouse | schedule                 | predecessors | state     | definition                                        | condition | allow_overlapping_execution |
|-------------------------------+-----------+--------------------------------------+---------------+-------------+--------------+---------+-----------+--------------------------+--------------+-----------+---------------------------------------------------+-----------+-----------------------------|
| 2022-02-02 13:13:47.717 -0800 | T1        | 01a20c99-73b8-7ecf-0000-000000000002 | DEMODB        | PUBLIC      | ACCOUNTADMIN |         | NULL      | USING CRON 3 * * * * UTC | NULL         | suspended | INSERT INTO mytable(ts) VALUES(CURRENT_TIMESTAMP) | NULL      | false                       |
| 2022-02-02 13:14:00.660 -0800 | TASK1     | 01a20c9a-6438-8054-0000-000000000003 | DEMODB        | PUBLIC      | ACCOUNTADMIN |         | NULL      | USING CRON 3 * * * * UTC | NULL         | suspended | INSERT INTO mytable(ts) VALUES(CURRENT_TIMESTAMP) | NULL      | false                       |
| 2022-02-02 13:14:09.595 -0800 | TASK_2    | 01a20c9a-09d7-4f4c-0000-000000000005 | DEMODB        | PUBLIC      | ACCOUNTADMIN |         | NULL      | USING CRON 3 * * * * UTC | NULL         | suspended | INSERT INTO mytable(ts) VALUES(CURRENT_TIMESTAMP) | NULL      | false                       |
| 2022-02-02 13:14:15.068 -0800 | TASK_DEMO | 01a20c9a-21cc-b259-0000-000000000006 | DEMODB        | PUBLIC      | ACCOUNTADMIN |         | NULL      | USING CRON 3 * * * * UTC | NULL         | suspended | INSERT INTO mytable(ts) VALUES(CURRENT_TIMESTAMP) | NULL      | false                       |
| 2022-02-02 13:14:06.659 -0800 | TASK_NEW  | 01a20c9a-6384-5312-0000-000000000004 | DEMODB        | PUBLIC      | ACCOUNTADMIN |         | NULL      | USING CRON 3 * * * * UTC | NULL         | suspended | INSERT INTO mytable(ts) VALUES(CURRENT_TIMESTAMP) | NULL      | false                       |
+-------------------------------+-----------+--------------------------------------+---------------+-------------+--------------+---------+-----------+--------------------------+--------------+-----------+---------------------------------------------------+-----------+-----------------------------+

How to show Stages in Snowflake with an example?

You can get the list of the stages available in the Snowflake using the Show stages SQL command as follows.

+-------------------------------+-------+----------------+-------------+-----+-----------------+--------------------+----------+---------+--------+----------+-------+----------------------+---------------------+
| created_on                    | name  | database_name  | schema_name | url | has_credentials | has_encryption_key | owner    | comment | region | type     | cloud | notification_channel | storage_integration |
|-------------------------------+-------+----------------+-------------+-----+-----------------+--------------------+----------+---------+--------+----------+-------+----------------------+---------------------|
| 2022-02-02 08:59:33.967 -0800 | BLOBS | WORKSHEETS_APP | PUBLIC      |     | N               | N                  | APPADMIN |         | NULL   | INTERNAL | NULL  | NULL                 | NULL                |
+-------------------------------+-------+----------------+-------------+-----+-----------------+--------------------+----------+---------+--------+----------+-------+----------------------+---------------------+

How to show Users in Snowflake with an example?

You can get the list of the users available in the Snowflake using the Show users SQL command as follows.

+--------------+-------------------------------+--------------+--------------+---------------+-----------+----------------------------+----------------+-------------------+---------+----------+----------------------+----------------+-------------------+-------------------+--------------+-------------------------+---------------+---------------+--------------------+--------------+-------------------------------+-------------------------------+-------------------+--------------+--------------------+
| name         | created_on                    | login_name   | display_name | first_name    | last_name | email                      | mins_to_unlock | days_to_expiry    | comment | disabled | must_change_password | snowflake_lock | default_warehouse | default_namespace | default_role | default_secondary_roles | ext_authn_duo | ext_authn_uid | mins_to_bypass_mfa | owner        | last_success_login            | expires_at_time               | locked_until_time | has_password | has_rsa_public_key |
|--------------+-------------------------------+--------------+--------------+---------------+-----------+----------------------------+----------------+-------------------+---------+----------+----------------------+----------------+-------------------+-------------------+--------------+-------------------------+---------------+---------------+--------------------+--------------+-------------------------------+-------------------------------+-------------------+--------------+--------------------|
| DEMOACCOUNT2 | 2022-02-02 08:59:31.638 -0800 | DEMOACCOUNT2 | DEMOACCOUNT2 | Revanth Kumar | Bondada   | saibabubondada69@gmail.com |                |                   |         | false    | false                | false          | COMPUTE_WH        |                   | ACCOUNTADMIN |                         | false         |               |                    | ACCOUNTADMIN | 2022-02-02 09:35:53.360 -0800 | NULL                          | NULL              | true         | false              |
| SNOWFLAKE    | 2022-02-02 08:59:31.658 -0800 | SNOWFLAKE    | SNOWFLAKE    |               |           |                            |                | 0.809699074074074 |         | false    | false                | false          |                   |                   |              |                         | false         |               |                    |              | NULL                          | 2022-02-03 08:59:34.415 -0800 | NULL              | true         | false              |
+--------------+-------------------------------+--------------+--------------+---------------+-----------+----------------------------+----------------+-------------------+---------+----------+----------------------+----------------+-------------------+-------------------+--------------+-------------------------+---------------+---------------+--------------------+--------------+-------------------------------+-------------------------------+-------------------+--------------+--------------------+

How to show Views in Snowflake with an example?

You can get the list of the views available in the Snowflake using the Show views SQL command as follows.

show views;

+-------------------------------+-------------------------------------+----------+-----------------------+----------------------+-------+------------------------------------------------------------------------------------------------------------+------+-----------+-----------------+
| created_on                    | name                                | reserved | database_name         | schema_name          | owner | comment                                                                                                    | text | is_secure | is_materialized |
|-------------------------------+-------------------------------------+----------+-----------------------+----------------------+-------+------------------------------------------------------------------------------------------------------------+------+-----------+-----------------|
| 1969-12-31 16:00:00.000 -0800 | APPLICABLE_ROLES                    |          | DEMODB                | INFORMATION_SCHEMA   |       | The roles that can be applied to the current user.                                                         |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | COLUMNS                             |          | DEMODB                | INFORMATION_SCHEMA   |       | The columns of tables defined in this database that are accessible to the current user's role.             |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | DATABASES                           |          | DEMODB                | INFORMATION_SCHEMA   |       | The databases that are accessible to the current user's role.                                              |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | ENABLED_ROLES                       |          | DEMODB                | INFORMATION_SCHEMA   |       | The roles that are enabled to the current user.                                                            |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | EXTERNAL_TABLES                     |          | DEMODB                | INFORMATION_SCHEMA   |       | The external tables defined in this database that are accessible to the current user's role.               |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | FILE_FORMATS                        |          | DEMODB                | INFORMATION_SCHEMA   |       | The file formats defined in this database that are accessible to the current user's role.                  |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | FUNCTIONS                           |          | DEMODB                | INFORMATION_SCHEMA   |       | The user-defined functions defined in this database that are accessible to the current user's role.        |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | INFORMATION_SCHEMA_CATALOG_NAME     |          | DEMODB                | INFORMATION_SCHEMA   |       | Identifies the database (or catalog, in SQL terminology) that contains the information_schema              |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | LOAD_HISTORY                        |          | DEMODB                | INFORMATION_SCHEMA   |       | The loading information of the copy command                                                                |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | OBJECT_PRIVILEGES                   |          | DEMODB                | INFORMATION_SCHEMA   |       | The privileges on all objects defined in this database that are accessible to the current user's role.     |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | PACKAGES                            |          | DEMODB                | INFORMATION_SCHEMA   |       | Available packages in current account                                                                      |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | PIPES                               |          | DEMODB                | INFORMATION_SCHEMA   |       | The pipes defined in this database that are accessible to the current user's role.                         |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | PROCEDURES                          |          | DEMODB                | INFORMATION_SCHEMA   |       | The stored procedures defined in this database that are accessible to the current user's role.             |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | REFERENTIAL_CONSTRAINTS             |          | DEMODB                | INFORMATION_SCHEMA   |       | Referential Constraints in this database that are accessible to the current user                           |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | REPLICATION_DATABASES               |          | DEMODB                | INFORMATION_SCHEMA   |       | The databases for replication that are accessible to the current user's role.                              |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | SCHEMATA                            |          | DEMODB                | INFORMATION_SCHEMA   |       | The schemas defined in this database that are accessible to the current user's role.                       |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | SEQUENCES                           |          | DEMODB                | INFORMATION_SCHEMA   |       | The sequences defined in this database that are accessible to the current user's role.                     |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | STAGES                              |          | DEMODB                | INFORMATION_SCHEMA   |       | Stages in this database that are accessible by the current user's role                                     |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | TABLES                              |          | DEMODB                | INFORMATION_SCHEMA   |       | The tables defined in this database that are accessible to the current user's role.                        |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | TABLE_CONSTRAINTS                   |          | DEMODB                | INFORMATION_SCHEMA   |       | Constraints defined on the tables in this database that are accessible to the current user                 |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | TABLE_PRIVILEGES                    |          | DEMODB                | INFORMATION_SCHEMA   |       | The privileges on tables defined in this database that are accessible to the current user's role.          |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | TABLE_STORAGE_METRICS               |          | DEMODB                | INFORMATION_SCHEMA   |       | All tables within an account, including expired tables.                                                    |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | USAGE_PRIVILEGES                    |          | DEMODB                | INFORMATION_SCHEMA   |       | The usage privileges on sequences defined in this database that are accessible to the current user's role. |      | false     | false           |
| 1969-12-31 16:00:00.000 -0800 | VIEWS                               |          | DEMODB                | INFORMATION_SCHEMA   |       | The views defined in this database that are accessible to the current user's role.                         |      | false     | false           |
| 2021-12-17 14:06:16.332 -0800 | ACCESS_HISTORY                      |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-02-04 13:32:47.092 -0800 | AUTOMATIC_CLUSTERING_HISTORY        |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-06-29 16:04:33.939 -0700 | COLUMNS                             |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-05-06 12:08:09.393 -0700 | COPY_HISTORY                        |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-02-04 13:45:40.606 -0800 | DATABASES                           |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-05-04 15:18:20.286 -0700 | DATABASE_STORAGE_USAGE_HISTORY      |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2020-09-28 10:17:04.024 -0700 | DATA_TRANSFER_HISTORY               |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-02-04 13:48:53.580 -0800 | FILE_FORMATS                        |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2022-01-25 12:13:14.224 -0800 | FUNCTIONS                           |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-09-14 15:14:35.637 -0700 | GRANTS_TO_ROLES                     |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-02-10 11:46:35.962 -0800 | GRANTS_TO_USERS                     |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-02-04 14:02:18.568 -0800 | LOAD_HISTORY                        |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2019-10-22 17:07:36.398 -0700 | LOGIN_HISTORY                       |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-02-04 14:05:33.094 -0800 | MASKING_POLICIES                    |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
| 2021-02-04 14:08:47.284 -0800 | MATERIALIZED_VIEW_REFRESH_HISTORY   |          | SNOWFLAKE             | ACCOUNT_USAGE        |       |                                                                                                            |      | true      | false           |
          
+-------------------------------+-------------------------------------+----------+-----------------------+----------------------+-------+------------------------------------------------------------------------------------------------------------+------+-----------+-----------------+

How to show Warehouses in Snowflake with an example?

You can get the list of the warehouse available in the Snowflake using the Show warehouse SQL command as follows.

show warehouses;

+------------+-----------+----------+---------+---------+--------+------------+------------+--------------+-------------+-----------+--------------+-----------+-------+-------------------------------+-------------------------------+-------------------------------+----------+---------+------------------+---------+----------+--------+-----------+---------+
| name       | state     | type     | size    | running | queued | is_default | is_current | auto_suspend | auto_resume | available | provisioning | quiescing | other | created_on                    | resumed_on                    | updated_on                    | owner    | comment | resource_monitor | actives | pendings | failed | suspended | uuid    |
|------------+-----------+----------+---------+---------+--------+------------+------------+--------------+-------------+-----------+--------------+-----------+-------+-------------------------------+-------------------------------+-------------------------------+----------+---------+------------------+---------+----------+--------+-----------+---------|
| COMPUTE_WH | SUSPENDED | STANDARD | X-Small |       0 |      0 | Y          | Y          |          600 | true        |           |              |           |       | 2022-02-02 09:04:02.558 -0800 | 2022-02-02 09:32:37.738 -0800 | 2022-02-02 09:32:37.738 -0800 | SYSADMIN |         | null             |       0 |        0 |      0 |         1 | 8494340 |
+------------+-----------+----------+---------+---------+--------+------------+------------+--------------+-------------+-----------+--------------+-----------+-------+-------------------------------+-------------------------------+-------------------------------+----------+---------+------------------+---------+----------+--------+-----------+---------+

How to show Schemas in Snowflake with an example?

You can get the list of the schemas available in the Snowflake using the Show schemas SQL command as follows.

show schemas;

+-------------------------------+----------------------+------------+------------+-----------------------+--------------+-----------------------------------------------------------+---------+----------------+
| created_on                    | name                 | is_default | is_current | database_name         | owner        | comment                                                   | options | retention_time |
|-------------------------------+----------------------+------------+------------+-----------------------+--------------+-----------------------------------------------------------+---------+----------------|
| 2022-02-02 13:42:12.125 -0800 | INFORMATION_SCHEMA   | N          | N          | DEMODB                |              | Views describing the contents of schemas in this database |         | 1              |
| 2022-02-02 09:28:04.783 -0800 | PUBLIC               | N          | N          | DEMODB                | ACCOUNTADMIN |                                                           |         | 1              |
| 2019-08-19 09:52:23.651 -0700 | ACCOUNT_USAGE        | N          | N          | SNOWFLAKE             |              |                                                           |         | 1              |
| 2021-05-27 12:19:11.199 -0700 | DATA_SHARING_USAGE   | N          | N          | SNOWFLAKE             |              |                                                           |         | 1              |
| 2022-02-02 13:42:12.147 -0800 | INFORMATION_SCHEMA   | N          | N          | SNOWFLAKE             |              | Views describing the contents of schemas in this database |         | 1              |
| 2019-12-09 00:16:20.295 -0800 | ORGANIZATION_USAGE   | N          | N          | SNOWFLAKE             |              |                                                           |         | 1              |
| 2019-08-19 09:52:24.389 -0700 | READER_ACCOUNT_USAGE | N          | N          | SNOWFLAKE             |              |                                                           |         | 1              |
| 2022-02-02 13:42:12.174 -0800 | INFORMATION_SCHEMA   | N          | N          | SNOWFLAKE_SAMPLE_DATA |              | Views describing the contents of schemas in this database |         | 1              |
| 2021-11-11 02:09:59.036 -0800 | TPCDS_SF100TCL       | N          | N          | SNOWFLAKE_SAMPLE_DATA |              |                                                           |         | 1              |
| 2021-11-11 02:09:59.035 -0800 | TPCDS_SF10TCL        | N          | N          | SNOWFLAKE_SAMPLE_DATA |              | 10 TB TPCDS Clustered                                     |         | 1              |
| 2021-11-11 02:09:59.035 -0800 | TPCH_SF1             | N          | N          | SNOWFLAKE_SAMPLE_DATA |              | TPC-H scaling factor 1                                    |         | 1              |
| 2021-11-11 02:09:59.035 -0800 | TPCH_SF10            | N          | N          | SNOWFLAKE_SAMPLE_DATA |              | TPC-H scaling factor 10                                   |         | 1              |
| 2021-11-11 02:09:59.170 -0800 | TPCH_SF100           | N          | N          | SNOWFLAKE_SAMPLE_DATA |              | TPC-H scaling factor 100                                  |         | 1              |
| 2021-11-11 02:09:59.034 -0800 | TPCH_SF1000          | N          | N          | SNOWFLAKE_SAMPLE_DATA |              | TPC-H scaling factor 1000                                 |         | 1              |
| 2021-11-11 02:09:59.151 -0800 | WEATHER              | N          | N          | SNOWFLAKE_SAMPLE_DATA |              | Weather forecast data                                     |         | 1              |
+-------------------------------+----------------------+------------+------------+-----------------------+--------------+-----------------------------------------------------------+---------+----------------+

Final Thoughts

In this article, we have learned about SHOW() function and uses with the examples explained clearly. I have also covered different scenarios with practical examples that could be possible. I hope the information that was provided is helped in gaining the knowledge.

Please share your comments and suggestions in the comment section below and I will try to answer all your queries as time permits.

Leave a Comment