Is it possible/how would you go about displaying the query text that gets displayed inside Snowflake UI "history" tab inside of visual studio terminal?
I current have a local dev env (docker) that I use to write dbt (https://www.getdbt.com/) locally with and I can execute on against snowflake. The syntax is different in dbt than pure sql & harder to debug until sql text is visible once executed. I have error messages, but would like to see the sql as well as it takes extra time to open up snowflake and look into the history and read the sql text that failed to complete.
Any ideas?
>Solution :
Assuming that you are using Visual Studio Code for development the project, you could supplement it with dbt Power User plugin
Features related generate SQL code:
- "Generate a model from your source definition"
- "Visualize the result set of your model"
- "See the compiled query of your model (Use CMD+’ (mac) or CTRL+’ (win))"