Questions tagged with Amazon Redshift
Amazon Redshift uses SQL to analyze structured and semi-structured data across data warehouses, operational databases, and data lakes, using AWS-designed hardware and machine learning to deliver the best price performance at any scale.
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.
933 results
Our redshift cluster was recently upgraded to 1.0.69065 and we instantly noticed decreased performance for large queries. After investigating and determining no other changes were made we rolled back...
we need stronger SQL passwords for our Redshift users.Any way to force stronger password policy?Like min length etc.
asked 4 months ago
I have 2 different Redshift clusters. Each cluster have a PostgreSQL database with the same schema.
I want to do a federated query across these 2 databases in the 2 different Redshift clusters.
Is...
asked 4 months ago
I am using some syetem tables like svv_roles, svv_user_grants, svv_role_grants, SVV_ALL_SCHEMAS, SVV_SCHEMA_PRIVILEGES, etc. But as a regular user I am not able to see all the content which superuser...
I am trying to use the DATEADD function, but I encountered an issue. I am querying an S3 database using Athena. Do I need to store the data in Redshift to use the DATEADD function? Any guidance would...
Hi
I am trying to make a Redshift serverless workgroup publicly accessible but I am unable to achieve this..
I have tried every article I've found
I've made an api gateway, which is inside a subnet...
I have an application which uses Java JDBC Spring as a backend framework, I've connected my application to RDS MySQL I've tested the results it is able to provide the results faster but when I tested...
Hello everyone,
I have an Amazon RDS database and want to set up an Amazon Redshift database. I need to replicate (migrate) data automatically from RDS to Redshift on a daily basis. How to achieve...
Hi Experts,
I have a requirement to get data from SAP Datasphere to amazon redshift. can any of you guide me in how to do this? I read in a blog that we need to use amazon S3 for that, but I am...
Details;
I am using adminetluser while connecting to the cluster. adminetluser is a super user and also the owner of the resultant table and the view that I am invoking refresh on.
I am using...
I can't delete Redshift cluster.
Cluster identifier
us-tf-dbaws
Could you please remove it for me or stop the resizing process?
Hi Team,
I am trying to run SQL statements in Redshift by triggering using EventBridge on S3 file arrival. I am able to run SQLs using Data API but how ever I want to pass the event details to...