TeamSQL strives to make working with your data as easy as possible, and if you are connecting to your Redshift database engine, TeamSQL has many snippets you'll find useful. Snippets are pre-written pieces of code that you can easily insert into your query.
If you have existing data in AWS DynamoDB, S3, or EMR, TeamSQL provides you with snippets to easily move to and work with your data in Redshift, including Copy, Unload, and Vacuum.
Not using Redshift? No worries. Users of Oracle, Microsoft SQL Server, PostgreSQL, MySQL, and Redis also have snippets available for use, including those for the CRUD (create, read, update, and delete) commands.Postgre Snippet List Microsoft SQL Server Snippet List
Not finding the snippet you need? Have a piece of code that you use often? Create your own snippet!
Rather than limiting you to snippets that come default with TeamSQL, you can create your own snippets for repeated use. TeamSQL will also track which database engine you're working against when you create your snippet, so you will only get the snippets that are appropriate for whatever it is you're working on at that moment - no need to worry about populating a PostgreSQL query with a T-SQL snippet!