Skip to main content

Configuration

For all operations, you need to configure the following.

Operation​

The following operations are supported:

  • SELECT - Performs a SQL Select operation. docs
  • INSERT - Performs a SQL Insert operation. docs
  • UPDATE - Performs a SQL Update operation. docs
  • UPSERT - Performs a SQL Upsert operation. docs
  • DELETE - Performs a SQL Delete operation. docs
  • RAW - Executes a raw SQL query. docs
  • EDGE - Executes the SQL found on the incoming edge. This is often used when receiving data from the AI Prompt Block. docs

Other Settings​

  • Connection - a centrally defined Connection.
  • Schema
  • Table
  • Database - this is only required for certain platforms (currently Snowflake). For others, the database to connect to is specified within the Connection itself.
  • Fields - to be used in the SELECT [fields selected] FROM clause
  • Where - for SELECT operations
  • Order - for SELECT operations
Config

When you modify the Connection, Schema and Table, the fields that depend on the modified field will be reloaded.

You should be aware that some database servers, such as Azure SQL Server, can sleep, so you may need to wake for the server to come online.

sql, select, insert, update, upsert, delete, edge, raw
Handles all SQL read, write, update, upsert and raw query operations