I've created 2 databases in Redshift engine: database_production database_development Each database have 2 schemas: public and custom. I want to create user called developer who has all privileges in database_development database but can't connect and modify any schema in database_production.…
I've been using aws eventbridge to create a pipe that has a kinesis source, everything good with the source, filtering and enrichment. But when i try to send the information to redshift it just won't work. The logs say that…
I have the following code in PostgreSQL, which I need to reproduce on Amazon Redshift: select * from ( select distinct a.id , sum(case when a.is_batch_empty then 1 else 0 end) over (partition by a.client_id order by a.id) as empty_count…
I am trying to add a date range to my sql query. The date range should change every quarter Example on April 1 2024 - The date range for the data should be trailing 12 months, ie it should look…
We have a dynamodb database and would like to export the data to a new redshift database staging table on a nightly basis. Ideally I think it be better if we only export inserts or updates since last load otherwise…
I am trying to filter out data that is stored as strings but represents numeric values. I filter out non-numeric strings then convert to a float. I am then trying to filter values above or below a specific amount. Below…
I have 2 clusters,both publicly accessible,same security groups,but in different public subnets,I can connect to one cluster from local, but not the other. Tried connecting via cluster ip, tried adding my ip as well as 0.0.0.0/0 to security groups, rebooted…
I want to group all entries in my table by their user_type property. However the user_type entries exist in a {type of user} {date account was created} format, e.g. id | user_type -------------- 01 | 'admin 2024-03-01' 02 | 'admin…
My table has some null and empty strings, these look ugly when I query the table so I want to replace them with other values. I don't own the data so I can't modify the table itself, this needs to…
I have such an example of tables: table1: col 1 col2 col3 col4 1 a x1 asdc 2 b x2 czxa 3 c x3 xfsdaa table2: col2 col3 l x56 q x99 All I want is to receive such a…