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 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
1621
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
302
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
297
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
203
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
899
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
706
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
289
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
621
views
asked 8 months agolg...
Is there any way to use a federated query against MySQL against a table whose name requires MySQL backtick escape characters or that has a column name that require escaping?
I have a column in a...
1
answers
0
votes
532
views
asked 8 months agolg...
I have converted a json format file in parquet, I can see the parquet file and the columns, but while querying with Athena getting error.
HIVE_UNKNOWN_ERROR: Path is not absolute:...
1
answers
0
votes
289
views
asked 8 months agolg...
Subject says it all. Is there a way to NOT have 000 appended to the filename given in the UNLOAD command when PARALLEL is set to OFF? I've tried EXTENSION but this seems to append the extension given...
Accepted AnswerAmazon Redshift
2
answers
0
votes
829
views
asked 8 months agolg...