Questions tagged with Amazon Redshift
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.
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 10 days 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...
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...
Hello Team,
I would like to understand what is the clock speed of Redshift clusters which is having multiple nodes.
Also if there is any document link, please let me know.
I wanted to convert the vcpu...
Presently cannot upgrade my version of python SQLAlchemy to version 2.0 because redshift dialect doesnt support it.
There is an open github issue on...