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 using Amazon appflow to make data integration between Hubspot and Redshift. I am using Incremental Transfer option, but instead of updating(changed record) in Redshift, it insert a new...
0
answers
0
votes
69
views
asked 13 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
219
views
asked 14 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
181
views
asked 15 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
338
views
asked 15 days agolg...
I have created a database 'datashare_db' from a datashare from another aws account.
This database contains a schema 'datashare_schema'.
Now for granular access purpose, I have created another database...
0
answers
0
votes
46
views
asked 2 months agolg...
In a new pipeline we are adding to our product, we are collecting a bunch of data from different sources with something similar to keywords. The collected data is mainly text with associated metadata....
0
answers
0
votes
129
views
asked 3 months agolg...
Hello,
Currently SCT doesn't support Redshift as target with Db2 LUW as source database. Could you share what solutions are available for schema conversion for Redshift?
0
answers
0
votes
133
views
asked 3 months agolg...
I'm trying to create redshift cluster from snapshot with the terraform configuration files unfortunately it has not well and getting following error.
Error: restoring Redshift Cluster (test123) from...
0
answers
0
votes
59
views
asked 4 months agolg...
IAM Identity Center to Redshift integration: Registered identity provider does not exist for AWSIDClg...
Hi there,
I am trying to integrate IAM Identity Center with Redshift. We manage Users and Groups from IAM Identity Center from Management account where the Redshift cluster exists in an OU account....
0
answers
0
votes
73
views
asked 4 months agolg...
Hi,
I am trying to configure a scheduled query using Redshift Query Editor V2. However, I am facing an issue where I am unable to view the schedule history as I am faced with the following permission...
0
answers
0
votes
65
views
asked 4 months agolg...
Hello, I am trying to use materialized views in Redshift, where I have a Zero-ETL integration configured from Aurora MySQL to Redshift. Since the destination Redshift database is completely read-only...
0
answers
0
votes
134
views
asked 4 months agolg...
Scenario:
Source table: Glue Data Catalog table **study** crawled from MySQL with columns:
* id (int),
* code (varchar),
* desc (varchar)
* and 2 other columns not used in the job.
Target table:...
0
answers
0
votes
91
views
asked 5 months agolg...