Randy randypitcherii

Hashmap Software Development Flow

This document explains the general workflow used at Hashmap for software projects on github.

Please feel free to reach out if you'd like me to change any of this.

First, let's discuss some git / github terms that are often confusing.

git -> a version control software. This software is what allows developers on different machines to collaborate on the same code base in a really efficient way.
github -> github is a website that hosts git repositories. It has a ton of social / communication / PM features that make it a nice way to collaborate on software projects.

Storage Tier	Storage Cost (monthly per Gigabyte)	Read Cost (per 1K requests + per Gigabyte read)	Write Cost (per 1K requests)
S3 Standard	$0.023	$0.0004 + $0.0007	$0.005
S3 IA	$0.0125	$0.001 + $0.01	$0.01
S3 IA One Zone	$0.01	$0.001 + $0.01	$0.01
Glacier Standard	$0.004	$0.05 + $0.01	$0.05

	//=============================================================================
	// Set context
	//=============================================================================
	USE ROLE <YOUR_ROLE>;
	USE WAREHOUSE <YOUR_WAREHOUSE>;
	USE DATABASE <YOUR_DATABASE>;

	CREATE SCHEMA NETFLIX_STREAMS_AND_TASKS;
	//=============================================================================

	//=============================================================================
	// create top level objects
	//=============================================================================
	USE ROLE SYSADMIN;

	// Database
	CREATE DATABASE STRUCTURE_WORKSPACE;

	// Warehouse
	CREATE WAREHOUSE STRUCTURE_WORKSPACE_WH

	// This SQL file is for the Hands On Lab Guide for the 30-day free Snowflake trial account
	// The numbers below correspond to the sections of the Lab Guide in which SQL is to be run in a Snowflake worksheet
	// Modules 1 and 2 of the Lab Guide have no SQL to be run

	// See the lab guide here - https://s3.amazonaws.com/snowflake-workshop-lab/InpersonZTS_LabGuide.pdf


	//=====================================
	// MODULE 1
	// Steps to Prepare Your Lab Environment

	// ===========================================================================
	// Welcome!
	//
	// Log in to your Snowflake instance, create a new worksheet, then
	// copy and paste the contents of this file into your worksheet.
	//
	// Make sure you're using the ACCOUNTADMIN role before we get started
	// (see the context in the upper right corner of your worksheet)
	//
	// Next, head over to the Partner Connect page (link in the top right of the snowflake toolbar).

	// ===========================================================================
	// Welcome!
	//
	// Log in to your Snowflake instance, create a new worksheet, then
	// copy and paste the contents of this file into your worksheet.
	// ===========================================================================



	// ===========================================================================

	# Shorten Bash Prompt
	PS1='$ '

	# Env Vars
	export JAVA_HOME=$(/usr/libexec/java_home)
	export GREP_OPTIONS="--color=auto"

	# Init jenv
	if which jenv > /dev/null; then eval "$(jenv init -)"; fi

	{
	"New Component": {
	"prefix": "newComponent",
	"body": [
	"import React, { Component } from 'react';",
	"",
	"import { withStyles } from '@material-ui/core/styles';",
	"",
	"const styles = {",
	"\t//customStyle: {",