Skip to main content
Accessing cloud databases directly with Direct Query

ON THIS PAGE

Accessing cloud databases directly with Direct Query

Use Direct Query to read SQL databases without having to import or load the data in memory.

Qlik Sense Enterprise SaaS Government noteQlik Sense Enterprise SaaS - Government (US) users cannot use Direct Query.

Direct Query gives the user more options on how they want to access their data in order to suit their individual needs. Accessing the data through Direct Query allows the user to keep the data in its underlying data source. This increases the speed at which users can interact with their data in exchange for some of the flexibility that an in-memory Qlik Cloud app offers.

In general, it is recommended that you import your data into Qlik Cloud whenever possible. In-memory Qlik Cloud apps allow you to better customize your experience and get the most out of your data. However, if you find yourself in a situation where your goals cannot be met by importing data, Direct Query might be the solution for you. Due to their streamlined functionality, Direct Query apps can also help new users take their first step towards creating fully functional and fast in-memory apps.

You might consider using Direct Query when:

  • Handling big data sources.

  • Exploring new databases and tables.

  • You are in need of near real-time data, for example to see how many orders have come in during the last hour.

  • Prototyping your dashboard in the initial phases before production.

  • Extracting slices of data into the Qlik Sense engine through ODAG apps. For more information, see Exporting Direct Query app settings to a template app.

When creating a data model in Direct Query, keep the model as simple as possible, Complex queries are more likely to cause performance issues.

For a tutorial on how to use Qlik Sense apps, see Tutorial - Beginning with the Basics.

Information noteThe Direct Query capability in Qlik Cloud is different from the Direct Query statement in QlikView. For more information, see Direct Query.

Supported capabilities

Direct Query apps have different capabilities compared to in-memory apps.

Direct Query supports the following:

  • Data connection types:

    • Snowflake

      A subset of scalar functions in Snowflake are supported.

  • In-memory data analysis emulation:

    • A subset of set analysis.

    • Multi-table charts over arbitrary complex models. Existing model requirements for in-memory apps will still be in place. For example, association loops between tables are not allowed.

    • Basic aggregation types:

      • Sum

      • Count

      • Min

      • Max

      • Avg

      • Only

    • Pre- and post-aggregation calculations, based on function and operation set provided by the underlying database.

  • Table relationship types:

    • Inner join

    • Full outer join

  • Iterative modeling and dashboard creation

  • Visualization features:

    • Standard charts:

      • Bar chart

      • Bullet chart

      • Button

      • Combo chart

      • Container

      • Filter pane

      • Gauge

      • KPI

      • Line chart

      • Map

      • Mekko chart

      • Pie chart

      • Scatter plot

      • Table

      • Text & image

      • Waterfall chart

    • Dashboard bundle:

      • Video player

    • Visualization bundle:

      • Funnel

      • Multi KPI

      • Radar

      • Sankey Word cloud

See also