Snowflake

Delivers warehouse tables and current query results from the Snowflake data platform as analytical data for questions and recurring reports.

Description

Many companies consolidate their analytical data in Snowflake. Cortex connects to your warehouse with a read-only role and turns tables and views into interactive knowledge. Ask about KPIs, comparisons between regions or recurring reports directly from the warehouse. Your role model remains authoritative, queries are read-only.

Capabilities

submit_statement

Submits one or more SQL statements for execution

get_statement

Returns the status and result of a submitted statement by its handle

cancel_statement

Cancels the execution of a statement by its handle

get_result

Fetches the status or the finished result of a query page by page

list_databases

Lists the accessible databases

list_schemas

Lists the accessible schemas of a database

list_tables

Lists the tables of a schema

get_table

Describes a table with its columns and properties

list_views

Lists the views of a schema

query_cortex_search_service

Queries a Cortex Search Service and returns search results

list_files

Lists the files of a stage

The dawn of a new era in retail.