| Table of Contents |
|---|
...
SQL worksheets give you the ability to write SQL queries directly in a workbook. Use SQL worksheets to combine processes that might take several steps using the traditional interface.
Using SQL Worksheets
Open a SQL worksheet
Open a workbook, select Sheets from the menu bar and select Add SQL Sheet.
A new worksheet is added to your workbook with a multiline SQL editor instead of a formula editor.
...
The run, edit, and delete privileges for the SQL worksheet are as they are assigned for the workbook.
Commentary Function
You can comment in the SQL Editor:
- for commenting a single line:
- for commenting multiline:
Limitations
- Create Table, Delete Table, and Modify Table structure / DDL aren't currently supported.
- Window functions aren't currently supported.
- Using Hive UDFs /UDAs in the SQL editor isn't currently supported.
- Using all the Datameer functions in the SQL editor isn't currently supported.
- Datameer's LIST data type isn't supported for SQL worksheets.
...