I don’t like using Aginity.

Firstly, it’s slow. It’s also ugly.

But most annoyingly, it’s prone to crashes. Don’t accidentally Ctrl + click on a table name or press the Abort query button twice; you’ll regret it.

One thing I like about it, however, is the code snippets function. It’s a killer time-saver.

To use code snippets, type in some combination of letters and hit Alt-C. Those letters then expand into a SQL statement.

By default you have

• sf (select * from <blank> limit 1000), and
• sfw (select * from <blank> where <blank> limit = 1000).

But you can add your own, which is where they really shine. Use them for things you type again and again.

For example, say you have a schema called modelling_team that you type over and over again. Just map it to mt .

Or say you keep selecting stuff from the sales table. Create an entry that turns sfs into select * from modeling_team.sales_table limit 1000.

One more useful one: say you want to find counts of some variable. Map it to sfg: select x, count(1) from <blank> group by x order by count(1) desc. Then hit Ctrl-H to replace x with your field(s) name and you’re good to go.

Code snippets are a drug. You’ll be Alt+C-ing into your veins all day. Mmm.