Once you have created a Presto connection, you can select data and load it into a Qlik Sense app or a QlikView document. In Qlik Sense, you load data through the Add data dialog or the Data load editor. In QlikView, you load data through the Edit Script dialog.
Qlik Sense: Presto data selection properties
| Properties | Description |
|---|---|
| Database | Lists the databases configured for Presto. If a database was specified in the Catalog (Project) property of the connection dialog, it will be selected automatically when you open the selection dialog. You can select additional databases when you build the data selection script. After selecting tables and fields from one database, select another database and owner, and the tables and fields you select from that database will be added to the data selection script. |
| Owner | Lists the owners of data sets in the selected database. |
| Tables |
Lists the tables associated with the selected owner. Selecting a table will cause the table fields to be displayed in the Data preview tab. |
| Filter tables | Displays a field where you can enter filter criteria to search for specific tables. |
| Data preview |
Displays a preview of the fields and data of the selected table. You can select which data columns to include by checking the box beside the field name. You can also change the field name by clicking on the existing field name. The new name is then used as an alias for the name the field has in the database. |
| Metadata | Displays a table of the fields and whether they are primary keys. |
| Fields |
Lists the fields in each selected table. If the table name check box is selected, all the fields in the table are automatically selected. If you click only the table name, fields are displayed but not selected. They can then be selected individually. You can also change the field name by clicking on the existing field name. The new name is then used as an alias for the name the field has in the database. |
| Filter data |
Displays a field in which you can enter filter criteria to select a subset of data in the fields you are loading. The Filter data property displays after tables have been selected. |
| Filter fields | Displays a field where you can filter on field names |
| Hide script/Preview script | Shows or hides the load script that is automatically generated when table and field selections are made. |
| Include LOAD statement |
Adds a LOAD statement before the SELECT statement. |
| Add data |
Opens the Associations view of the Data manager. This option is available only when you use Add data. Allows you add more data sources, fix any errors in your data, and create table associations. This option is available only when you use Add data. |
| Insert script | Inserts the script displayed in the Data preview panel into the script editor. This option is available only when you use the Data load editor. |
QlikView: Presto data selection properties
| Properties | Description |
|---|---|
| Database | Lists the databases configured for Presto. If a database was specified in the Catalog (Project) property of the connection dialog, it will be selected automatically when you open the selection dialog. You can select additional databases when you build the data selection query. |
| Owner | Lists the owners of data sets in the selected database. |
| Objects |
Lists the tables associated with the selected owner. Selecting a table will cause the table fields to be displayed in the Data preview tab. |
| Fields | Lists the fields in each selected object. |
| Script | Displays the load script built from the selected objects and fields. |
| Preview |
Displays a preview of the fields and data of the selected table. Use the Maximum rows drop-down menu to limit the number of lines included in the preview. |
| Preceding load |
Adds a LOAD statement before the SELECT statement. |
| OK | Inserts the script displayed in the Script panel into the script editor. |