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.
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
355
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
233
views
asked 8 months agolg...
Is there a system view that shows what stored procedures that are currently running?
1
answers
0
votes
228
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
272
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
257
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
263
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
263
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
1706
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
314
views
asked 8 months agolg...
We have Imported tables from FDV in our AWS account and created resource link of those tables.
But, when I am trying to Query those tables by creating schema in Redshift Query Editor, I am facing this...
1
answers
0
votes
316
views
asked 8 months agolg...
Hi,
I am considering Redshift as an option for a new design. We have ~6B of billing events a day where the raw data size of each one is ~1KB (say 12 different fields/columns). My idea is that it is...
Accepted AnswerAmazon Redshift
2
answers
0
votes
206
views
asked 8 months agolg...
I'm working with Amazon Redshift, which is based on PostgreSQL 8.0.2, and I'm implementing a functionality to list all the views of a given schema while excluding materialized views created with...
1
answers
0
votes
991
views
asked 8 months agolg...