chris

#!/bin/bash
set -e
#
# This script refreshes an Athena database for data from a DynamoDB table. It creates
# a DynamoDB S3 export of the DynamoDB table, then creates an AWS Glue crawler
# which when run, creates a Glue table. This can then be queried by Athena.
# Finally, it cleans up older exports and tables.
#

datestamp=$(date +%Y%m%d)

chris

Keybase proof

I hereby claim:

• I am chris on github.
• I am chrisrbailey (https://keybase.io/chrisrbailey) on keybase.
• I have a public key whose fingerprint is E1BB AF6E CD0F 809F 69D4 3F0F 55BF B244 BF0D B644

To claim this, I am signing this object:

chris

import (
	"github.com/aws/aws-sdk-go-v2/aws"
	"github.com/aws/aws-sdk-go-v2/config"
	"github.com/aws/aws-sdk-go-v2/service/cognitoidentityprovider"
	"github.com/aws/aws-sdk-go-v2/service/cognitoidentityprovider/types"
)

// create the AWS client - uses environment/profile for values
cognitoidentityprovider.NewFromConfig(config.LoadDefaultConfig(context.Background()))

chris

#
# S3 bucket for a web files, with CloudFront and custom domain.
#
# The bucket is setup to be private, only accessible via CloudFront.
# This uses a CloudFront OAI to provide access to the bucket, and also restricts
# access to be SSL/HTTPS only.
# The SSL cert was created manually, as it has to be created in us-east-1 for
# use with CloudFront, and there is no way to specify a region in CloudFormation
# when creating a cert.
# Finally it does Route53 DNS setup for the subdomain pointed at/for use with

chris

chris

package main

import (
	"context"
	"log"
	"os"
	"strings"

	"github.com/aws/aws-lambda-go/events"
	"github.com/aws/aws-lambda-go/lambda"

chris

#!/bin/bash
#
# Script to produce tiled raster import of a large data source, so that we can
# import in chunks, and be able to handle failures. This takes the lat/long
# mins and maxes for a rectangular area, and a VRT tile size and produces VRTs
# for each tile. It also outputs a shell script to import those VRTs along with
# outputting the last "rid" (raster ID in DB) after completing a tile, so that
# if it fails, we know the items to delete (so we can restart the failed tile,
# and not have duplicate records from what was partially imported).
#

chris

package main

import (
	"context"
	"errors"
	"regexp"
	"strings"

	"github.com/aws/aws-lambda-go/events"
	"github.com/aws/aws-lambda-go/lambda"

chris

#
# Cognito user pool/auth setup
#
Resources:
  MyAppUserPool:
    Type: AWS::Cognito::UserPool
    Properties:
      UserPoolName: myapp_user_pool
      UsernameAttributes: # use email as username/login
        - 'email'

chris

package main

import (
	"context"
	"errors"
	"strings"

	"github.com/aws/aws-lambda-go/events"
	"github.com/aws/aws-lambda-go/lambda"
)