Frequently when using ADS, I am writing quick queries that are very similar to those that I have run in the past.
Is there anything in the tool to make this easier? For example, being able to select a pre-written code snippet or use a macro to help construct the code?
Any suggestions other than keeping my own list of queries in a handy file?
Thomas Conrad over 3 years ago
Two options that you can try is History and Abbreviations. History lets you look back at past queries and re-display them in the query analyzer window. like
Abbreviations are like a macro in that you can set up a snippet of code which is displayed in the query analyzer window using a key or word selection like
In this abbreviation I set up a select statement that is called when I type an S and space bar in the query analyzer window.
You can visit our documentation for both here and here.
Please give that a try.
Thanks Tom – great answer. The Abbreviations feature is just what I was looking for.