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
108
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
258
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
130
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
174
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
407
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
165
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
121
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
105
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
97
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
49
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
180
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
149
views
asked 3 months agolg...