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.
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
128
views
asked 2 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
173
views
asked 2 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
406
views
asked 2 months agolg...
I have a code written in DB2 that will extract the string values between / to different...
1
answers
0
votes
162
views
asked 2 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
119
views
asked 2 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
104
views
asked 2 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
96
views
asked 2 months agolg...
I have created a database 'datashare_db' from a datashare from another aws account.
This database contains a schema 'datashare_schema'.
Now for granular access purpose, I have created another database...
0
answers
0
votes
49
views
asked 2 months agolg...
Hi I would like to create a spring boot rest application that connects to a redshift external schema. Is it possible and how can I do it?
1
answers
0
votes
177
views
asked 3 months agolg...
I wanted to copy a schema from a redshift cluster to another cluster in a testing environment is this possible?
Accepted AnswerAmazon Redshift
2
answers
0
votes
146
views
asked 3 months agolg...
Is Amazon Redshift data sharing supported for provisioned dc2 cluster types?
1
answers
0
votes
157
views
asked 3 months agolg...
How do I add a sort / dist key to the glue dynamicframe writer into redshift?
1
answers
0
votes
144
views
asked 3 months agolg...