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 trying to create a daily ETL that reads data from Redshift and sends it to my RDS. I am using two JDBC connections. I manage to get the data from Redshift but when I try to push to RDS I get the...
1
answers
0
votes
243
views
asked 7 months agolg...
Hello,
I am totally new when it comes to Redshift so I have a question about the setup. What is the best practice when setting up Redshift when we have a AWS DEV, UAT and PROD environment? Should I...
Accepted AnswerAmazon Redshift
1
answers
0
votes
237
views
asked 7 months agolg...
I have an external function in redshift that invocates a lambda function. The lambda functions hits another service that has concurrency limits, therefore I want to be able to limit the number of...
2
answers
0
votes
237
views
asked 7 months agolg...
I attempted to migrate data from a csv file from an S3 storage to a table in my Redshift cluster. I took reference from an autogenerated code which came after I built blocks using Visual mode in AWS...
1
answers
1
votes
1512
views
asked 7 months agolg...
I'm trying to setup a DMS target endpoint in account A. This endpoint is pointing to a Redshift cluster in account B.
Is this possible? How?
I already have a peering connection and I can connect to...
1
answers
0
votes
288
views
asked 8 months agolg...
We have Imported tables from FDV in our AWS account and created resource link of those tables.
But, when I am trying to Query those tables by creating schema in Redshift Query Editor, I am facing this...
1
answers
0
votes
281
views
asked 8 months agolg...
Hi,
I am considering Redshift as an option for a new design. We have ~6B of billing events a day where the raw data size of each one is ~1KB (say 12 different fields/columns). My idea is that it is...
Accepted AnswerAmazon Redshift
2
answers
0
votes
197
views
asked 8 months agolg...
I'm working with Amazon Redshift, which is based on PostgreSQL 8.0.2, and I'm implementing a functionality to list all the views of a given schema while excluding materialized views created with...
1
answers
0
votes
831
views
asked 8 months agolg...
Hi,
I am trying to migrate a table from Postgres to Redshift using a migration task
Simplified table structure:
| Name | Type |
| --- | --- |
| id | integer |
| time | timestamp with time zone |
|...
0
answers
0
votes
113
views
asked 8 months agolg...
Signed up for Redshft Serverless trial.
I run a proc that selects 4 columns from 110 records into a temp table, then stages replacement rows in a second temp table as it walks through the first temp...
1
answers
0
votes
675
views
asked 8 months agolg...
I have materialized view mv_abc123 on kinesis stream. When I query the SYS_VACUUM_HISTORY, I found lots of records about table mv_tbl__mv_abc123__0. most of them are vacuum deletes. This confused...
1
answers
0
votes
279
views
asked 8 months agolg...
I've created a dedicated IAR role with all the necessary policies to access the redshift and assigned it to my lambda. And also added tags "RedshiftDbRoles". I created a role in the workbench and...
1
answers
0
votes
594
views
asked 8 months agolg...