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,670 points
339 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
• 56,900 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,750 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 in AWS by Archu
61 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 in AWS by Archu
34 views
+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
756 views
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
2,516 views
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
• 56,900 points
186 views
+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,380 points
175 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
• 56,900 points
269 views