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.
Hi,
I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
80
views
asked a month agolg...
Hi everyone,
I continue to have problems with zero-ETL, which ends on its own in three days.
even though both sides of those services are currently active. Can someone please assist us with a...
2
answers
0
votes
135
views
asked a month agolg...
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
196
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
469
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 2 months 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
530
views
asked 2 months 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 2 months 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
143
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
128
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
177
views
asked 2 months agolg...