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 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
345
views
asked 2 months 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
296
views
asked 2 months 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
338
views
asked 2 months 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
327
views
asked 2 months 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
322
views
asked 2 months 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
153
views
asked 2 months 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...
2
answers
0
votes
287
views
asked 2 months agolg...
3 different tables are joined upon view creation. On dev and prod environment everything works as expected. On test environment, however, a column A of a table T gets values of a column B of a table...
2
answers
0
votes
184
views
asked 2 months agolg...
# Error while running UNLOAD to PARQUET query using column names with spaces in
## Introduction
I have a table in Athena with the following column names ["column space 1", "column space 2"]. I...
1
answers
0
votes
643
views
asked 2 months agolg...
As per the latest Redshift documentation, this is a valid parameter...
1
answers
0
votes
201
views
asked 2 months agolg...
I have created an External Table using Redshift Spectrum and using AWS Glue to crawl deeply nested json files coming into s3 bucket every second.
I was able to populate a redshift table by...
2
answers
0
votes
229
views
asked 3 months agolg...
My understanding is the Redshift cluster node has one leader node and one or more compute nodes in single-AZ cluster.
when multi-AZ is enabled, additional/same number of nodes are deployed in second...
1
answers
0
votes
141
views
asked 3 months agolg...