NagentArtefacts
Dev & Technology
Enterprise and White Glove
Company
Snowflake Basic connects to a Nagent workspace. Once it is connected, agents can call 6 Snowflake Basic actions, such as "Describe table", "Explore Columns" and "Run Query". Nothing is enabled on connect: each action is allowed one at a time, and an action with side effects runs or waits for a person according to the agent's level.
Every operation an agent can call against Snowflake Basic, with input parameters and output schema.
SNOWFLAKE_BASIC_DESCRIBE_TABLERetrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table.
Input parameters
The name of the Snowflake database containing the table.
The name of the table to describe.
The name of the schema within the database that contains the table.
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
SNOWFLAKE_BASIC_EXPLORE_COLUMNSRetrieves a sample of distinct values for specified columns from a Snowflake table.
Input parameters
The maximum number of distinct values to return for each specified column.
The name of the Snowflake database.
The name of the table within the specified schema.
The name of the schema within the specified database.
A list of specific column names to explore. If left empty, all columns in the table will be explored.
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
SNOWFLAKE_BASIC_RUN_QUERYExecutes the given SQL query in Snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.
Input parameters
SQL query to execute; runs within the context of the specified database and schema.
Name of the Snowflake database.
Name of the schema within the specified database.
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
SNOWFLAKE_BASIC_SHOW_DATABASESRetrieves a list of all databases available in the Snowflake account.
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
SNOWFLAKE_BASIC_SHOW_SCHEMASRetrieves a list of all schemas within a specified Snowflake database.
Input parameters
The name of the database for which to list schemas.
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
SNOWFLAKE_BASIC_SHOW_TABLESRetrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a Snowflake database.
Input parameters
The name of the database containing the schema from which to list tables.
The name of the schema within the specified database for which to list tables.
Output
Data from the action execution
Error if any occurred during the execution of the action
Whether or not the action execution was successful or not
Agents can call 6 Snowflake Basic actions on Nagent, including "Describe table", "Explore Columns" and "Run Query". Describe table: Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified Snowflake table. Each action is listed on this page with its input parameters and its output.
Describe table takes 3 required inputs: database, table_name and schema_name. It returns data, error and successful.