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.
What are the performance considerations while using the Redshift Federated Queries to access and query data present in Amazon Aurora RDS PostgreSQL database? The Redshift Zero ETL feature is still in...
0
answers
0
votes
23
views
asked 4 hours agolg...
I am trying to write a redshift sql query to populate a table with dates for 50 years of dates, calculate working days, weekly, monthly calculations etc.
I have tried CTE and Recursive methods, but...
1
answers
0
votes
53
views
asked a day agolg...
**Description**:
I am unable to view any clusters in Redshift Query Editor v2 despite having been granted AdministratorAccess to my IAM account on AWS. I receive the following error message:
"An...
1
answers
0
votes
60
views
asked 5 days agolg...
Hi everyone!
I'm facing with an hard task regarding AWS Redshift and Spectrum.
This is my case (I'm gonna use fake names explaining my issue):
I have a table on Redshift called `my_values` with...
Accepted AnswerAmazon Redshift
1
answers
0
votes
82
views
asked 7 days agolg...
Hello, I'd like to ask about Redshift costs.
I checked the data transfer costs when using Data Sharing, and it's $0.02 per GB in the Seoul region.
Is this cost for the transferred data inclusive of...
2
answers
0
votes
101
views
asked 8 days agolg...
Hello AWS Community,
I'm experiencing an issue with my Amazon Redshift cluster where the leader node is consistently showing 99-100% CPU utilization, while the compute nodes remain below 30%. This...
1
answers
0
votes
96
views
asked 10 days agolg...
Hi all,
I would like to know how to connect Microsoft Access to Amazon Redshift Serverless. I haven't been able to figure this out. Redshift is not listed as "Database" or "Online Service" in MS...
1
answers
0
votes
102
views
asked 11 days agolg...
Is it currently possible to perform dynamic data masking on data stored in Amazon S3 buckets when querying using Redshift Spectrum?
I understand, based on the...
1
answers
0
votes
260
views
asked 13 days agolg...
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
213
views
asked 13 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
72
views
asked 14 days 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
106
views
asked 14 days 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
120
views
asked 14 days agolg...