Public retool app with snowflake data

Hi , I'm trying to do a public retool app which uses snowflake as its data source, I've already set up snowflake as my data source but once I try to make the app public the following message shows up.

Note: This app contains queries to resources which require authentication. These will not work in public apps.

Apparently I can't use snowflake as a data source for public apps, I'd love to know if anyone has a workaround for this problem or if I'm missing some kind of authentication which allows snowflake to be used on public retool apps.

Hi @neta!

Are you using OAuth on your snowflake resource? If so, can you try using either basic auth or key pair auth and see if that works?

Public apps generally don't support any kind of auth for individual users.