SQL editor options for Query with SQL

Use an SQL editor to write SQL and create a Query with SQL data source, based on a connected database. The SQL editor is accessed from the Query with SQL connection option when you create a new document.

Only the SELECT statement is authorized in the SQL editor to acquire data from database tables. Use these SQL editor options to select tables for the data source:

Table 1: SQL editor options

Option

Description

Catalog

The accounts available to the connected database. Expand each node to see the tables available. Double-click a table to add the table to the SQL query.

Query

The SELECT query to fetch tables. (Only SELECT is supported.) You can add table names by double-clicking the table in the account node in the left pane.

SQL History

Keep a log of the SELECT statements used in the query pane. Choose a statement to include it in the query.

Preview data

Select this option to preview the tables that are acquired by SELECT.

Select All/None

Choose all or no columns, or choose individual columns for acquisition.