Select and load data from a Snowflake database
Once you have created a connection to an Snowflake database, you can select data and load it into a Qlik Sense app. In Qlik Sense, you load data through the Add data dialog or the Data load editor.
Qlik Sense: Snowflake database properties
Properties | Description |
---|---|
Role |
Shows the different roles assigned to the user. Use this dropdown to change the default role that was used when the connection was created. Qlik Cloud Government noteThe option to select a role other than the default is not available in Qlik Cloud Government.
|
Database | Shows the available databases. |
Schema | Shows the available schema in the selected database. |
Tables |
Shows the tables associated with the selected schema. Selecting a table will cause the table fields to be displayed in the Data preview tab. |
Preview |
Shows a preview of the fields and data of the selected table. |
Metadata | Shows a table of the fields and whether they are primary keys. Primary-key fields are also labeled with a key icon beside the field name. |
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 |
Shows a field where you can enter filter criteria. |
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. 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. |