Skip to main content

Execute SQL

Executes a SQL command directly on a database data source.

Syntax​

execute sql script on data source <data source reference>
  [with limit <limit>]
  with sql """<sql>"""

Parameters​

sql​

String — SQL command or commands to execute on the database.

data source reference​

String — The name of the data source to execute the command on.

limit​

Integer — The maximum number of rows to show, if the result of the command is a tabular result set. Default: 1000.