Looks like this is not possible with the current package. Also found other bugs in even the Insert Record activity.
We decided against utilizing the Snowflake Integration Service connector until it is improved. Instead, we used ODBC and the regular Database connections (see link below)