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
1045 results
EXPERT
published 2 months ago0 votes676 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...
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,...
EXPERT
published 3 months ago1 votes2445 views
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...
Hi,
I performed a classic resize from dc2.large 4 nodes to dc2.large 5 nodes around 8 hours ago. However the status is still stuck on modifying and I am concerned on how to approach this.
I could...