Explore how you can quickly prepare for, respond to, and recover from security events. Learn more.
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.
963 results
Hello everyone.
I’m working on setting up automatic ingestion of data from S3 into Redshift.
I followed the steps outlined in the [documentation](https://docs.aws.amazon.com/redshift/latest/dg/loadin...
I am using the unload query as below,
UNLOAD ('SELECT * FROM {table_name} where {where_clause}')
TO 's3://{s3_bucket}/api_testing/{table_name}_{filter_filename}'
iam_role 'arn:aws:iam...
When setting up a Zero-ETL integration with a DynamoDB table as the source, and a Serverless Redshift Workgroup/Namespace as the target, the integration gets stuck at Database state "Creating". But I...
I am using zero-etl to move data from Aurora to Redshift. But I found out that the data is loaded to a Read-only db. How then do I move the data loaded to a new db where I can conduct transformations....
Hi,
My main question is related to interpreting the storage limits for Redshift provisioned cluster in your article [here](https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-clusters.html)...
After a failure in Vacuum Full, the numb3rs-data database had 100% of its space used. The server was rebooted and an attempt was made to run Vacuum Full again. This comand was run after deleting 1 mil...
We are currently running a 2-node **dc2.large** on-demand cluster in Redshift. We want to buy reserved nodes for our cluster.
Since reserved nodes are only available for **ra3** types. Do we need to ...
Hi,
We want to create a redshift cluster using a snappshot copy of a different cluster through cloud formation. If we have to update this new cluster's features like, number of nodes, will this actio...
I work with Amazon Web Services as a data engineer. I have created several Glue jobs that copy data from RDS Aurora MySQL to Amazon Redshift using the Glue catalog, Visual ETL, and ETL Scripts. The pr...
asked a month ago
When working in certain AWS console environments, I am often presented with blue text banners promoting the feature which I have just clicked on.
These prompts are rarely valuable information, and a...
I'm trying to send a custom email created with Lambda and an SNS topic, when a **scheduled query in Redshift Query Editor v2** state is 'FINISHED'. In order to do that, I've created a rule in **EventB...
asked a month ago
Hi everyone, I found documentation on how to migrate things into Redshift serverless, but very limited resource for the other way around - migrating OUT of serverless to regular dc2. should I use the ...