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'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
311
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
194
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
319
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
217
views
asked 6 months agolg...
Why is a Redshift standard view returning different results on multiple runs of same SQL ?
1
answers
0
votes
162
views
asked 6 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
180
views
asked 6 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
716
views
asked 6 months agolg...
I read the RedShift Paper: [https://assets.amazon.science/93/e0/a347021a4c6fbbccd5a056580d00/sigmod22-redshift-reinvented.pdf] (redshfit re-invented).
In chapter 2.6 Compilation Service:
> When the...
2
answers
0
votes
317
views
asked 6 months agolg...
I work for a fintech startup which is a small business where I'm the sole individual responsible for building data applications to inform the business. I'm looking for the best data infrastructure for...
1
answers
0
votes
259
views
asked 6 months agolg...
Is it possible to use Redshift Serverless as a data source in managed Grafana.
Grafana can't seem to find it, although the workgroup is tagged with GrafanaDataSource: true
1
answers
0
votes
294
views
asked 6 months agolg...
We have [Redshift's audit logs enabled](https://docs.aws.amazon.com/redshift/latest/mgmt/db-auditing.html). They are setup to write to S3. We are attempting to parse these and ingest them into Splunk....
1
answers
0
votes
287
views
asked 6 months agolg...
Hi,
I want to display timestamp with time zone offset, and checking the example for AT TIME ZONE which shows that statement SELECT TIMESTAMP '2001-02-16 20:38:40' AT TIME ZONE 'MST'; shall return...
1
answers
0
votes
308
views
asked 6 months agolg...