All Content 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
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...
EXPERT
published 24 days ago0 votes214 views
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...
SUPPORT ENGINEER
published 25 days ago4 votes379 views