Skip to content

Query explanation

Query explanation is a invaluable utility to understand complex piece of dbt or SQL code (especially written by others!).

Start Query Explanation

You can get explanation for the entire query code in the file or selected parts. If you need explanation for only some part of the code, select that code first. There are three different ways in which you can trigger the query explanation functionality.

Right Click Menu

Right click, select "DataPilot" menu and choose an action to "explain" the query.

rightClick

Utilize SQL actions menu

Press "SQL actions" button from the toolbar. It will open the "SQL actions" menu drawer as shown below. Please select "Explain query" action.

sqlActions

Explain query button from query results panel

There is an explain query button in the query results panel where you can see compiled SQL. Pressing that button will start query explanation workflow.

explainButton

Get more details in DataPilot chat

Once you start the query explanation workflow in DataPilot chat panel on the left hand side, DataPilot will show more specific suggestions to get detailed explanations on specific areas. You can choose one of those suggestions or ask more questions in the input box below the suggestions as shown in the image below.

explainSuggestion

Recorded demo video

Please provide the feedback on the generated explanations using thumbs up / down buttons. Your feedback will help us tremendously to improve this functionality.

This feature requires an API key. You can get it by signing up for free at www.altimate.ai