Questions tagged with Amazon Redshift Serverless
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.
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
133
views
asked 4 months agolg...
Hello :)
I am trying to use Redshift Query Editor V2 authenticating via IAM Identity Center.
These were my setup steps:
* Created IAM Identity Center in the same region of the Serverless Workgroup
*...
0
answers
0
votes
70
views
asked 4 months agolg...
Hello,
is it currently possible to access Redshift datasets in a different AWS account than the one I am running Query Editor V2? This account is currently delegated to another management account via...
1
answers
0
votes
219
views
asked 4 months agolg...
- For INSERT, UPDATE, DELETE, and MERGE queries, Redshift creates a bunch of temporary intermediate tables
- For a given query_id, SYS_QUERY_DETAIL shall contain a lot of steps with a table_id and...
1
answers
0
votes
131
views
asked 4 months 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
61
views
asked 4 months agolg...
AppFlow Connectionlg...
Hello, I have a question about creating the AppFlow connection. When I try to create the connection to Redshift serverless using the AppFlow, an error occurs and it fails. The Redshift serverless has...
2
answers
0
votes
255
views
asked 4 months agolg...
Suddenly, Redshift Serverless will not accept any connections. I have tried using psql from my machine, from an ec2 instance, everywhere the connection just times out. I have verified the security...
2
answers
0
votes
233
views
asked 4 months agolg...
Hi,
Setting up a zero code ETL environment using Redshift mostly
I will be setting up Scheduler to ingest data from FDW RDS but for API I would like a SP/Function to execute Python scripts that do an...
2
answers
0
votes
757
views
asked 4 months agolg...
Good day,
I am trying to build a no/zero code architecture, i was planning to use MWAA for orchestration but i was tasked to look at alternatives keeping it simple
I was hoping Redshift query...
2
answers
0
votes
434
views
asked 4 months agolg...
If a connect using query Editor V2 with IAM role, i am able to query catalog. But if i am trying to connect with database user, i am not able to do it.
Also how to i connect with a python client.
2
answers
0
votes
379
views
asked 4 months agolg...
I try to create a materialized view based on an external table in the glue data catalog.
Quering the Schema and tables of the data catalog work like expected. Also the creation of normal views...
1
answers
0
votes
374
views
asked 4 months agolg...
The Zero ETL Integration for replicating data to Redshift from Aurora PostgreSQL is currently in "Preview", as [this post specifies...
1
answers
0
votes
265
views
asked 5 months agolg...