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
Reaching out to see if anyone has changed the transaction isolation level on one or more of their production Redshift databases from transaction isolation level *serializable isolation* to *snapshot...
I am developing a data pipeline for building a Redshift data warehouse as below:
1. Export DynamoDB data to S3 using 'export to S3' feature
2. In glue, create a spark data-frame on the S3 exported...
**Overview of Your AWS Architecture:**
- **Data Source:** RDS Aurora MySQL
- **ETL Process:** AWS Glue
- **Data Target:** Amazon Redshift
- **Reporting Tool:** Amazon QuickSight
**My Objective:**
i...
Hello,
We are using aws dms to copy the rds postgres data to our datawarehouse redshift. The issue we are facing was , in one of the tables we have jsonb as datatype in our source postgres , when...
Currently, I must define permissions model in lake house using lake formation that I can query data by Athena. It's ok if data sources come from S3 but seem be impossible if it's Redshift. Athena can...
Question from customer :Is there a way to backup an athena datasource without backing up each views? is snapshotting an option. From my research, the only options from this repost is to download the...
I have a glue pyspark script that processes DDB data exported to S3 and writes it to Redshift. Initially, it was using below logic:
```
redshiftConnectionOptions = {
"postactions": "BEGIN; MERGE...
Got this error when trying to insert from temp internal table to external table.
ERROR: Invalid DataCatalog response for external table "reportdb"."logs_aggregated": Cannot deserialize Table. Error:...
I am trying to connect my AWS Glue notebook in Sagemaker Studio to Redshift Serverless, but I keep encountering a connection timeout error.
The network mode is: Public internet access. To this mode, I...
I'm trying to refresh a materialized view with a glue job, connecting to Redshift cluster using boto3 authenticating with a database username. The execution timeouts with no errors in CloudWatch.
I'm...
asked 3 months ago
I'm trying to run this query on redshift, but I have an **ERROR: Assert **
```sql
with recursive tbl(col1, col2) as (
select 1 as col1, 'str_' as col2
union all
select (col1 + 1) as col1,...
Hi,
I am looking for some advice on changing cluster from dc2.large 4 nodes to ra3.xlplus 1 node.
The priority reason is more storage however this had been untouched since setup for my company a few...