query-aurora.sh

query-aurora.sh

#! /bin/bash
# Script to execute a SQL query through awscli

set -ex

CLUSTER_ARN='arn:aws:rds:us-east-1:035458030717:cluster:tower'
SECRET_ARN=$(aws secretsmanager describe-secret \
  --secret-id nextflow-aurora-mysql-MasterSecret | jq -r .ARN)

QUERY="${1}"

# execute SQL query
aws rds-data execute-statement \
  --resource-arn "${CLUSTER_ARN}" \
  --schema "mysql" \
  --secret-arn "${SECRET_ARN}" \
  --sql "${QUERY}"

set +ex