Query Workspaces

Its got its ghosts

Pro: 1. Ability to query the tables directly. (I do 90% of my work in this space. Huge win) Con: 1. Hard to find any documentation on what SQL functions are registered for use. 2. Can't build and test the SQL for an insight because the SQL for insights is 'ANSI SQL' and the functions don't work in QW. 3. Does not return all fields despite selecting all fields by name in the query. Does not return KQ fields either. 4. Query tabs run off the page into a drop down, makes it hard to find them. 5. If a query times out and you haven't saved your queries the page has to be refreshed and you loose all your work. 6. The real column names that are required for the query but are given a friendly name on the results, so it makes it painful to refine the query further because you have to go lookup the actual name of the column in another new query. This also uselessly increased the tabs you have to open. I hope they make this tool better, it has a lot of promise but its still painful to use.

Facing issue

When I create new workspace , a screen pops up asking to Select Named Credential the picklist field is not accessible and can't save without value. I appreciate your help

Makes using Query API Easy for all your end users

The App is essentially the Query API with a UI. Works great for what it is intended to do.

It doesn't work well with calculated insights.

It's better than nothing but: It's impossible to copy and paste a fully calculated insight. SUM only works if it's inside the GROUP BY. COUNT only works if it's inside the GROUP BY. Does not accept IFNULL. I could not process and do calculations with date functions like DATEDIFF, DATE_SUB, and CURRENT_DATE.