Forum Discussion
How do I view native query with Impala connection?
I am connecting into our Impala Server am pulling in one table. The only step I added was "remove other columns". Why am I not able to see the SQL code behind the scene here? This does not happen when I run the same steps on say MS SQL Server, but with Impala it's grayed out. What are the next steps I need to take to get this native query working with Impala connection? I love using Power Query and viewing the SQL code behind it.
Two questions for you all:
- How do I get this "View Native Query" to work so that I can see the SQL code when connected to Impala...?
- If I am not able to view the SQL code behind Impala because it only works with MS SQL, is there another Power Query like tool out there on the market that allows for non-programmers to develop SQL code (I.e. GUI of some sort...)? Goal is to develop SQL queries without coding....
Thanks!!
In Power BI Desktop when you invoke PQ - Go to Tools - Start Diagnostics - Refresh preview your query - Stop Diagnostics - Now, few logs will be generated which are simple to read. One of the column name is Data Source Query. That column will show you if SQL statement is being executed. If SQL statement is not executed, then the statement will not be shown against that step.
4 Replies
Right click on that cell - Drill down and now you will have complete display of that cell which you can copy.
In Power BI Desktop when you invoke PQ - Go to Tools - Start Diagnostics - Refresh preview your query - Stop Diagnostics - Now, few logs will be generated which are simple to read. One of the column name is Data Source Query. That column will show you if SQL statement is being executed. If SQL statement is not executed, then the statement will not be shown against that step.