Load data from Google Sheets into Snowflake to use for Looker using Google Apps Script

[Thu2]

I’ve read an article which uses Google Apps Script to load data from a Google Sheet into a MySQL database.

Here is the link to the article: https://help.looker.com/hc/en-us/articles/360023860613-How-to-use-Google-Spreadsheets-to-Input-Data-...

I would very much like to do the same for Snowflake. I tried to modify credentials variables (address, user, password, database) but it just failed.

The error is 

Exception: Failed to establish a database connection. Check connection string, username and password.

I’ve been googling but can’t figure out why. Is that this JDBC doesn’t support Snowflake?