Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 whe...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    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. 

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

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. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Thanks this was new info for me... However when I did that I am not able to see the full SQL query. It cuts off with just "..." at the end. FYI below.... I need to be able to read the full SQL query being run so I can hand it off to developers to generate VIEW tables in SQL for us...