Questions tagged with Amazon Redshift

Content language: English

Sort by most recent

Browse through the questions and answers listed below or filter and sort to narrow down your results.

i want to create to schemas under dev db schema1 and schema2 Create 2 user: user1 and user 2 i want solution for below scenario. user1 should have access to only schema1 and user2 should have...
1
answers
0
votes
9
views
asked 4 days ago
How to restrict user under redshift cluster to access db and schemas, can you share steps to configure it. Also how to create roles according to above scenario.
1
answers
0
votes
14
views
asked 5 days ago
**Problem Overview** It's not clear from the documentation how to dynamically pass parameters to query a Amazon Redshift database with the create_dynamic_frame.from_options method. When using the AWS...
1
answers
0
votes
21
views
Adriano
asked 6 days ago
Hi all, I faced an strange scenario in a simple query on Redshift and i'm trying to understand if this is a bug or normal (i dont think so) behavior: My query (for example only): SELECT * FROM...
1
answers
0
votes
21
views
Mimo
asked 6 days ago
Hi, i am reading a table from MySQL RDS and trying to write it to Redshift. Glue write_dynamic_frame.from_options writes the table data implicitly into temporary folder before trying to insert it to...
1
answers
0
votes
37
views
asked 7 days ago
Hi I recently started working with Redshift and have an issue with permission management. Assume multiple users need to access a single schema in the Redshift database. However, only a single user...
1
answers
0
votes
70
views
profile picture
Bisina
asked 10 days ago
I have a Redshift Serverless with namespace and workgroup. I gave required permissions to access S3 and Glue etc I was successfully able to create Redshift external schemas using query: ``` create...
2
answers
0
votes
51
views
asked 10 days ago
We earlier used to run the following query to get the skew for tables with interleaved sort keys and it suddenly started failing: Query: " select svv_table_info.table as tablename,...
2
answers
1
votes
56
views
asked 13 days ago
Hi, i have setup a connection from Glue to redshift using the connection page. I tested it and it was successful. then i created Visual ETL job and chosen the above-mentioned connection from the...
1
answers
0
votes
69
views
asked 13 days ago
**AWS Redshift** If the table to which I am going to copy the data from flat files, has different number of columns than the file, then do we get error? If not why?
1
answers
0
votes
48
views
Manoj
asked 14 days ago
Hello, Redshift query editor v2 has suddenly started not to run saved queries. When I select from a table and click run, the query runs. But as soon as the query is saved, the run button is...
0
answers
0
votes
53
views
asked 14 days ago
Hi, All of a sudden, I cannot run any saved query in AWS Redshift query editor v2 as Run button became inactive for unknown reasons. If i create a new query, it works fine until i save it. What is...
3
answers
2
votes
116
views
asked 14 days ago