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 am reading multiple files from S3 and writing the output to Redshift DB. Below is my code to read all the files from a S3 location (s3://abc/oms/YFS_CATEGORY_ITEM/)
```
yfs_category_item_df =...
1
answers
0
votes
69
views
asked 9 hours agolg...
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
31
views
asked 14 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
54
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
68
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
84
views
asked 8 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
104
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
98
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
104
views
asked 12 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
263
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
220
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
76
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
109
views
asked 14 days agolg...