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.
Hello,
I work as a data engineer and business intelligence specialist for a fintech startup. We've entered into a new agreement with a supplier to provide a technological solution for managing their...
0
answers
0
votes
212
views
asked 10 days agolg...
When I setup column-based access control from Lakeformation permissions on an external catalog table that contains complex data types (e.g. struct/array/map data types), if I query this table using...
0
answers
0
votes
81
views
asked 11 days agolg...
can someone explain me the difference between scoped permission vs when we give permission to normal user
document is little bit tough to understand, if some one can explain the by comparing it with...
1
answers
0
votes
76
views
asked 12 days agolg...
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
58
views
asked 12 days 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
63
views
asked 12 days 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
130
views
asked 12 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
135
views
asked 15 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
108
views
asked 17 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
71
views
asked 18 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
475
views
asked 19 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
314
views
asked 19 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
83
views
asked 20 days agolg...