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.
# Error while running UNLOAD to PARQUET query using column names with spaces in
## Introduction
I have a table in Athena with the following column names ["column space 1", "column space 2"]. I...
1
answers
0
votes
647
views
asked 2 months agolg...
As per the latest Redshift documentation, this is a valid parameter...
1
answers
0
votes
204
views
asked 3 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
232
views
asked 3 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
143
views
asked 3 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
215
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
405
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
226
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
355
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
508
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
567
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
182
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
189
views
asked 3 months agolg...