Perform quick SQL query on SQL dataset from UI

Antal

For my workflow it would be very helpful to have the option to perform a quick SQL query on a (SQL) dataset in the Flow from the UI. For example by right clicking.

Things like count distinct values of a specific column, etc.

Right now, I go to my separate SQL client to perform these quick checks, but that requires tool switching and copying over of table names etc.

Turribeach

There are many ways to do this in Dataiku but here are two:

1. Notebooks ⇒ New Notebook ⇒ Write your own ⇒ SQL ⇒ SQL Notebook:
   
2. Column ⇒ Analyse ⇒ Whole Data:
   
3. 

Han_Han

https://community.dataiku.com/discussion/44982/perform-quick-sql-query-on-sql-dataset-from-ui

Hi @Antal,

What separate SQL client are you using at the moment?

Apart from count distinct values of a specific column, what other things do you want to know about the dataset?

Would be super interested to know the specifics of your current setup and workflow! Happy to jump into a call as well. My email is: han.han@dataiku.com

Han