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,750 points

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
• 57,530 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,770 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
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 vote
4 answers

How do I cache my images which are stored in Amazon S3?

when caching ec2 instance these can be ...READ MORE

answered Oct 23, 2018 in AWS by Nabarupa
0 votes
1 answer

How do I create folder under an Amazon S3 bucket through PHP API?

Of Course, it is possible to create ...READ MORE

answered Apr 24, 2018 in AWS by anonymous
0 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
• 57,530 points
+13 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 26, 2018 in DevOps & Agile by DragonLord999
• 8,400 points
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
• 57,530 points