Snowflake

snowflake

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 (15)

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.

Cancel Statement ExecutionSNOWFLAKE_CANCEL_STATEMENT_EXECUTIONAcción

Cancels the execution of a running sql statement. use this action to stop a long-running query.

Parámetros de entrada

request_idstring
Unique ID (a UUID) of the API request. This is an optional parameter that can be used to track the request.
statementHandlestringObligatorio
The handle of the statement to be cancelled. This can be obtained from the response of the execute_statement action.

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

Execute SQLSNOWFLAKE_EXECUTE_SQLAcción

Tool to execute a sql statement and return the resulting data. use when you need to query data from snowflake.

Parámetros de entrada

rolestring
The role to be used for the query.
timeoutinteger
The timeout for the query in seconds.
bindingsobject
A dictionary of bindings to be used in the SQL statement.
databasestring
The database to be used for the query.
statementstringObligatorio
The SQL statement to be executed.
warehousestring
The warehouse to be used for the query.
parametersobject
A dictionary of parameters to be used in the SQL statement.
schema_namestring
The schema to be used for the query.

Parámetros de salida

dataarray[]Obligatorio
The result set of the executed SQL statement.
errorstring
Error if any occurred during the execution of the action
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Fetch Catalog IntegrationSNOWFLAKE_FETCH_CATALOG_INTEGRATIONAcción

Fetches details of a specific catalog integration.

Parámetros de entrada

namestringObligatorio
The name of the catalog integration to fetch.

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

Get Active Scheduled MaintenancesSNOWFLAKE_GET_ACTIVE_SCHEDULED_MAINTENANCESAcción

Retrieves a list of any active scheduled maintenances currently in the in progress or verifying state.

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

Get All Scheduled MaintenancesSNOWFLAKE_GET_ALL_SCHEDULED_MAINTENANCESAcción

Retrieves a list of the 50 most recent scheduled maintenances, including those in the completed state.

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

Get Component StatusSNOWFLAKE_GET_COMPONENT_STATUSAcción

Retrieves the status of individual components, each listed with its current status.

Parámetros de entrada

limitinteger
Limit number of components returned.

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

Get Status RollupSNOWFLAKE_GET_STATUS_ROLLUPAcción

Retrieves the status rollup for the entire page, including indicators and human-readable descriptions of the blended component status.

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

Get Status SummarySNOWFLAKE_GET_STATUS_SUMMARYAcción

Retrieves a summary of the status page, including status indicators, component statuses, unresolved incidents, and upcoming or in-progress scheduled maintenances.

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

Get Unresolved IncidentsSNOWFLAKE_GET_UNRESOLVED_INCIDENTSAcción

Retrieves a list of any unresolved incidents currently in the investigating, identified, or monitoring state.

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

Get Upcoming Scheduled MaintenancesSNOWFLAKE_GET_UPCOMING_SCHEDULED_MAINTENANCESAcción

Retrieves a list of any upcoming scheduled maintenances still in the scheduled state.

Parámetros de entrada

test_idstring
Test id for variation

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 DatabasesSNOWFLAKE_SHOW_DATABASESAcción

Lists all databases for which you have access privileges. shows database metadata including name, creation date, owner, retention time, and more. can filter results and include dropped databases within time travel retention period.

Parámetros de entrada

