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:
|
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. |