7 questions
1
vote
1
answer
97
views
How to handle idle sessions in Redshift Serverless?
We are using Amazon Redshift Serverless as our primary database, with a maximum of 8 RPUs. To optimize costs, we recently reduced the idle session timeout from the default of 1 hour down to 10 minutes....
1
vote
0
answers
22
views
Redshift Query Order in Output [duplicate]
I am selecting a list .
select * from table where id in (3,1,2,4)
Is there a way to force the same order in the output as it is shown in the select above?
- 31
1
vote
1
answer
128
views
Weird query plan for "manually partitioned" table in redshift
Since AWS Redshift doesn't support native table partitioning, I implemented what in some places is called "manual partitioning" (eg.: here); in short:
Instead of creating a big time-series ...
- 23
0
votes
2
answers
115
views
AWS redshift range join slow
I want to identify the location (country, city, area, latitude, longitude) details of clients who visit my site based on the client IP address for my analysis.
We have IP address data with details of ...
0
votes
1
answer
50
views
Amazon Redshift Literals from Union Interaction
When unioning two tables together and selecting a string literal like: SELECT 'Literal' as col1, it appears filtering where col1 = 'Literal' returns no rows.
create table schema.t1 (col1 INT8, col2 ...
- 26
0
votes
2
answers
883
views
ERROR: permission denied for relation stl_query, how to resolve?
I am trying out Redshift and at first, I am trying to access queries I ran in the past but was hit by this error: ERROR: permission denied for relation stl_query and tried to grant access as well but ...
- 762
0
votes
1
answer
580
views
How to Extract Nested JSON Array in Redshift and Create a Table with Specific Columns?
I have a table in AWS Redshift with a column called json, which stores a nested JSON object as a string. I need to create a new table with three columns: sid, skill_name, and skill_vdd. The json ...
- 1,675