query_table
Execute SQL SELECT queries to retrieve data from Snowflake databases using fully qualified table names, including database, schema, and table details for accurate results.
Instructions
Executes an SQL SELECT query to get the data from the underlying snowflake database.
* When constructing the SQL SELECT query make sure to use the fully qualified table names
that include the database name, schema name and the table name.
* The fully qualified table name can be found in the table information, use a tool to get the information
about tables. The fully qualified table name can be found in the response for that tool.
* Snowflake is case-sensitive so always wrap the column names in double quotes.
Examples:
* SQL queries must include the fully qualified table names including the database name, e.g.:
SELECT * FROM "db_name"."db_schema_name"."table_name";
Input Schema
Name | Required | Description | Default |
---|---|---|---|
sql_query | Yes | SQL SELECT query to run. |
Input Schema (JSON Schema)
{
"properties": {
"sql_query": {
"description": "SQL SELECT query to run.",
"title": "Sql Query",
"type": "string"
}
},
"required": [
"sql_query"
],
"title": "query_tableArguments",
"type": "object"
}