Snowflake Basic

snowflake_basic

Snowflake is a cloud-based data warehouse offering elastic scaling, secure data sharing, and SQL analytics across multiple cloud environments

Databases Analytics Web del proveedor

Acciones

Triggers

Autenticación

—

OAuth gestionado

Información técnica: el detalle de parámetros, schemas y triggers de esta página está pensado para equipos de integración. Si solo necesitas saber si tu herramienta favorita está disponible, basta con ver la lista de acciones.

Acciones disponibles (6)

Cada acción es una operación que el agente puede ejecutar contra este conector. Haz clic en una acción para ver sus parámetros.

Describe tableSNOWFLAKE_BASIC_DESCRIBE_TABLEAcción

Retrieves detailed information for each column (including name, data type, kind, nullability, default value, and key status) in a specified snowflake table.

Parámetros de entrada

databasestringObligatorio
The name of the Snowflake database containing the table.
table_namestringObligatorio
The name of the table to describe.
schema_namestringObligatorio
The name of the schema within the database that contains the table.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Explore ColumnsSNOWFLAKE_BASIC_EXPLORE_COLUMNSAcción

Retrieves a sample of distinct values for specified columns from a snowflake table.

Parámetros de entrada

limitinteger
The maximum number of distinct values to return for each specified column.
databasestringObligatorio
The name of the Snowflake database.
table_namestringObligatorio
The name of the table within the specified schema.
schema_namestringObligatorio
The name of the schema within the specified database.
column_namesstring[]
A list of specific column names to explore. If left empty, all columns in the table will be explored.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Run QuerySNOWFLAKE_BASIC_RUN_QUERYAcción

Executes the given sql query in snowflake within the specified database and schema (which must exist and be accessible), automatically setting context first.

Parámetros de entrada

querystringObligatorio
SQL query to execute; runs within the context of the specified database and schema.
databasestringObligatorio
Name of the Snowflake database.
schema_namestringObligatorio
Name of the schema within the specified database.

Parámetros de salida

dataobject[]
A list of dictionaries, where each dictionary represents a row returned by the query. Keys in the dictionaries are column names. For SELECT statements, this contains the query results. For DML/DDL statements or queries that do not return a rowset, this will typically be an empty list.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Show databasesSNOWFLAKE_BASIC_SHOW_DATABASESAcción

Retrieves a list of all databases available in the snowflake account.

Parámetros de entrada

Sin parámetros.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Show schemasSNOWFLAKE_BASIC_SHOW_SCHEMASAcción

Retrieves a list of all schemas within a specified snowflake database.

Parámetros de entrada

databasestringObligatorio
The name of the database for which to list schemas.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Show TablesSNOWFLAKE_BASIC_SHOW_TABLESAcción

Retrieves a list of tables, including their row counts and sizes in bytes, from a specified schema within a snowflake database.

Parámetros de entrada

databasestringObligatorio
The name of the database containing the schema from which to list tables.
schema_namestringObligatorio
The name of the schema within the specified database for which to list tables.

Parámetros de salida

dataobjectObligatorio
Data from the action execution
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not