Redshiftに簡単なクエリ投げたいとき用 shell

SendQueryToRedshift.sh

#!/bin/bash
CMDNAME=`basename $0`

# parameters
## 1.Redshift
RSHOST=''  # endpoint
RSPORT=5439
RSNAME=''
RSUSER=''
RSPASS=''

## 2.sample query
QUERY=$( cat << EOF
CREATE TABLE test (
  id int,
  message varchar(max)
);
EOF
)

# password set
export PGPASSFILE=`mktemp /tmp/pass.XXXXXX`
cat >$PGPASSFILE << EOF
$RSHOST:$RSPORT:$RSNAME:$RSUSER:$RSPASS
EOF

logger="/usr/bin/logger -i -p local1.info -t ${CMDNAME}"

# Send Query
echo "Send Query" | $logger
echo "$QUERY" | $logger
psql -d $RSNAME -h $RSHOST -p $RSPORT -U $RSUSER -c "$QUERY" 2>&1 | $logger

rm -f $PGPASSFILE