Bill Heller wheller

## README.md

      
              2 files
            
          
              15 forks
            
          
                14 comments
              
            
              55 stars
            
          
                magnetikonline
                / README.md
            
            
              Last active
              September 16, 2024 14:23
            
              
                CloudFormation API Gateway endpoint calling a Lambda function using proxy integration example.
              
          
    CloudFormation API Gateway integration to Lambda function

Template that will create the following:

API Gateway:

Deployed as a REGIONAL endpoint.
Single root method, accepting POST requests only, with Lambda proxy integration to a target function.


In-line Python Lambda function echoing back requesting users IP address to API Gateway requests:

IAM role for Lambda allowing CloudWatch logs access.
Permissions for Lambda that allow API Gateway endpoint to successfully invoke function.


## postgres_to_redshift.csv

          
            PostgreSQL Data Types
            AWS DMS Data Types
            Redshift Data Types

            
              INTEGER
              INT4
              INT4

            
              SMALLINT
              INT2
              INT2

            
              BIGINT
              INT8
              INT8

            
              NUMERIC (p,s)
              If precision is 39 or greater, then use STRING.
              If the scale is => 0 and =< 37 then: NUMERIC (p,s) If the scale is => 38 and =< 127 then: VARCHAR (Length)

            
              DECIMAL(P,S)
              If precision is 39 or greater, then use STRING.
              If the scale is => 0 and =< 37 then: NUMERIC (p,s) If the scale is => 38 and =< 127 then: VARCHAR (Length)

            
              REAL
              REAL4
              FLOAT4

            
              DOUBLE
              REAL8
              FLOAT8

            
              SMALLSERIAL
              INT2
              INT2

            
              SERIAL
              INT4
              INT4

## aws_signed_request_v4.rb
#Signing AWS Requests By Using Signature Version 4
#http://docs.aws.amazon.com/general/latest/gr/sigv4_signing.html

require 'uri'
require 'openssl'
require 'net/http'
require 'cgi'

method = 'GET'
service = 'iam'

## boot.js
// This script will boot app.js with the number of workers
// specified in WORKER_COUNT.
//
// The master will respond to SIGHUP, which will trigger
// restarting all the workers and reloading the app.

var cluster = require('cluster');
var workerCount = process.env.WORKER_COUNT || 2;

// Defines what each worker needs to run

## australian-postcodes.sql
/*
Taken and cribbed from blog.datalicious.com/free-download-all-australian-postcodes-geocod

May contain errors where latitude and longitude are off. Use at own non-validated risk.
*/

SET NAMES utf8;
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

DROP TABLE IF EXISTS postcodes_geo;
PostgreSQL Data Types	AWS DMS Data Types	Redshift Data Types
INTEGER	INT4	INT4
SMALLINT	INT2	INT2
BIGINT	INT8	INT8
NUMERIC (p,s)	If precision is 39 or greater, then use STRING.	If the scale is => 0 and =< 37 then: NUMERIC (p,s) If the scale is => 38 and =< 127 then: VARCHAR (Length)
DECIMAL(P,S)	If precision is 39 or greater, then use STRING.	If the scale is => 0 and =< 37 then: NUMERIC (p,s) If the scale is => 38 and =< 127 then: VARCHAR (Length)
REAL	REAL4	FLOAT4
DOUBLE	REAL8	FLOAT8
SMALLSERIAL	INT2	INT2
SERIAL	INT4	INT4
	#Signing AWS Requests By Using Signature Version 4
	#http://docs.aws.amazon.com/general/latest/gr/sigv4_signing.html

	require 'uri'
	require 'openssl'
	require 'net/http'
	require 'cgi'

	method = 'GET'
	service = 'iam'
	// This script will boot app.js with the number of workers
	// specified in WORKER_COUNT.
	//
	// The master will respond to SIGHUP, which will trigger
	// restarting all the workers and reloading the app.

	var cluster = require('cluster');
	var workerCount = process.env.WORKER_COUNT \|\| 2;

	// Defines what each worker needs to run
	/*
	Taken and cribbed from blog.datalicious.com/free-download-all-australian-postcodes-geocod

	May contain errors where latitude and longitude are off. Use at own non-validated risk.
	*/

	SET NAMES utf8;
	SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

	DROP TABLE IF EXISTS postcodes_geo;