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.
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
380
views
asked 3 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
226
views
asked 3 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
161
views
asked 3 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
132
views
asked 4 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
344
views
asked 4 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
168
views
asked 4 months agolg...
Hello I'm an administrator and I keep receiving the following error.
"To share a query with a team you need to have the principal tag 'sqlworkbench-team' set for your user or role."
Context: I know...
1
answers
0
votes
240
views
asked 4 months agolg...
I am doing a AWS Glue job to read from Redshift (schema_1) and write it back to Redhshift (schema_2). This process is done using below:
```
Redshift_read =...
1
answers
0
votes
492
views
asked 4 months agolg...
I have a code written in DB2 that will extract the string values between / to different...
1
answers
0
votes
228
views
asked 4 months agolg...
Hello Team,
I am trying to use a merge statement to merge data from the glue catalog to redshift tabes.
The requirement is to merge records and have a filter clause
For example: Here where the...
2
answers
0
votes
180
views
asked 4 months agolg...
- For INSERT, UPDATE, DELETE, and MERGE queries, Redshift creates a bunch of temporary intermediate tables
- For a given query_id, SYS_QUERY_DETAIL shall contain a lot of steps with a table_id and...
1
answers
0
votes
130
views
asked 4 months agolg...
I want to add a Redshift table to an existing Redshift database (containing one table) and I want to grant INSERT (to this table) privilege to a Redshift user.
I use CDK and its module...
1
answers
0
votes
122
views
asked 4 months agolg...