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.
931 results
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 20 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...
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...