Triggers
The trigger runs its query on a schedule you choose and starts one flow per new row. A row is new when its Cursor column value is above the last one seen. When you turn the trigger on, it records the highest value already in the results, so rows that existed before never start a flow. It works with a Database connection.Nodes
Snowflake SQL Query, BigQuery SQL Query, Redshift SQL Query, Databricks SQL Query and Oracle SQL Query work the same way as SQL Query, with the same fields and outputs. Each one uses its own connection.
Troubleshooting
This query was not run because Allow Write Operations is off
This query was not run because Allow Write Operations is off
The query changes data or schema, or Noxus could not read it as a read-only query. Turn on Allow Write Operations if the change is intended, including for queries that create temporary tables.
The query returned more than ... rows, so only the first ... were kept
The query returned more than ... rows, so only the first ... were kept
Raise Max rows, or set it to 0 for no limit.
Failed to execute ... SQL query: ...
Failed to execute ... SQL query: ...
The database rejected the query. The rest of the message is the database’s reason.
Column type ... is not supported in General mode
Column type ... is not supported in General mode
Switch to Advanced for arrays, defaults, custom types or other column options.
Advanced mode requires supported DDL syntax
Advanced mode requires supported DDL syntax
Advanced mode runs only CREATE, ALTER, DROP, TRUNCATE and COMMENT. For anything else, use SQL Query with Allow Write Operations on.
The schema change failed: ...
The schema change failed: ...
The database refused the change. The rest of the message is its reason.
The query must be a single SELECT, or The query must only read data
The query must be a single SELECT, or The query must only read data
Database Row Added accepts one SELECT and nothing that writes. Remove any other statement.
On Microsoft SQL Server the query can't start with WITH
On Microsoft SQL Server the query can't start with WITH
Write the CTE as a subquery in the trigger’s Query.
On Microsoft SQL Server, use a number or text column as the cursor
On Microsoft SQL Server, use a number or text column as the cursor
SQL Server timestamps are more precise than the trigger can store. Use a number or text column, such as an id, as the Cursor column.
The query returned no ... column
The query returned no ... column
The Cursor column must be one of the columns the Query returns.
The query took longer than 30 seconds
The query took longer than 30 seconds
Make the trigger’s Query faster, or have it return fewer rows.
Connection timed out
Connection timed out
Noxus could not reach the database when you saved the connection. Check Host and Port, and that the database accepts connections from Noxus.