Lists all tables for which you have access privileges. Shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. Can filter results and include dropped tables within Time Travel retention period.
rolestringRole to use when executing the statement.
limitintegerMaximum number of rows to return. Cannot exceed 10000.
tersebooleanIf true, returns only a subset of output columns (created_on, name, kind, database_name, schema_name).
schemastringSchema context for the query.
historybooleanIf true, includes dropped tables that are still within Time Travel retention period.
timeoutintegerTimeout in seconds for statement execution.
databasestringDatabase context for the query.
in_scopestringScope for the command. Options: 'ACCOUNT', 'DATABASE', 'SCHEMA', or specific database/schema names.
from_namestringUsed with LIMIT for pagination. Returns results starting from tables whose names match this string.
warehousestringWarehouse to use for the query (though SHOW TABLES doesn't require a running warehouse).
starts_withstringFilters results by tables whose names start with this string. Case-sensitive.
like_patternstringFilters results by table name using SQL wildcard pattern (% and _). Case-insensitive.
dataRequiredData from the action execution
errorstringError if any occurred during the execution of the action
successfulRequiredbooleanWhether or not the action execution was successful or not
API key connection. Risk level 2 of 5.
Free Action
No published Skills explicitly reference this Action yet.