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.
Good day,
We are trying to implement data share moving from API OAuth2 to Redshift Serverless Data Sharing.
1. What are the best practices/advisable/methods of sharing data to external client using...
2
answers
0
votes
760
views
asked 2 months agolg...
Good day,
Please help, I'm in a really difficult position. I have road mapped to start configuring Redshift serverless with timelines etc.
My devops team configured redshift serverless 2 weeks back...
4
answers
0
votes
310
views
asked 2 months agolg...
One of our monitoring systems uses `SVV_REDSHIFT_TABLES` to identify the user tables across all databases.
When `SVV_REDSHIFT_TABLES` is queried using a non-admin user created with `SYSLOG ACCESS...
3
answers
0
votes
96
views
asked 2 months agolg...
Hi, we use SYS_QUERY_HISTORY for our internal monitoring purposes. One of our systems surfaced a couple of SELECT queries with comparatively high execution time.
Following those queries, and looking...
1
answers
0
votes
282
views
asked 2 months agolg...
Hi, I am using AWS glue studio to read from a DDB table with direct DDB connection. So far my visual diagram has two nodes:
1. Source DDB table node -> Here preview takes 5 minutes for only 2 rows of...
1
answers
0
votes
193
views
asked 2 months agolg...
I have 2 AWS accounts, Account "A" contain AWS Redshift and Account "B" has external data that crawler from S3.
## What I have done
#### Account A
1. Attached spectrum role to Redshift
![spectrum...
1
answers
0
votes
273
views
asked 2 months agolg...
We have a mixture of Redshift users querying their own tables and this query against pg_catalog tables. The bulk of the users are QuckSight-specific users. Why is this query being run?
SELECT c.oid,...
1
answers
0
votes
348
views
asked 2 months agolg...
I receive a file from external vendor. The file is in ***.dat*** format. Once the file arrives into my S3 bucket, I have to trigger a AWS Glue job to read the file and load into my Redshift table. I...
2
answers
0
votes
162
views
asked 2 months agolg...
Hi,
I took manual and final snapshots, before terminating my RedShift cluster.
And I've created RedShift cluster, with same name.
In RDS console, I can see manual, automatic and final snapshots,...
1
answers
0
votes
120
views
asked 2 months agolg...
Redshift Provisioned has this capability as documented here: https://docs.aws.amazon.com/redshift/latest/dg/loading-data-from-remote-hosts.html
I can't find a way to make that Step 1 work with...
2
answers
0
votes
106
views
asked 2 months agolg...
as i mentioned above, what's the difference between 'low spec many nodes' and 'high spec 1 node' .
when querying data with many node cluster, do many nodes cause network delays and lead to...
2
answers
0
votes
254
views
asked 2 months agolg...
Hi,
We are using RedShift and RDS for a project. We would like to know what are some of the best practices for backing up these two services. Note: We use terraform for deployment and when a snapshot...
1
answers
0
votes
127
views
asked 2 months agolg...