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
1041 results
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 19 days ago
- Migrate/Copy the data from Redshift to SQL Server via DMS.
- Issue : While choosing the source engine in creating the DMS endpoint, Redshift doesn’t appear.
What is the workaround?
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 a month 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...