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.
I already terminate the cluster I deleted since I dont use it anymore but it keeps charging in my account. Can you please help me check where is the problem? Thank you!
![Enter image description...
5
answers
0
votes
212
views
asked 3 months agolg...
I am trying to fetch 0.5 million records at once using API->lambda. I am executing this using nodejs and while fetching records programmatically using SQL query my API times out as it redshift...
1
answers
0
votes
403
views
asked 3 months agolg...
ERROR StatusLogger Unrecognized conversion specifier [n] starting at position 56 in conversion pattern.
Note: i have already created s3 endpoint in same vpc i am currently working on, also created...
1
answers
0
votes
224
views
asked 3 months agolg...
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
352
views
asked 3 months agolg...
Hi,
I'm trying to use the the pagination functionality of the Redshift Data API (using boto3):...
2
answers
0
votes
504
views
asked 3 months 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
565
views
asked 3 months 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
181
views
asked 3 months 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
188
views
asked 3 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
612
views
asked 3 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
366
views
asked 3 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
605
views
asked 3 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
145
views
asked 3 months agolg...