Questions tagged with Amazon Redshift
Content language: English
Select up to 5 tags to filter
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
In Amazon Redshift, the general syntax for creating a procedure is as follows:
```
CREATE [ OR REPLACE ] PROCEDURE sp_procedure_name
( [ [ argname ] [ argmode ] argtype [, ...] ] )
[ NONATOMIC...
2
answers
0
votes
320
views
asked a month agolg...
Hi,
I'm trying to use the the pagination functionality of the Redshift Data API (using boto3):...
2
answers
0
votes
414
views
asked a month agolg...
We are migrating from Redshift to Redshift Serverless to lower costs. I would like to have ongoing replication from RS to RS Serverless so that they are in sync and we can do blue/green rollout by...
2
answers
0
votes
513
views
asked a month agolg...
Does auto sortkeys option really help with good performance if i have unpredictable order by and join condition on table also if it helps does it incure more resources to shuffle the table every time...
1
answers
0
votes
152
views
asked a month agolg...
I have this scenario where i will get updated data in csv formats in s3 (and also pushed into redshift), on a weekly (or daily basis).
Currently my sagemaker endpoint boots up with latest s3 data it...
2
answers
0
votes
159
views
asked 2 months agolg...
Sample file:
{
"Messages":[
{"col1":"01",
"col2":["key":"02","value":"03"]
},
{"col1":"01",
"col2":["key":"01","value":"03"]
},
{"col1":"01",
...
1
answers
0
votes
573
views
asked 2 months agolg...
I want to connect my Redshift Serverless Cluster to an enterprise Quick sight Account. Redshift and Quick sight reside in separate account and I want to know what are the steps to connect them.
1
answers
0
votes
320
views
asked 2 months agolg...
Redshift Serverless Zero-ETL options for RDS MS-SQL & S3, Redshift options for External API Getlg...
Good day,
I am setting up a new environment with Redshift Serverless, 5 sources below
I have been instructed not to use batch processing and wondering the best/simplest methods for ingest not using...
2
answers
0
votes
560
views
asked 2 months agolg...
I want to restore a table that I deleted in RedShift production system. Is it possible and could it impact my production negatively?
Accepted AnswerAmazon Redshift
1
answers
0
votes
104
views
asked 2 months agolg...
Good day,
1. We setting up Redshiift serverless, due to not having impact on production RDS sources we looking at zeroetl or fdw with CDC, does zeroetl replication incur cost on serverless as a...
3
answers
0
votes
342
views
asked 2 months agolg...
Given a table with this schema:
|id|name|values |
|--|----|-------|
|1 |a |`[1,2,3]`|
|1 |b |`[4,5,6]`|
|1 |c |`[x,x,y]`|
Can I query it to receive this:
|id|a|b|c|
|--|-|-|-|
|1 |1|4|x|
|1...
1
answers
0
votes
99
views
asked 2 months agolg...
Good day,
We are trying to implement data share moving from API OAuth2 to Redshift Serverless Data Sharing.
1. What are the best practices/advisable/methods of sharing data to external client using...
2
answers
0
votes
758
views
asked 2 months agolg...