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.
I have created an DMS service with sources as MySQL and endpoint as redshift , so i created an DMS task to add datetime and update operations columns for my existing table in redshift which is not...
2
answers
0
votes
240
views
asked 25 days agolg...
My disk storage is around 6% before creating the Main Materialized View which is nothing but MV which are created on top of other materilized view(sub). Before I do have only sub materialized views...
1
answers
0
votes
95
views
asked a month agolg...
I am trying to run a [ALTER DEFAULT PRIVILEGES](https://docs.aws.amazon.com/redshift/latest/dg/r_ALTER_DEFAULT_PRIVILEGES.html) statement so that users in a specified role can select all tables in the...
1
answers
0
votes
120
views
asked a month agolg...
Trying to ingest data from kinesis stream to redshift using firehose delivery stream. VPC is made publicly accessible and added IP address of firehose to inbound rules in security groups (modifield...
1
answers
0
votes
147
views
asked a month agolg...
Trying to ingest streaming data from kinesis using external schema and materialized views. Getting below error while creating materialized view
ERROR: -----------------------------------------------...
1
answers
0
votes
93
views
asked a month agolg...
Getting error while connecting streaming data from kinesis to redshift with few transformations using visual ETL. (using amazon kinesis - glue data catalog table as source ). Schema is already...
1
answers
0
votes
176
views
asked a month agolg...
We have a Redshift Cluster with DC2 nodes and a Redshift Serveless service running on same AWS account in us-east-1 region.
When trying to query the SVV_EXTERNAL_TABLE view on the Redshift cluster, we...
2
answers
0
votes
209
views
asked a month agolg...
Hi,
I am using Amazon appflow to make data integration between Hubspot and Redshift. I am using Incremental Transfer option, but instead of updating(changed record) in Redshift, it insert a new...
0
answers
0
votes
211
views
asked a month agolg...
I have created a lambda function using redshift_connector to read data from S3 bucket in another AWS account, and write data into Redshift account (Lambda is in the same account with my Redshift...
1
answers
0
votes
359
views
asked a month agolg...
Hi team,
Our organization is embarking on a project to design a shared data model where we can efficiently store and manage a large payload.
Multiple lines of business will be both **updating this...
1
answers
0
votes
300
views
asked a month agolg...
I have consolidated billing at the company and I intend to remove the existing Redshift nodes in one account and upload them to another.
Can I share the reservation purchased on the previous account...
2
answers
0
votes
286
views
asked a month agolg...
Hello,
I have a Redshift database as well as multiple Aurora PostgreSQL clusters. My Aurora PSQL clusters use varying versions of the PSQL engine:
* 15.4
* 14.9
* 14.6
* 13.12
* 13.8
My goal is to...
0
answers
0
votes
230
views
asked a month agolg...