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
195
views
asked a month 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
468
views
asked a month 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
146
views
asked a month 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
76
views
asked a month 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
528
views
asked a month 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
830
views
asked a month 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
141
views
asked 2 months 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
127
views
asked 2 months 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
157
views
asked 2 months 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
174
views
asked 2 months 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
168
views
asked 2 months 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
172
views
asked 2 months agolg...