Questions tagged [amazon-redshift-serverless]
43 questions
0
votes
0 answers
Using Flyway with Redshift Serverless
I'm currently using a provisioned Redshift cluster, and managing database migrations with Flyway. I'm thinking on migrating to Redshift Serverless, but I'm not sure if can still use Flyway to manage the migrations.
Already added the rule in my…
MariaIAF
- 1
- 1
0
votes
1 answer
AWS Redshift Serverless full executed queries
We are trying to use redshift serverless. It shows the query history is stored in the table sys_query_history.
But looking at the table, the query_text field has a 4000 characters limit. They'd truncate the query. Is there another way to get the…
lucky_start_izumi
- 2,511
- 13
- 41
- 61
0
votes
0 answers
AWS Redshift Serverless connect with Spring R2DBC
I am trying to determine if connecting to AWS Redshift Serverless can be achieved with Spring R2DBC. I know its possible with the provisioned Redshift option by specifying the url, username, password & using R2DBC & postgres drivers.
So, I am trying…
jimbob542
- 121
- 1
- 1
- 7
0
votes
1 answer
Setting Result rows dynamically in dependency of cell content
I have to tables in Redshift, articles and clicks:
articles
| articleID | authorID |
| 100 | 2 |
| 101 | 2 |
| 102 | 6 |
| 103 | 7 |
| 104 | 2 |
clicks
|articleID | category |
|100 …
MadCatERZ
- 113
- 7
0
votes
1 answer
Set "json_serialization_enable" to true permanently on AWS redshift
I am using the AWS RedShift serverless to query some s3 files which contain Parquet data. Before querying the data, I always need to run the following command:
SET json_serialization_enable TO true;
Is there a way to set this flag as true globally…
IamAshay
- 1,377
- 1
- 7
- 16
0
votes
2 answers
How do I cancel all running queries in serverless redshift?
My serverless redshift has thousands of running queries. I think it is stuck. I'm not sure how to cancel all queries and start fresh. Is there a way to do it?
Ori N
- 555
- 10
- 22
0
votes
1 answer
Redshift Snapshot using Redshift Manager by triggering Lambda Function
How to create all prod redshift snapshots using Redshift Manager...
action: aws:invokeLambdaFunction using this method (invoking Lambda Function) i want to create redshift cluster snapshots.
Ricky Vijay
- 101
- 1
- 8
0
votes
0 answers
Redshift COPY command gets stuck because of locks
I'm trying to use a python script using the redshift_connector library to perform multiple COPY commands from S3 and possibly DELETE commands - all on the same redshift table. I'm using serverless redshift.
The commands on redshift gets stuck…
Ori N
- 555
- 10
- 22
0
votes
1 answer
Redshift Serverless inbound connections timeout
i made a redshift data warehouse with the Serverless Preview in order to make it connect to a Google Data Studio.
I opened the 5439 port to every ipv6 and ipv4 on the security group, tho it still timeout.
I don't know what to do, is it possible that…
0
votes
1 answer
True if not null in SQL for Amazon Redshift
Is there a better way to get false when not null, and true when null? I cannot find a better way in the documentation.
SELECT
item_id as item_id
case some_field
when NULL
then FALSE else TRUE
end …
Phillip Scott Givens
- 5,256
- 4
- 32
- 54
0
votes
2 answers
What does "AWS public service preview" mean?
I don't really understand what does AWS service preview mean. I have seen in AWS announcements, that the Redshift Serverless was released, but it is currently in a preview mode. In AWS Service Terms I have found that SLA does not apply to the…
Oleksii Nikulin
- 73
- 2
- 11
-1
votes
1 answer
Why does the Auto Copy Job function on AWS Redshift not suported?
I want to do continuous file ingestion from Amazon S3 to AWS Redshift, but the Auto Job copy doesn't work.
COPY "prueba 8"
FROM 's3://xxxxxxxxxxxx'
IAM_ROLE 'xxxxxxxxxxxxxxxxxxxxxxxxxx'
DATEFORMAT 'auto'
IGNOREHEADER 1
DELIMITER…
Numpy
- 1
- 1
-1
votes
1 answer
In Redshift SQL query for reducing years
i have data with fields as shown below
id
grade
grade_id
year
Diff
101
5
7
2022
9
105
k
2
2021
2
106
4
6
2020
5
110
pk
1
2022
1
i want to insert records for same id until we reaches grade = pk , Like shown below for every record in…
Sri Harsha
- 11
- 4