Unanswered 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,
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
120
views
asked 8 months agolg...
I was trying to perform Glue ETL transformation and store it in AWS Serverless Redshift database and S3 (both) . However, even the Console generated PySpark sheet fails. Almost none of the methods...
0
answers
0
votes
169
views
asked 9 months agolg...
I am trying to connect AWS Glue Catalog to Redshift, but, I keep getting this error
`An error occurred while calling o86.getSink. The connection attempt failed`
In the logs (a part of it)
File...
0
answers
0
votes
196
views
asked 9 months agolg...
Hi All,
I hope everyone is doing well! I am attempting to create a federated query between Redshift and Aurora Postgres 14.
I am following the instructions on this page:...
0
answers
0
votes
220
views
asked 9 months agolg...
Hello, Following is a gist of how to perform a cross-region and cross-account redshift copy from a DynamoDB table.
Note: Couple of considerations,
1. Similar to any other AWS service, you need to...
0
answers
0
votes
219
views
asked 9 months agolg...
Is there some kind of way to tell AWS services like Step Functions, Glue, and Redshift to use UTC exclusively, and simply not display local time anywhere?
Time zone display in AWS is an indecipherable...
0
answers
0
votes
162
views
asked 10 months agolg...
Hello, we have an S3 bucket with various CSV files and an AWS Glue crawler to update the Data Catalog and finally an AWS Glue job to move the data to RedShift. The handling of data and target table is...
0
answers
0
votes
132
views
asked 10 months agolg...
Is there a way in the QuickSight Pivot Table to display rows with no values? Using filler numbers, my organization has 100 unique Regions/Fields, and each active employee is aligned to supporting a...
0
answers
0
votes
94
views
asked a year agolg...
I read data from s3 using as follow.
```
sec_id_dyf = glueContext.create_dynamic_frame.from_options(
connection_type = 's3',
...
0
answers
0
votes
106
views
asked a year agolg...
Hello community. We are observing a few issues in the Copy command from S3 to Redshift and need your advice.
PS: We're using Airflow for Orchestration and use the S3ToRedshiftOperator for the copy...
0
answers
0
votes
142
views
asked a year agolg...
When using Redshift Serverless `COPY` commands fail when copying into a table with non-null columns with default values. This can be reproduced by following [this...
0
answers
0
votes
43
views
asked a year agolg...
I am using AWS Glue for data ETL to load data from MySQL into Redshift.
In MySQL, the types of the three columns, type, sub_type, and status, are all unsigned int.
However, when stored in Redshift,...
0
answers
0
votes
60
views
asked a year agolg...