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.
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
113
views
asked 3 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
268
views
asked 3 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
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
433
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
180
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
111
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
53
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
205
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
165
views
asked 3 months agolg...