#!/usr/bin/env bash
set -ex

if [ ! -f "$sql_filename" ] ; then
  echo 'No $sql_filename'
  exit
fi

if [ -z "$OUTPUT_FILENAME" ] ; then
  echo 'No $OUTPUT_FILENAME'
  exit
fi

snowsql --config ~/.snowsql/config_datalytics -f ${sql_filename} \
  -D year="$year" \
  -D month_in="$month_in" \
  -D date_from="''$date_from''" \
  -D date_to="''$date_to''" \
  -o output_format=csv -o header=true -o timing=false -o friendly=false > /tmp/bidi_output.csv
# -o exit_on_error=true - option not supported in snowsql version 1.1.86

gzip -f /tmp/bidi_output.csv

aws s3 cp /tmp/bidi_output.csv.gz s3://cucumbers/BI/reports/${sql_filename}/${OUTPUT_FILENAME}.csv.gz

rm -f /tmp/bidi_output.csv.gz