Browse by Tags

• Amazon Redshift
• CTE
• elasticsearch
• Pivot
• SQL

• Discover how SQL Server can use Python to access any NoSQL engine

  . Many companies these days keep their data assets in multiple data stores. Many companies that I have worked at have used other database systems alongside SQL Server, such as PostgreSQL instances, Redis, Elasticsearch or Couchbase. There are situations Read More... Posted Friday, October 26, 2018 11:04 PM by Maria Zakourdaev | 0 Comments Filed under: Python, elasticsearch

• How would you do dynamic pivot SQL in Amazon Redshift? (This elegant script might be used in many other databases as well)

  Several days ago I have spent a few hours of my life figuring out how to do dynamic pivot in Amazon Redshift. To tell you the truth, I have expected much more from this DBMS SQL language. Redshift is based on Postgre SQL 8.0.2 ( which was released in Read More... Posted Tuesday, November 7, 2017 10:39 AM by Maria Zakourdaev | 8 Comments Filed under: SQL, Amazon Redshift, Pivot, Python, CTE