Question : I’m trying to compare my case result (desirecountry) with an existing column (so.country_name) to get another case result […]
Tag: redshift
Finding earliest connected value over two columns
Question : I have a, perhaps slightly esoteric, use case. Given a table like the following: id1 | id2 | […]
Grant SELECT on all tables in Redshift
Question : I am trying to assign SELECT privilege to a group in Redshift. So I created a group and […]
How can Amazon Redshift be built based on PostgreSQL if Postgres is row-based?
Question : According to Amazon, Redshift is based on PostgreSQL, and is a column-oriented database management system. This looks to […]
Simple queries to Redshift really slow
Question : I just started testing AWS Redshift and populated a single node with the AWS sample data. Querying a […]
Drop user in redshift which has privilege on some object
Question : I have a pretty standard problem that I can’t resolve. I want to remove a user in redshift […]
Count specific query occurred in Redshift
Question : I wanted to count the number queries executed over one day. I have this working version : SELECT […]
How to validate data before loading it to DB
Question : I have a situation where in I have million records in CSV file, what I need to do […]
Amazon Redshift – The difference between Query Slots, Concurrency and Queues?
Question : We are building a business intelligence system, and we have a huge PostgreSQL Database (DB) where we make […]
Cons of using a star schema in a columnar database
Question : My organisation is implementing a new data warehouse using a columnar data store (Redshift) and the performance is […]