What Is The LIST Command Used For In Snowflake

Justin Aug 25, 2026

The LIST command is a powerful utility in Snowflake, a cloud-based data warehousing company, designed to generate a list of the tables, databases, or other objects within your account or schema. It's an essential tool for understanding your data landscape, checking the results of your previous actions, or preparing for new operations. Let's dive into the functionalities and usage scenarios of the LIST command.

the snowflake data info sheet is shown
the snowflake data info sheet is shown

The LIST command, in its basic form, provides a straightforward list of all tables in the current database. However, it offers more than just a simple inventory. With various clauses and qualifiers, you can customise the output to suit your specific needs, making it an adaptable and efficient tool for data administrators and analysts alike.

Perficient Blogs
Perficient Blogs

Understanding the Basic Syntax

The basic syntax of the LIST command is: LIST <object_type>. Here, <object_type> can be a table, view, file format, stage, or schema, among others.

Functions in Snowflake (2025): Complete Guide for Data Transformation & Analytics
Functions in Snowflake (2025): Complete Guide for Data Transformation & Analytics

For instance, the command LIST TABLES; will return a list of all tables in the current database. Let's explore some key aspects of this fundamental command.

Listing Specific Objects

the snowflake data platform is shown in this info sheet, with information about how to use it
the snowflake data platform is shown in this info sheet, with information about how to use it

You can list specific objects using their names. For example, LIST TABLES "TABLE_NAME"; will list only the table named "TABLE_NAME".

Similarly, LIST VIEWS like '%STRING%'; will list all views containing 'STRING' in their names.

Listing Objects with Wildcards

Snowflake Best Practices for Users, Roles, and Permissions | Towards Data Science
Snowflake Best Practices for Users, Roles, and Permissions | Towards Data Science

Wildcards can be used to list multiple objects at once. The underscore (_) represents single characters, while the percent sign (%) represents any sequence of characters. For instance, LIST TABLES like 'CUST_%'; will list all tables starting with 'CUST_'.

Using wildcards allows for flexibility and speed when listing a subset of objects with a common pattern in their names.

Exploring List Clauses

a diagram showing the different types of commands in a computer language, with text below
a diagram showing the different types of commands in a computer language, with text below

The LIST command also supports several clauses, enabling you to filter and sort the results, making the output more meaningful and actionable.

Let's explore some useful clauses that can enhance your use of the LIST command.

How to Transform Your Data in Snowflake - KDnuggets
How to Transform Your Data in Snowflake - KDnuggets
the ultimate guide to every cloude command
the ultimate guide to every cloude command
a snowflake game with different types of snowflakes
a snowflake game with different types of snowflakes
Connect Alteryx To Snowflake Tool (2 Easy Ways To Pull Data)
Connect Alteryx To Snowflake Tool (2 Easy Ways To Pull Data)
15 SQL Commands Every Developer Uses Daily | SQL Cheat Sheet for Beginners & Professionals
15 SQL Commands Every Developer Uses Daily | SQL Cheat Sheet for Beginners & Professionals

WITH QUOTED IDENTIFIERS

This clause allows you to list objects using quoted identifiers, preserving case sensitivity. For example, LIST TABLES WITH QUOTED IDENTIFIERS; returns tables with their actual case-sensitive names.

In Snowflake, identifiers are usually case-insensitive. Using this clause is helpful when you want to list objects with differently cased names.

LIKE '%STRING%'

In addition to using wildcards, you can filter object names using the LIKE operator. For example, LIST TABLES LIKE '%CUSTOMER%'; will list tables containing 'CUSTOMER' in their names.

This clause is beneficial when you want to find objects based on specific words or patterns within their names.

Understanding and mastering the LIST command opens up a world of possibilities for managing and interrogating your data in Snowflake. Whether you're a seasoned data professional or just starting with the platform, the LIST command is an essential tool in your arsenal.

No matter your current skill level, continuous exploration and practice with the LIST command, and its various object types and clauses, will help you unlock more efficient and effective ways to work with your data in Snowflake. The next step? Start experimenting with the LIST command in your own Snowflake environment. Happy listing!