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.
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
189
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
135
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
127
views
asked 4 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
62
views
asked 4 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
302
views
asked 4 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
238
views
asked 4 months agolg...
Is Amazon Redshift data sharing supported for provisioned dc2 cluster types?
1
answers
0
votes
210
views
asked 4 months agolg...
How do I add a sort / dist key to the glue dynamicframe writer into redshift?
1
answers
0
votes
204
views
asked 4 months agolg...
Hi,
when running an UNLOAD command on Amazon Redshift (or Redshift Serverless) with a SELECT statement attached to it.
Is the query benefiting the result caching mechanism available in Amazon...
1
answers
0
votes
176
views
asked 4 months agolg...
Hi,
I am trying to establish a connection between my desktop version of Power BI and my Provisioned Redshift cluster in the London Region but I receive a timeout error.
My cluster is publicly ...
2
answers
0
votes
224
views
asked 4 months agolg...
Hi there!
It was necessary for one user to restrict access to data in a table at the row level. I created an RLS policy and attached it to a role that is defined for only one user.
`CREATE RLS POLICY...
2
answers
0
votes
227
views
asked 4 months agolg...
Hello , I created datashare between serverless redshift workgroup and a provisioned redshift cluster ,
`
```
-- serverless
CREATE DATASHARE aggregated_tables
SET PUBLICACCESSIBLE = TRUE ;
ALTER...
2
answers
0
votes
394
views
asked 4 months agolg...