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 =...
2
answers
0
votes
487
views
asked 21 days 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...
1
answers
0
votes
488
views
asked 22 days 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
89
views
asked 22 days 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
104
views
asked a month 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
129
views
asked a month 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
154
views
asked a month 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
130
views
asked a month 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
142
views
asked a month 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
300
views
asked a month 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
246
views
asked a month 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
107
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
127
views
asked a month agolg...