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.
Details;
I am using adminetluser while connecting to the cluster. adminetluser is a super user and also the owner of the resultant table and the view that I am invoking refresh on.
I am using...
0
answers
0
votes
133
views
asked 5 days agolg...
I have two materialized views in redshift.
The first uses an outer join, and thus is not eligible for incremental refresh. We'll call this lookup_view.
The second view joins lookup_view to another...
0
answers
0
votes
104
views
asked 21 days agolg...
I've been trying to test out Iceberg tables with Amazon Redshift Spectrum and have come across a major issue.
Here is my setup:
1. I create an iceberg table via spark (emr 7.0) and insert data across...
0
answers
1
votes
483
views
asked a month agolg...
when I followed this document https://docs.amazonaws.cn/en_us/redshift/latest/mgmt/jdbc20-configuration-options.html#jdbc20-plugin_name-option to connect redshift with IdpTokenAuthPlugin, I got an...
0
answers
0
votes
418
views
asked a month agolg...
I got the error when write glue dynamic data frame to redshift table .
The code I have used :-
my_conn_op={
"dbtable":"public.xxxx",
...
0
answers
0
votes
434
views
asked a month agolg...
I need to union together the results of two queries - we'll call them Query A and Query B. Their outputs have matching column structures and data types, so nothing special should need to be done to...
0
answers
0
votes
93
views
asked a month agolg...
Hello,
I work as a data engineer and business intelligence specialist for a fintech startup. We've entered into a new agreement with a supplier to provide a technological solution for managing their...
0
answers
0
votes
240
views
asked a month agolg...
When I setup column-based access control from Lakeformation permissions on an external catalog table that contains complex data types (e.g. struct/array/map data types), if I query this table using...
0
answers
0
votes
103
views
asked a month agolg...
Hi,
I am querying an external partitioned table in redshift spectrum and it throws an error. The data is stored in S3, parquet files and one of the column is 'BINARY'. If i remove the partition column...
0
answers
0
votes
80
views
asked a month agolg...
Does the AWS/Redshift team have an update on when COPY JOB will be generally available? We have been anticipating it for over a year now, but it seems like the preview keeps being extended. Would it...
0
answers
0
votes
76
views
asked a month agolg...
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
533
views
asked 2 months 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
244
views
asked 2 months agolg...