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.
As per the latest Redshift documentation, this is a valid parameter...
1
answers
0
votes
178
views
asked 2 months agolg...
I have created an External Table using Redshift Spectrum and using AWS Glue to crawl deeply nested json files coming into s3 bucket every second.
I was able to populate a redshift table by...
2
answers
0
votes
217
views
asked 2 months agolg...
My understanding is the Redshift cluster node has one leader node and one or more compute nodes in single-AZ cluster.
when multi-AZ is enabled, additional/same number of nodes are deployed in second...
1
answers
0
votes
128
views
asked 2 months agolg...
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
196
views
asked 2 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
393
views
asked 2 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
210
views
asked 2 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
337
views
asked 2 months agolg...
Hi,
I'm trying to use the the pagination functionality of the Redshift Data API (using boto3):...
2
answers
0
votes
461
views
asked 2 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
546
views
asked 2 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
172
views
asked 2 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
180
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
596
views
asked 3 months agolg...