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 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
265
views
asked 11 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
209
views
asked 11 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
179
views
asked 11 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
329
views
asked 11 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
227
views
asked 15 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
255
views
asked 16 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
249
views
asked 17 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
258
views
asked 17 days agolg...
I have a step function which iterates over several data, at the end of the map I got a single json with all iterations and then uploads as json file to S3 bucket. This file on S3 I will need to use it...
1
answers
0
votes
253
views
asked 18 days agolg...
i have one table in aurora db that i want to migrate to redshift
there is one column in that table which store JSONB object and there is one data whose size is around 50KB.
my question is when i...
2
answers
0
votes
272
views
asked 18 days agolg...
Parameter name Information missing in system view PG_PROC_INFO.proargnames for not named parameterslg...
In PostgreSQL, when creating a procedure using the following syntax:
CREATE OR REPLACE PROCEDURE schema3.position_test(
OUT arg1 INTEGER,
INOUT BOOLEAN,
OUT arg3 BIGINT
)
LANGUAGE...
1
answers
0
votes
120
views
asked 18 days agolg...
We are encountering a issue where we're utilizing the "super" datatype. The column in the Parquet file we receive has a maximum length of 192K. How should we handle this data? Are there alternative...
1
answers
0
votes
193
views
asked 23 days agolg...