NAiOS IconNAiOS Logo
Contacto
Volver al catálogo

Snowflake Basic

snowflake_basic

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

DatabasesAnalyticsWeb del proveedor
Acciones
6
Triggers
0
Autenticación
—
OAuth gestionado
No
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