At my company, we are developing a native app that we want to publish publicly on the marketplace. However, we want to restrict access to the app so that only customers who are part of our company can access it.
Our idea is to use some of the data_sharing_usage views to obtain the latest requests to install the app. We want to compare the account_id from these requests with the data we have in our customer database and, based on that, decide whether they are allowed to download the app or not. All of this should be done via a stored procedure in Snowflake.
Has anyone implemented something similar or have any idea if this is possible? I appreciate any guidance or examples you can share.
Betzabet Chaves is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.