Are there any tools in Aqua Data Studio to store code snippets for re-use?

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?

Thanks!

Parents
No Data
Reply
  • Hello,

    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

Children