this is what i wrote to myself with regards to snowflake native apps, for future maybe it will be helpful for you
- you're supposed to use snowflakecli ( not snowsql ) the command for snowflake cli is "snow" rather than "snowsql" that is used above, not confusing at all right?
- for "snow" to work you have to install it and use it in windows in command prompt started as admin
- once it's working you have configure it, the way to do this is
- issue $ snow connection list
- go to the connection file it lists
- add your configs in the .toml file the same way other look like ( all see my config below )
- issue snow connection set-default (myconnection)
- test it by running snow sql --query "select 'this is not painful at all snowflake team' as is_it_painful "
- now you should be able to issue snow app run as the walkthrough tells you to do
connection.toml file
["myconnection"]
name = "your_cute_name_not_the_same_as_myconnection_above_which_is_the_real_name"
account = "dagass-graawa"
user = "MAGA47"
authenticator = "snowflake"
password = "will_not_tell_you"