Questions tagged with Amazon Redshift

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...

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.

**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...

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...

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...

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...

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...

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,...

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...

**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?

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...

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...