Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Data Manager - custom SELECT as an option for database connections

kuba_michalik1
Contributor III
Contributor III

Data Manager - custom SELECT as an option for database connections

Data Manager, instead of having only the option to choose existing tables and views and specifying filters, should also allow to just simply paste a single custom SQL SELECT query and treat the results as a table afterwards.

We have several cases where business users have a "magic" SQL query received from source system owner, and would like to just paste it and use as a source table. The query is so complicated that trying to recreate the result in Qlik by clicking in Data Manager is a fool's errand for someone who would just like to load the data and quickly do some analysis. Sure, you can go to the script editor and add your custom queries there, but script editor is scary (data manager exists for a reason).

3 Comments
Patric_Nordstrom
Employee
Employee

Thank you all for your feedback on ways to improve our product. While this is something we understand would be useful, it's not on the short-term roadmap. Please continue to show your support for this idea by commenting and liking.

Thanks, 

Patric

Status changed to: Open - Collecting Feedback
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Newbie
Newbie
 
Status changed to: Closed - Archived