Andrew S. halfb00t

halfb00t / ssh_key.tf

Created March 10, 2020 17:45 — forked from irvingpop/ssh_key.tf

Terraform external data source example - dynamic SSH key generation

	# ssh key generator data source expects the below 3 inputs, and produces 3 outputs for use:
	# "${data.external.ssh_key_generator.result.public_key}" (contents)
	# "${data.external.ssh_key_generator.result.private_key}" (contents)
	# "${data.external.ssh_key_generator.result.private_key_file}" (path)
	data "external" "ssh_key_generator" {
	program = ["bash", "${path.root}/../ssh_key_generator.sh"]

	query = {
	customer_name = "${var.customer_name}"
	customer_group = "${var.customer_group}"

halfb00t / 0_register_planet.sql

Created June 25, 2021 11:49 — forked from mojodna/0_register_planet.sql

Sample OSM Athena queries

	--
	-- This will register the "planet" table within your AWS account
	--
	CREATE EXTERNAL TABLE planet (
	id BIGINT,
	type STRING,
	tags MAP<STRING,STRING>,
	lat DECIMAL(9,7),
	lon DECIMAL(10,7),
	nds ARRAY<STRUCT<ref: BIGINT>>,