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 Community,
I'm trying to extract data from the SAP data source to a Redshift table. I tried to add a created_at column to the Redshift table with the default current timestamp value, but this...
1
answers
0
votes
264
views
asked 8 months agolg...
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
255
views
asked 8 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
255
views
asked 8 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
255
views
asked 8 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
1649
views
asked 8 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
306
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
312
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
205
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
937
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
117
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
711
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
291
views
asked 8 months agolg...