Talend & Redshift

 

Amazon Redshift is not the same as other SQL database systems. To fully realize the benefits of the Amazon Redshift architecture, you must specifically design, build, and load your tables to leverage massively parallel processing, columnar data storage, and columnar data compression. If your data loading and query execution times are longer than you expect, or longer than you want, you might be overlooking key information.

Redshift SQL Clients

  1. Agnity
  2. Aqua data studio
  3. SQL workbench

Best practices

 

Leave a Reply