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

by Feb 13, 2020

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!

Response

Thomas Conrad over 3 years ago
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

RedShadow over 3 years ago in reply to Thomas Conrad

Thanks Tom – great answer. The Abbreviations feature is just what I was looking for.