Export Query Info

Avatar
  • updated
  • Under review

Hi,
Someone know a way to export the info available through the Query Info tab? Cut-and-paste is inactive and I did not found any possibility to save it in a file.
Thank you in advance
Best regards
Franco Genolini

Avatar
Germo Görtz

Here is the link to the public community project where I explain a little bit what I want to do:

https://dev.azure.com/AnalyticsCreator/AnalyticsCreator/_workitems/edit/28 

Avatar
Germo Görtz

this query info is exactly what I finally need and for what I would like to this software:

Input: SQL Text

Output: all this metadata from the "Query Info" (and a little bit more)

My goal is to transform valid TSQL for views into metadata used by https://www.analyticscreator.com/ in it's repository, where views can be defined in a formalized way. And the "query info" contains most of the required metadata (additionally I would need metadata from the WHERE condition, JOINS, distinct, ...)

Alternatively I would need to parse formatted SQL. But when all this metadata is already there it would be much easier to use existing software than to try to parse it again.