Stack Overflow
Stack Overflow

Questions tagged [amazon-redshift-serverless]

43 questions
9
votes
1 answer

AWS Redshift Serverless: `ERROR: Not authorized to get credentials of role`

I've created a serverless Redshift instance, and I'm trying to import a CSV file from an S3 bucket. I've made an IAM role with full Redshift + Redshift serverless access and S3 Read access, and added this role as a Default Role under the Permissions…
Esben von Buchwald
  • 2,772
  • 1
  • 29
  • 37
5
votes
2 answers

Permission denied for relation stl_load_errors on Redshift Serverless

I use Amazon Redshift Serverless and Query editor(v2) and I'm having trouble with user permissions. The following error occurred when importing data(.csv) in S3. ERROR: Load into table 'x' failed. Check 'sys_load_error_detail' system table for…
YAQ
  • 53
  • 1
  • 4
3
votes
1 answer

Working with Datawarehouse for Multi-tenancy

We have Multi-tenancy application where we have separate database for each client in MongoDB, PostgreSQL & separate Index in ElasticSearch. Now we are planning for Datawarehouse to be created in Amazon-RedShift Serverless & ingest all data from…
Manish Joisar
  • 1,256
  • 3
  • 23
  • 47
2
votes
1 answer

serverless redshift - secret manager create

I am trying to create a secret manager for the purpose of using lambda in serverless redshift. The redshift cluster created on the security password type selection screen is not visible, so it cannot be created. Any solution?
nightshiftman
  • 71
  • 1
  • 5
2
votes
2 answers

Why can't I connect to my AWS Redshift Serverless cluster from my laptop?

I've set up a Redshift Serverless cluster w/ a workgroup and a namespace. I turned on the "Publicly Accessible" option I've created an inbound rule for the 5439 port w/ Source set to 0.0.0.0/0 I've created an IAM credential for access to Redshift I…
RavenHursT
  • 2,336
  • 1
  • 25
  • 46
2
votes
1 answer

How to query the role assigned to table in Redshift? ( & roles assigned to user, permission to role )

I have provisioned the redshift Serverless workspace. I have created sample tables, roles and user. Assigned permission to roles and roles to table. all working fine as accepted. I have to fetch the roles and permission via SQL query . seems like…
Oz2000
  • 21
  • 1
2
votes
1 answer

Connecting AWS DMS to Redshift Serverless?

I've tried using the workgroup endpoint, and Redshift-managed VPC endpoints, but get the error message: Cluster 'XXXXX' does not exist. Does that seem like a VPC issue, or is there a quirk re Redshift Serverless? Anyone using this combo?
Mike Karp
  • 1,477
  • 13
  • 19
2
votes
1 answer

IAM users access to Amazon Redshift serverless

I'm trying to grant iam users to view redshift serverless but I get this errors when view the redshift page with my iam users: User: arn:aws:iam::XXXXXX:user/milad is not authorized to perform: redshift-serverless:ListSnapshots because no…
slashmili
  • 1,190
  • 13
  • 16
1
vote
2 answers

Redshift serverless charged_seconds and compute_seconds

I am trying to understand pricing for Redshift Serverless but slightly confused between compute_seconds and charged_seconds. I have currently set base RPU to 128 which is the default. I have have executed certain queries and after that have queried…
opensource-developer
  • 2,826
  • 4
  • 38
  • 88
1
vote
1 answer

Add Datashare to existing database in redshift

I created a datashare in Serverless cluster. Now I want to add that datashare in Provisioned cluster. Simplest way is to create a new database using below command. CREATE DATABASE temp_db FROM DATASHARE temp_share OF NAMESPACE…
kgupta
  • 37
  • 1
  • 4
1
vote
0 answers

Why do I get a SQL error near "LIMIT" in Redshift when I don't include the word "limit" anywhere in the query?

I have tried to run the following SQL query in Amazon Redshift serverless many times now and it keeps failing: with ssr as (select s_store_id, sum(sales_price) as sales, sum(profit) as profit, sum(return_amt) as returns, …
Phil
  • 21
  • 1
1
vote
1 answer

Using AWS Redshift Data API to access RedshiftServerless

Been banging my head on this for a while now. I have an AWS Redshift Serverless Workspace set up. I have loaded data to a table and am able to query it using the AWS browser tool. Using the AWS CLI, I am able to get a successful query response as…
reenrik
  • 51
  • 9
1
vote
0 answers

Redshift COPY error: "Assert code: 1000 context: Reached unreachable code - Invalid type: 6551 query"

We are trying to copy data from s3 (parquet files) to redshift. Here are the respective details. Athena DDL: CREATE EXTERNAL tablename( `id` int, `col1` int, `col2` date, `col3` string, `col4` decimal(10,2), binarycol binary); Redshift DDL: CREATE…
Hamza E. Khan
  • 23
  • 2
  • 10
1
vote
1 answer

ValidationException when Connecting to redshift serverless from Lambda function

Simple python code to connect to lambda using boto3 API: print('boto3 version: ' + boto3.__version__) redshift = boto3.client('redshift-data') def lambda_handler(event, context): print('Preparing query') response =…
IamAshay
  • 1,377
  • 1
  • 7
  • 16
1
vote
1 answer

Configuring Python redshift_connector (or psycopg2) to connect with Redshift Serverless

I just want to connect to the data stored in my Redshift serverless using Python. I see an error when I run the code below. import redshift_connector conn = redshift_connector.connect( host='Endpoint in the screenshot', database='dev', …
SSS
  • 621
  • 2
  • 7
  • 25
1
2 3