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.
We have a Redshift Cluster with DC2 nodes and a Redshift Serveless service running on same AWS account in us-east-1 region.
When trying to query the SVV_EXTERNAL_TABLE view on the Redshift cluster, we...
2
answers
0
votes
193
views
asked 14 days agolg...
Hi,
I am using Amazon appflow to make data integration between Hubspot and Redshift. I am using Incremental Transfer option, but instead of updating(changed record) in Redshift, it insert a new...
0
answers
0
votes
95
views
asked 15 days agolg...
I have created a lambda function using redshift_connector to read data from S3 bucket in another AWS account, and write data into Redshift account (Lambda is in the same account with my Redshift...
1
answers
0
votes
327
views
asked 16 days agolg...
Hi team,
Our organization is embarking on a project to design a shared data model where we can efficiently store and manage a large payload.
Multiple lines of business will be both **updating this...
1
answers
0
votes
273
views
asked 16 days agolg...
I have consolidated billing at the company and I intend to remove the existing Redshift nodes in one account and upload them to another.
Can I share the reservation purchased on the previous account...
2
answers
0
votes
272
views
asked 17 days agolg...
Hello,
I have a Redshift database as well as multiple Aurora PostgreSQL clusters. My Aurora PSQL clusters use varying versions of the PSQL engine:
* 15.4
* 14.9
* 14.6
* 13.12
* 13.8
My goal is to...
0
answers
0
votes
223
views
asked 17 days agolg...
Hello,
IHAC who is currently working with Glue and Redshift and developing the first pipelines loading data from S3 into the Redshift cluster.
They were recently trying to see if there is the...
0
answers
0
votes
182
views
asked 17 days agolg...
Question:
We currently have approximately 100 tables in delta format, partitioned by yyyy, mm, dd, hh, mm. Our current process involves reading these delta tables via a crawler, cataloging them, and...
0
answers
0
votes
344
views
asked 17 days agolg...
Redshift banner touting preview cluster option pops up every time I visit the page and cannot be closed.
>Try new Amazon Redshift features in preview.Create preview cluster
>Create a cluster with...
1
answers
0
votes
233
views
asked 21 days agolg...
I have created a manifest file (named as manifest.json in S3) as
```
{
"entries": [
{"url":"s3://bucketname/2024/03/28/", "mandatory":true}]
}
```
The S3 URL is pointing to a folder. This URL...
Accepted AnswerAmazon Redshift
1
answers
0
votes
266
views
asked 22 days agolg...
I currently use Aurora MySQL and need to capture history on some tables, currently use a custom solution using custom apllication logic to capture history for a given table. Been looking Amazon Aurora...
1
answers
0
votes
258
views
asked 23 days agolg...
I have several folders in S3 generated from logs in the format:
s3://bucketname/2024/03/28/17
s3://bucketname/2024/03/29/18
s3://bucketname/2024/03/28/19
date part '2024/03/28/17' are generated in...
Accepted AnswerAmazon Redshift
1
answers
0
votes
267
views
asked 23 days agolg...