For the most recent update on ongoing service disruptions affecting the AWS Middle East (UAE) Region (ME-CENTRAL-1), refer to the AWS Health Dashboard. For information on AWS Service migration, see How do I migrate my services to another region?
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
Filter questions
Select tags to filter
Sort by
Sort by most recent
Browse through the questions and answers listed below or filter and sort to narrow down your results.
1087 results
Hey,
I currently plan to test Zero-ETL integration between Amazon RDS for MySQL and Redshift cluster. I saw multiple videos decribing the integration but none of them touched on the subject of schema ...
Hey,
I'm looking for confirmation in the documentation of what kind of node Leader node is when you setup you cluster.
Let's say I have 3 compute ra3.xlplus nodes. In setup like this one, is Leader no...
I am getting the following error when trying to connect to a database after following instructions in the quib and ensuring through the command prompt that the profile setup was successful.
Connectio...
Hi,
We configured a site-to-site VPN to securely access our Redshift cluster, which was created in a private subnet as it was working fine. Now we got requirement to make the cluster publicly accessi...
I'm running a simple test from Redshift to Redshift using JDBC connector and Glue ETL. Objective is to test JOB BOOKMARK feature. I don't have a primary key defined in source, so using LoadTimestamp w...
Hi,
We have a Qlik-SaaS (multi-tenant) client hosted in a different AWS account. They want to connect to our provisioned Redshift cluster created in a private subnet. Can we achieve this connection u...
Hi AWS Support, I am unloading a .csv file from S3 bucket to Redshift but while running the SQL query using Workbench. Here is the code:
```
DROP TABLE IF EXISTS demo_schema.sample_backbook_data;
CR...
asked 10 months ago
We currently have some data in S3 that we query using Athena, we are looking into creating a datalake with tabular data (we call aggregated data) which is created by joining multiple tables using Athe...
Getting the below error while querying Redshift table from Athena.
GENERIC_INTERNAL_ERROR: Malformed request: ERROR: column "internal" does not exist in table *****
This query ran against the "public...
I have deployed a Zero-ETL integration from a Postgres RDS to my Redshift Serverless data warehouse.
I discovered an issue while trying to reduce the refresh_interval. Running this command:
`ALTER D...
The network interface was created by AWSGlueServiceRole-redshift and we've confirmed that no active Glue jobs or Redshift integrations are using it. But it won't let me delete it. How can I resolve th...
Hi,
We want to create a provisioned redshift cluster with public access option enabled. How to do it and what are the pros and cons of creating it ?
Please guide us.