Creating a Direct Query app
When you create a new Qlik Sense analytics app, you have the option of creating it with a Direct Query connection instead of loading the data in-memory.
Connecting to a database
The first step to getting started with Direct Query is to connect to a database.
Do the following:
-
Create a new Qlik Sense analytics app.
-
Select an existing data connection or add a new data connection.
Best practice is to use user defined credentials, for example with OAuth in Snowflake.
Adding data to the app from connections and new files
Information noteFor a list of supported data connection types, see Accessing cloud databases directly with Direct Query. -
Click the menu.
-
Select Go to Direct Query.
Selecting data source and tables
To perform analysis on your data, select the tables and columns to include.
Do the following:
- In the Direct Query app you just created, select an Owner.
- Select the table or tables that you want to analyze.
- Click Next.
The Data model manager then opens.
Creating relationships between tables to build data model in Data model manager
If you have included more than one table in your analysis, it is necessary to create relationships between tables and fields.
Do the following:
-
In the Data model manager, click Relationship.
-
Select the tables and fields to relate.
For more information, see Joining tables in Data manager.
Information noteYou can only select two tables at a time. To create more relationships, repeat the full procedure.Information noteCircular relationships are not supported. -
When you have created relationships between all relevant fields and tables, click Apply changes.
All relationships appear on the home screen of the Data model manager. You can sort the relationships by which table they are based by clicking the corresponding table in the list.
Adding visualizations
For instructions on how to add visualizations, see Creating visualizations.
You can use functions from the cloud database in measure expressions, but not in calculated dimensions.
Sharing Direct Query apps
Access to Direct Query apps is slightly different to in-memory apps as user access is normally controlled by the database with user defined credentials.
-
The app and the data connection must be in a shared space.
-
Users must have a Can consume data role in the shared space and access to the database.