rolestring
Role to use when executing the statement.
limitinteger
Maximum number of rows to return. Cannot exceed 10000.
terseboolean
If true, returns only a subset of output columns (created_on, name, kind, database_name, schema_name).
historyboolean
If true, includes dropped databases that are still within Time Travel retention period.
timeoutinteger
Timeout in seconds for statement execution.
from_namestring
Used with LIMIT for pagination. Returns results starting from databases whose names match this string.
warehousestring
Warehouse to use for the query (though SHOW DATABASES doesn't require a running warehouse).
starts_withstring
Filters results by databases whose names start with this string. Case-sensitive.
like_patternstring
Filters results by database name using SQL wildcard pattern (% and _). Case-insensitive.

Parámetros de salida

dataarray[]Obligatorio
List of databases with their metadata. Each row contains database information like name, creation date, owner, etc.
errorstring
Error if any occurred during the execution of the action
columnsstring[]
Column names in the result set.
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Show SchemasSNOWFLAKE_SHOW_SCHEMASAcción

Lists all schemas for which you have access privileges. shows schema metadata including name, creation date, owner, database, retention time, and more. can filter results and include dropped schemas within time travel retention period.

Parámetros de entrada

rolestring
Role to use when executing the statement.
limitinteger
Maximum number of rows to return. Cannot exceed 10000.
terseboolean
If true, returns only a subset of output columns (created_on, name, kind, database_name, schema_name).
historyboolean
If true, includes dropped schemas that are still within Time Travel retention period.
timeoutinteger
Timeout in seconds for statement execution.
databasestring
Database context for the query.
in_scopestring
Scope for the command. Options: 'ACCOUNT', 'DATABASE', or a specific database name.
from_namestring
Used with LIMIT for pagination. Returns results starting from schemas whose names match this string.
warehousestring
Warehouse to use for the query (though SHOW SCHEMAS doesn't require a running warehouse).
starts_withstring
Filters results by schemas whose names start with this string. Case-sensitive.
like_patternstring
Filters results by schema name using SQL wildcard pattern (% and _). Case-insensitive.

Parámetros de salida

dataarray[]Obligatorio
List of schemas with their metadata. Each row contains schema information like name, creation date, owner, database, etc.
errorstring
Error if any occurred during the execution of the action
columnsstring[]
Column names in the result set.
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Show TablesSNOWFLAKE_SHOW_TABLESAcción

Lists all tables for which you have access privileges. shows table metadata including name, creation date, owner, database, schema, row count, size in bytes, clustering keys, and more. can filter results and include dropped tables within time travel retention period.

Parámetros de entrada

rolestring
Role to use when executing the statement.
limitinteger
Maximum number of rows to return. Cannot exceed 10000.
terseboolean
If true, returns only a subset of output columns (created_on, name, kind, database_name, schema_name).
schemastring
Schema context for the query.
historyboolean
If true, includes dropped tables that are still within Time Travel retention period.
timeoutinteger
Timeout in seconds for statement execution.
databasestring
Database context for the query.
in_scopestring
Scope for the command. Options: 'ACCOUNT', 'DATABASE', 'SCHEMA', or specific database/schema names.
from_namestring
Used with LIMIT for pagination. Returns results starting from tables whose names match this string.
warehousestring
Warehouse to use for the query (though SHOW TABLES doesn't require a running warehouse).
starts_withstring
Filters results by tables whose names start with this string. Case-sensitive.
like_patternstring
Filters results by table name using SQL wildcard pattern (% and _). Case-insensitive.

Parámetros de salida

dataarray[]Obligatorio
List of tables with their metadata. Each row contains table information like name, creation date, owner, database, schema, row count, size, etc.
errorstring
Error if any occurred during the execution of the action
columnsstring[]
Column names in the result set.
successfulbooleanObligatorio
Whether or not the action execution was successful or not

Check Statement StatusSNOWFLAKE_SNOWFLAKE_CHECK_STATEMENT_STATUSAcción

Retrieves the status of a previously submitted sql statement. replace '{statementhandle}' with the unique identifier of the statement.

Parámetros de entrada

partitioninteger
The partition number to return. The size of each partition is determined by Snowflake.
requestIdinteger
Unique ID of the API request.
statementHandlestringObligatorio
The handle of the statement to be checked.

Parámetros de salida

codestringObligatorio
The response code.
dataarray[]
The result set data.
errorstring
Error if any occurred during the execution of the action
messagestringObligatorio
The response message.
successfulbooleanObligatorio
Whether or not the action execution was successful or not
statementHandlestringObligatorio
Unique identifier for the statement being executed.
statementStatusUrlstringObligatorio
URL to get the statement status and result set.

Submit SQL StatementSNOWFLAKE_SUBMIT_SQL_STATEMENTAcción

Submits a sql statement for execution.

Parámetros de entrada

rolestring
Role to use when executing the statement. The value in this field is case-sensitive. If you omit this field, the SQL API uses the value of the DEFAULT_ROLE property of the user.
schemastring
Schema in which the statement should be executed. The value in this field is case-sensitive. If you omit this field, the SQL API uses the schema from the value of the DEFAULT_NAMESPACE property of the user.
timeoutinteger
Timeout in seconds for statement execution. If the execution of a statement takes longer than the specified timeout, the execution is automatically canceled. To set the timeout to the maximum value (604800 seconds), set timeout to 0. If this field is not set, the timeout specified by the STATEMENT_TIMEOUT_IN_SECONDS parameter is used.
bindingsobject
Values of bind variables in the SQL statement. When executing the statement, Snowflake replaces placeholders ( ? and :name) in the statement with these specified values.
databasestring
Database in which the statement should be executed. The value in this field is case-sensitive. If you omit this field, the SQL API uses the database from the value of the DEFAULT_NAMESPACE property of the user.
statementstringObligatorio
The SQL statement to execute.
warehousestring
Warehouse to use when executing the statement. The value in this field is case-sensitive. If you omit this field, the SQL API uses the value of the DEFAULT_WAREHOUSE property of the user.
parametersobject
Session parameters that you want to set for this request.

Parámetros de salida

codestringObligatorio
The response code.
dataarray[]
The result set data.
errorstring
Error if any occurred during the execution of the action
statsobject
An object that contains statistics about the number of rows affected by the DML operation.
messagestringObligatorio
A message describing the result of the operation.
sqlStatestringObligatorio
The SQL state.
createdOnintegerObligatorio
Timestamp that specifies when the statement execution started.
successfulbooleanObligatorio
Whether or not the action execution was successful or not
statementHandlestringObligatorio
A unique identifier for the statement being executed.
statementHandlesstring[]
An array of unique identifiers for the statements being executed for this request.
resultSetMetaDataobject
An object that contains metadata about the result set returned.
statementStatusUrlstringObligatorio
The URL to get the statement status and result set.