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.
Trying to connect to redshift database in python shell jobs. Tried with packages like psycopg2, redshift connector and pg. All of them gave similar error, hence I'm assuming problem is to establish...
1
answers
0
votes
158
views
asked 18 days agolg...
5 days ago, i started using Aws services for my college project where i was subscribed to services such as Kafka, IAM, EC2 and redshift. Today I was checking on the Aws 's stats for billing, only to...
1
answers
0
votes
230
views
asked 21 days agolg...
Hi,
I am planning to use the Redshift Data API for running SQL commands on our Redshift cluster. I've looked through the AWS Redshift pricing page but couldn't find specific details about the costs...
1
answers
0
votes
115
views
asked 23 days agolg...
Does the AWS/Redshift team have an update on when COPY JOB will be generally available? We have been anticipating it for over a year now, but it seems like the preview keeps being extended. Would it...
0
answers
0
votes
72
views
asked 24 days agolg...
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
491
views
asked 24 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
620
views
asked 25 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
99
views
asked 25 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
106
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
132
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
159
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
147
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
144
views
asked a month agolg...