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.
929 results
Hello! Following documentation outlined in the links below, I am trying to handle an event on Redshift Data API ExecuteStatement query completion to support my event-driven app.
I have configured a...
For Audit purposes
we need to configure out AWS Redshift instance password policy as below:
Length =12 users or 15 admins, service, app or prod accounts.
Complexity: letters, digits, spec...
I met a error from
```
Caused by: java.net.SocketTimeoutException: connect timed out
```
while script went to
```
# Script generated for node Amazon Redshift
AmazonRedshift_nodexxxxxxxxxxx =...
When trying to create view v_generate_user_grant_revoke_ddl.sql, returned this error:
ERROR: cannot change number of columns in...
Hi all,
we are using cross-database queries and it seems like it is not possible to access materialized or regular views using it. Documentation...
For S3 objects loaded onto Redshift tables, [SYS_LOAD_HISTORY](https://docs.aws.amazon.com/redshift/latest/dg/SYS_LOAD_HISTORY.html) provides the metadata on the objects involved. It lists the...
How to check Change data capture (CDC) on RDS Zero ETL when replicate to AWS Redshift?
RDS Zero ETL support Change data capture (CDC) or no when replicate to AWS Redshift
What is the solution that will provide cost optimization:
1- RDS, then AWS Glue ETL and Crawler, then Redshift Serverless
2- RDS, then use RDS Zero ETL, then Redshift Serverless"
How to sync or load data from RDS to Redshift without S3 or Glue Job?
I need this solution support schedule load data and can know get logs for success or failed load data.
Hello,
I'm using redshift spectrum to load data into redshift from S3 parquet files.
In a table I have a string column that is being truncated at 16383 characters. I found information regarding 16kb...
Hello
I have a dc2.large Redshift cluster that I'm using to run some ETL processes, and I'm also using Metabase to generate dashboards from a table. This seems to put a strain on the database, as...
asked 16 days ago