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 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
329
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
264
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
298
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
295
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
314
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
164
views
asked 7 months agolg...
On a table with size ~30 TB, vacuum delete with ~ 70 millions rows deletion took 6 hours.
Is it normal? What can be done to decrease vacuum delete time ?
Thank you.
1
answers
0
votes
314
views
asked 7 months agolg...
In the cluster patch notes for path 178 https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html:
> The DECODE function replaces a specific value with either another specific value or a...
Accepted AnswerAmazon Redshift
1
answers
0
votes
141
views
asked 7 months agolg...
Hi,
I am getting yarn does not exist error when Connecting redshift cluster from emr where both are in same vpc. Is there any connectivity missing or any step that I need to make sure ?
1
answers
1
votes
211
views
asked 7 months agolg...
Hello Everyone,
I am facing difficulties while trying to load data from an Amazon Redshift cluster into a Spark dataframe using the included redshift connector from **EMR release 6.13.0** .
My...
1
answers
0
votes
507
views
asked 7 months agolg...
I have established a Redshift connection in AWS Glue already. My project would require me to create tables and schemas dynamically on the fly using the Glue script. Supposing that I have already got...
2
answers
0
votes
315
views
asked 7 months agolg...
Hi,
We have few cross-database views (same cluster, different DBs), which, when querying from a BI tool by multiple users same time produce following error sometimes:
**ERROR:...
2
answers
0
votes
206
views
asked 7 months agolg...