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.
Good day,
1. We setting up Redshiift serverless, due to not having impact on production RDS sources we looking at zeroetl or fdw with CDC, does zeroetl replication incur cost on serverless as a...
3
answers
0
votes
404
views
asked 3 months agolg...
Given a table with this schema:
|id|name|values |
|--|----|-------|
|1 |a |`[1,2,3]`|
|1 |b |`[4,5,6]`|
|1 |c |`[x,x,y]`|
Can I query it to receive this:
|id|a|b|c|
|--|-|-|-|
|1 |1|4|x|
|1...
1
answers
0
votes
130
views
asked 3 months agolg...
Good day,
We are trying to implement data share moving from API OAuth2 to Redshift Serverless Data Sharing.
1. What are the best practices/advisable/methods of sharing data to external client using...
2
answers
0
votes
773
views
asked 3 months agolg...
Good day,
Please help, I'm in a really difficult position. I have road mapped to start configuring Redshift serverless with timelines etc.
My devops team configured redshift serverless 2 weeks back...
4
answers
0
votes
340
views
asked 3 months agolg...
One of our monitoring systems uses `SVV_REDSHIFT_TABLES` to identify the user tables across all databases.
When `SVV_REDSHIFT_TABLES` is queried using a non-admin user created with `SYSLOG ACCESS...
3
answers
0
votes
108
views
asked 3 months agolg...
Hi, we use SYS_QUERY_HISTORY for our internal monitoring purposes. One of our systems surfaced a couple of SELECT queries with comparatively high execution time.
Following those queries, and looking...
1
answers
0
votes
298
views
asked 3 months agolg...
Hi, I am using AWS glue studio to read from a DDB table with direct DDB connection. So far my visual diagram has two nodes:
1. Source DDB table node -> Here preview takes 5 minutes for only 2 rows of...
1
answers
0
votes
245
views
asked 3 months agolg...
I have 2 AWS accounts, Account "A" contain AWS Redshift and Account "B" has external data that crawler from S3.
## What I have done
#### Account A
1. Attached spectrum role to Redshift
![spectrum...
1
answers
0
votes
382
views
asked 3 months agolg...
We have a mixture of Redshift users querying their own tables and this query against pg_catalog tables. The bulk of the users are QuckSight-specific users. Why is this query being run?
SELECT c.oid,...
1
answers
0
votes
362
views
asked 3 months agolg...
I receive a file from external vendor. The file is in ***.dat*** format. Once the file arrives into my S3 bucket, I have to trigger a AWS Glue job to read the file and load into my Redshift table. I...
2
answers
0
votes
203
views
asked 3 months agolg...
Hi,
I took manual and final snapshots, before terminating my RedShift cluster.
And I've created RedShift cluster, with same name.
In RDS console, I can see manual, automatic and final snapshots,...
1
answers
0
votes
141
views
asked 3 months agolg...
Redshift Provisioned has this capability as documented here: https://docs.aws.amazon.com/redshift/latest/dg/loading-data-from-remote-hosts.html
I can't find a way to make that Step 1 work with...
2
answers
0
votes
120
views
asked 3 months agolg...