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
1040 results
EXPERT
published a month ago0 votes309 views
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...
SUPPORT ENGINEER
published a month ago4 votes518 views
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...
EXPERT
published 2 months ago0 votes669 views
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...