s3path=$1
key=$2
secret=$3

cat<<EOL
CREATE TEMPORARY STAGE my_parquet_stage
  file_format = ( type = parquet )
  url = '${s3path}'
  
COPY INTO transactionfact
FROM (
SELECT 
    \$1:txnId,
    \$1:contractId,
    \$1:accountingRunName,
    \$1:payeeName,
    \$1:netShare,
    \$1:unitPriceUSD,
    \$1:quantity,
    \$1:activityRate,
    \$1:originalCurrencyCode,
    \$1:payeeCurrencyCode,
    \$1:exchangeRate,
    \$1:unitPricePayeeCurrency,
    \$1:originalGrossRevenue,
    \$1:payeeGrossRevenue,
    \$1:originalNetRevenue,
    \$1:payeeNetRevenue,
    \$1:accountingPeriodName
FROM @my_parquet_stage)
CREDENTIALS=( 
  AWS_KEY_ID='${key}'
  AWS_SECRET_KEY='${secret}'
)  
FILE_FORMAT=(TYPE=PARQUET)
EOL