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.
Sample file:
{
"Messages":[
{"col1":"01",
"col2":["key":"02","value":"03"]
},
{"col1":"01",
"col2":["key":"01","value":"03"]
},
{"col1":"01",
...
1
answers
0
votes
619
views
asked 3 months agolg...
I want to connect my Redshift Serverless Cluster to an enterprise Quick sight Account. Redshift and Quick sight reside in separate account and I want to know what are the steps to connect them.
1
answers
0
votes
375
views
asked 3 months agolg...
Redshift Serverless Zero-ETL options for RDS MS-SQL & S3, Redshift options for External API Getlg...
Good day,
I am setting up a new environment with Redshift Serverless, 5 sources below
I have been instructed not to use batch processing and wondering the best/simplest methods for ingest not using...
2
answers
0
votes
613
views
asked 3 months agolg...
I want to restore a table that I deleted in RedShift production system. Is it possible and could it impact my production negatively?
Accepted AnswerAmazon Redshift
1
answers
0
votes
152
views
asked 3 months agolg...
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
424
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
155
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
804
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
383
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
122
views
asked 4 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
314
views
asked 4 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
287
views
asked 4 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
531
views
asked 4 months agolg...