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.
Assert code: 1000lg...
Hello,
We have two clusters sharing data via datashare. Since this morning, we have encountered the following error:
```
[2023-10-24 07:47:26] [XX000] ERROR:
[2023-10-24 07:47:26]...
1
answers
3
votes
270
views
asked 6 months agolg...
I have been attempting to follow [the documentation](https://docs.aws.amazon.com/glue/latest/dg/aws-glue-programming-etl-libraries.html) for developing Glue jobs locally.
Upon running the recommended...
2
answers
0
votes
707
views
asked 6 months agolg...
Running a basic UNLOAD ([docs](https://docs.aws.amazon.com/redshift/latest/dg/r_UNLOAD.html)) query from redshift like the one below:
```
unload('select id, name from schema.table_name where col =...
2
answers
0
votes
207
views
asked 6 months agolg...
Documentation says it was to be out of Preview on October 15th. We still cannot access it. Is there a new target date?
https://docs.aws.amazon.com/redshift/latest/dg/r_COPY-JOB.html
Also... would be...
Accepted AnswerAmazon Redshift
2
answers
1
votes
217
views
asked 6 months agolg...
We have a redshift cluster with ds2.xlarge nodes. We can NOT connect to it.
We tried to reboot it. The cluster is back with status as Available, but no Storage capacity used shown in the console....
1
answers
0
votes
306
views
asked 6 months agolg...
I'm looking at a bucket that has a default SSE-KMS customer-managed key (CMK), and was previously misconfigured with a resource policy that was *intended* to require the use of that CMK for every...
2
answers
0
votes
320
views
asked 6 months agolg...
I am working on converting some QlikView scripts into Redshift scripts. My QlikView script has a calculated field that uses the calculated result from the previous row to get the result of the current...
Accepted AnswerAmazon Redshift
1
answers
0
votes
201
views
asked 6 months agolg...
Hey people.
I'm trying to connect in a Redshift instance using a role temporary credential, but It's not working passing keys directly in JDBC url.
The following code is being executed:
```
var...
1
answers
0
votes
326
views
asked 6 months agolg...
Is there a way to query the tranaction mode of a stored procedure in Redshift? What I mean is, if I created an SP in NONATOMIC mode, is there anywhere within Redshift system table to let me know...
Accepted AnswerAmazon Redshift
1
answers
0
votes
227
views
asked 6 months agolg...
Why is a Redshift standard view returning different results on multiple runs of same SQL ?
1
answers
0
votes
167
views
asked 7 months agolg...
The [doc](https://docs.aws.amazon.com/redshift/latest/dg/r_enable_case_sensitive_identifier.html) states that by default, Redshift will preserve the case of a username.
> The case of a username...
2
answers
0
votes
182
views
asked 7 months agolg...
Hi I am trying to access the svl_user_info table using the super user but still I am facing the permission denied error.
Same Way I am facing the error in Redshift also ( server one).Here user is not...
2
answers
0
votes
744
views
asked 7 months agolg...