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 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
204
views
asked 7 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
336
views
asked 7 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
235
views
asked 7 months agolg...
Why is a Redshift standard view returning different results on multiple runs of same SQL ?
1
answers
0
votes
171
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
186
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
765
views
asked 7 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
335
views
asked 7 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
267
views
asked 7 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
302
views
asked 7 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
298
views
asked 7 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
317
views
asked 7 months agolg...
Redshift cluster restarted automatically on 14th October 2023 for the account id 089611537483
wanted to know what was the reason for this and how to avoid this in future ?
1
answers
0
votes
167
views
asked 7 months agolg...