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.
In our architecture we have data from AWS MSK being ingested into AWS Redshift using the Amazon Redshift Streaming Ingestion feature. In this approach, we define an external schema where we have the...
0
answers
0
votes
118
views
asked 7 months agolg...
https://docs.aws.amazon.com/redshift/latest/dg/r_CREATE_EXTERNAL_FUNCTION.html
says "The IMMUTABLE clause isn't currently supported for Lambda UDFs."
But if you use IMMUTABLE it creates the function...
0
answers
0
votes
120
views
asked 7 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...
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
194
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
218
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
217
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
158
views
asked 9 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
131
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
93
views
asked 10 months 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
104
views
asked 10 months 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
140
views
asked a year agolg...