Tu Hoang rebyn

rebyn / large_redshift_tables.sql

Created July 19, 2016 15:50 — forked from subelsky/large_redshift_tables.sql

Quick SQL command to find large tables in redshift

	-- based on http://stackoverflow.com/questions/21767780/how-to-find-size-of-database-schema-table-in-redshift
	SELECT name AS table_name, ROUND((COUNT(*) / 1024.0),2) as "Size in Gigabytes"
	FROM stv_blocklist
	INNER JOIN
	(SELECT DISTINCT id, name FROM stv_tbl_perm) names
	ON names.id = stv_blocklist.tbl
	GROUP BY name
	ORDER BY "Size in Gigabytes" DESC

rebyn / aws-auth-cm.sh

Created March 4, 2020 15:07 — forked from pmatv/aws-auth-cm.sh

Map IAM group to EKS ConfigMap

	#!/usr/bin/env bash

	set -o errexit
	set -o nounset
	set -o pipefail

	IAM_GROUP=${1:-admins}
	EKS_ROLE_ARN=${2:-arn:aws:iam::111122223333:role/eks-node-role}
	RBAC_GROUP=${3:-system:masters}