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
141
views
asked 3 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
189
views
asked 3 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
431
views
asked 3 months agolg...
I have a code written in DB2 that will extract the string values between / to different...
1
answers
0
votes
179
views
asked 3 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
136
views
asked 3 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
109
views
asked 3 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
103
views
asked 3 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
52
views
asked 3 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
204
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
163
views
asked 3 months agolg...
Is Amazon Redshift data sharing supported for provisioned dc2 cluster types?
1
answers
0
votes
168
views
asked 3 months agolg...
How do I add a sort / dist key to the glue dynamicframe writer into redshift?
1
answers
0
votes
159
views
asked 3 months agolg...