Aident Loadout के माध्यम से Snowflake Tools के साथ Snowflake Show Schemas का उपयोग करें। चलाने से पहले इनपुट, आउटपुट, सेटअप, मूल्य और जोखिम देखें।
Lists all schemas for which you have access privileges. Shows schema metadata including name, creation date, owner, database, retention time, and more. Can filter results and include dropped schemas 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).
historybooleanIf true, includes dropped schemas 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', or a specific database name.
from_namestringUsed with LIMIT for pagination. Returns results starting from schemas whose names match this string.
warehousestringWarehouse to use for the query (though SHOW SCHEMAS doesn't require a running warehouse).
starts_withstringFilters results by schemas whose names start with this string. Case-sensitive.
like_patternstringFilters results by schema name using SQL wildcard pattern (% and _). Case-insensitive.
dataआवश्यकData from the action execution
errorstringError if any occurred during the execution of the action
successfulआवश्यकbooleanWhether or not the action execution was successful or not
API कुंजी कनेक्शन। जोखिम स्तर 2/5।
मुफ़्त Action
अभी कोई प्रकाशित Skills इस Action को स्पष्ट रूप से संदर्भित नहीं करती है।