How do i set development and staging with Amazon Redshift

0 votes
I want to set up tools and services with production, staging, and local development. I'd like to use Amazon Redshift, do I actually have to think about it as $180 x # of environments / month? Is there any way to have a free staging and local environment for Redshift?
What do you do to make local development easier, faster and cheaper when working with Redshift?
Oct 4, 2018 in AWS by eatcodesleeprepeat
• 4,710 points
2,581 views

2 answers to this question.

0 votes

Reduce the number of nodes for the non-production systems. Queries will run slower and the total amount of storage will be reduced, but it could be more cost-effective. Or even use a "Dense Storage" 2TB node instead of several "Dense Compute" SSD instances -- they will provide more storage on less nodes.

answered Oct 4, 2018 by Priyaj
• 58,090 points
0 votes
As Redshift is a fork of postgres 8, you can use the Amazon-provided postgresql 8.4 JDBC or ODBC drivers, and point them to a locally running postgres 8 instance. This works well during development, since what works here will usually work on your production system (there are some exceptions).

Or you can just separate table on your Redshift cluster to run non-production activities. This might good for you test suite and "final testing" development.
answered Oct 12, 2018 by findingbugs
• 4,780 points

Related Questions In AWS

0 votes
1 answer

How do I configure and attach an internet gateway for use with Elastic Load Balancing?

Follow these steps: First, create an internet gateway and ...READ MORE

answered May 16, 2019 in AWS by Archu
3,327 views
0 votes
1 answer

How do I delete a subscription and a topic? - Amazon SNS

Follow these steps @Alia: On the navigation panel, ...READ MORE

answered Jul 25, 2019 in AWS by Archu
1,629 views
0 votes
0 answers
+2 votes
1 answer

Deploy Docker Containers from Docker Cloud

To solve this problem, I followed advice ...READ MORE

answered Sep 3, 2018 in AWS by Priyaj
• 58,090 points
2,436 views
+15 votes
2 answers

Git management technique when there are multiple customers and need multiple customization?

Consider this - In 'extended' Git-Flow, (Git-Multi-Flow, ...READ MORE

answered Mar 27, 2018 in DevOps & Agile by DragonLord999
• 8,450 points
3,460 views
0 votes
1 answer

How can I do Continuous data ingestion from on prem data sources to redshift

I can Recommend looking into AWS Schema ...READ MORE

answered Aug 8, 2018 in AWS by Priyaj
• 58,090 points
1,548 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP