Run Options

Alation Cloud Service Applies to Alation Cloud Service instances of Alation

Customer Managed Applies to customer-managed instances of Alation

When working on a query in Compose, you have several options for running your query:

  • Run all statements in the query at once

  • Run the selected text

  • Run the query as a script

Run All Statements at Once

Clicking the Run button in the query editor will submit each statement, one at a time, to the database. You can also click the arrow in the Run button and select Run Full Query from the dropdown menu.

Run Selected Text

Highlighting a section of your query and clicking Run allows you to execute a select part of your code. In other words, highlighting will limit the query run to the selected section. If a section is highlighted, a Run Selected Text option will appear in the Run dropdown menu.

Run as Script

Running a query as a script can only be done on SQL Server. It submits all the text as one script and should be used for SQL variables, volatile tables and User-defined Functions (UDFs).

To run a query as a script, click the arrow in the Run button and select Run Full Query as Script from the dropdown menu.