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.
In the cluster patch notes for path 178 https://docs.aws.amazon.com/redshift/latest/mgmt/cluster-versions.html:
> The DECODE function replaces a specific value with either another specific value or a...
Accepted AnswerAmazon Redshift
1
answers
0
votes
154
views
asked 8 months agolg...
Hi,
I am getting yarn does not exist error when Connecting redshift cluster from emr where both are in same vpc. Is there any connectivity missing or any step that I need to make sure ?
1
answers
1
votes
239
views
asked 8 months agolg...
Hello Everyone,
I am facing difficulties while trying to load data from an Amazon Redshift cluster into a Spark dataframe using the included redshift connector from **EMR release 6.13.0** .
My...
1
answers
0
votes
567
views
asked 8 months agolg...
I have established a Redshift connection in AWS Glue already. My project would require me to create tables and schemas dynamically on the fly using the Glue script. Supposing that I have already got...
2
answers
0
votes
343
views
asked 8 months agolg...
Hi,
We have few cross-database views (same cluster, different DBs), which, when querying from a BI tool by multiple users same time produce following error sometimes:
**ERROR:...
2
answers
0
votes
226
views
asked 8 months agolg...
Is there a system view that shows what stored procedures that are currently running?
1
answers
0
votes
214
views
asked 8 months agolg...
Hi Community,
I'm trying to extract data from the SAP data source to a Redshift table. I tried to add a created_at column to the Redshift table with the default current timestamp value, but this...
1
answers
0
votes
249
views
asked 8 months agolg...
I am trying to create a daily ETL that reads data from Redshift and sends it to my RDS. I am using two JDBC connections. I manage to get the data from Redshift but when I try to push to RDS I get the...
1
answers
0
votes
249
views
asked 8 months agolg...
Hello,
I am totally new when it comes to Redshift so I have a question about the setup. What is the best practice when setting up Redshift when we have a AWS DEV, UAT and PROD environment? Should I...
Accepted AnswerAmazon Redshift
1
answers
0
votes
245
views
asked 8 months agolg...
I have an external function in redshift that invocates a lambda function. The lambda functions hits another service that has concurrency limits, therefore I want to be able to limit the number of...
2
answers
0
votes
247
views
asked 8 months agolg...
I attempted to migrate data from a csv file from an S3 storage to a table in my Redshift cluster. I took reference from an autogenerated code which came after I built blocks using Visual mode in AWS...
1
answers
1
votes
1582
views
asked 8 months agolg...
I'm trying to setup a DMS target endpoint in account A. This endpoint is pointing to a Redshift cluster in account B.
Is this possible? How?
I already have a peering connection and I can connect to...
1
answers
0
votes
299
views
asked 8 months agolg...