Skip to main content Skip to complementary content

Query

Query enables direct custom selection and retrieval of Qlik Catalog tables through query language. The results display in standard grid format.

Query results are limited to 1000 rows. These results can be exported as comma separated values (CSV) or Excel spreadsheet (XLS) formats, the query re-executes upon export.

Select Query from top right corner of any discover screen.

Select Query

Below illustrates a Select statement to retrieve two fields (created_ttz, sname) from an entity (pd_field) in a source (podium_core_011218).

Create a query

Write a custom query and select Run Query, Data Output displays in lower half of screen

Query profile values

A distribution table with detailed field profiling metrics is created for each entity (regardless of profile data method setting in core_env).

Run a simple query with the following syntax to display profile metrics:

select * from <sourcename>.<tablename>_profile;
Select query for field profile metrics

Select query for field profile metrics

Export the results as comma separated values (CSV) or Excel spreadsheet (XLS) formats by selecting the option and downloading the file.

Export query results

Export query results and the XLS or CSV is downloaded to local machine

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!