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.
Hello, what is the recommended way of doing this and can someone point/provide me step by steps from scratch please?
Would it be better to import from this on Prem MS Access DB into on Prem SQL...
Description:
We are encountering a persistent error in our Amazon Redshift cluster when attempting to drop a view (src.de_application__subscription_status_history). The error message cache lookup...
We are currently creating materialized views using a procedure that drops the existing view if it exists and then recreates it. However, we see an issue with a materialized view that is depended on by...
asked 6 days ago
I'm aware of the Zero-ETL integration. But the integration fails because I have foreign keys with a CASCADE constraint.
I tried DMS but I have the exact same problem.
> Tables in task scope have...
I occasionally encounter an error while executing the query below. However, when I rerun the query after the error occurs, it runs successfully. What could be causing this error?
```
WITH...
Hello, I am trying to connect the AWS Glue to Redshift, but instead it is failing to connect. See the logs below for more information. I am not wiser from these...
Config of Redshift Cluster:
- Enhanced VPC routing has enabled
- Redshift subnet in the same subnet as S3 vpc endpoint
Config of S3
- VPC endpoints created for S3
- Routing has configured to...
Hello,
I have an AWS Aurora database instance integrated with AWS Redshift Serverless using the Zero-ETL integration. To optimize for cost efficiency, I've configured Redshift Serverless with the...
Hello. I do have a question. I'm willing to automatically run a notebook (JupyterLab - SageMaker Studio) using a Notebook Job. The difficult part is that, in my .ipynb I'm connecting to Amazon...
Reaching out to see if anyone has changed the transaction isolation level on one or more of their production Redshift databases from transaction isolation level *serializable isolation* to *snapshot...
I am developing a data pipeline for building a Redshift data warehouse as below:
1. Export DynamoDB data to S3 using 'export to S3' feature
2. In glue, create a spark data-frame on the S3 exported...
**Overview of Your AWS Architecture:**
- **Data Source:** RDS Aurora MySQL
- **ETL Process:** AWS Glue
- **Data Target:** Amazon Redshift
- **Reporting Tool:** Amazon QuickSight
**My Objective:**
i...