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 tags to filter
Sort by most recent
1154 results
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...
1
answers
0
votes
27
views
asked 14 hours ago
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...
1
answers
0
votes
7
views
asked 19 hours ago
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...
1
answers
0
votes
20
views
profile picture
asked 3 days 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...
2
answers
0
votes
29
views
asked 4 days ago
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...
1
answers
0
votes
24
views
asked 8 days ago
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...
1
answers
0
votes
52
views
asked 8 days ago
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...
2
answers
0
votes
47
views
asked 13 days ago
profile pictureAWS
published 15 days ago0 votes89 views
A Lambda function that forwards Redshift data to ServiceNow by creating incidents via REST API.
This post discusses how customers can ingest data from delta lake into Amazon Redshift using AWS Glue in both full load and change data capture format.
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.
1
answers
0
votes
46
views
asked 15 days ago