Snowflake native app and UI using Streamlit

Question

I am new to Snowflake native app development and I am really confused on various details that I should start with building the Snowflake native app.

The use case is really simple I would like the consumer to choose the DB, SCHEMA in the UI and an API call that lists a few items in the UI and on selecting an item and clicking on Save should create a table in the chosen DB - SCHEMA and import the data from the API to the table.

Similar app - Snowflake Connector for Servicenow

But I am facing a lot of issues in building this:

1. I am not able to list all databases from the context of the native app:

I am using the following code to fetch the databases, using this code it is showing only those databases within the context of the app.

`database_df = session.sql("SHOW DATABASES;").collect() `  

I tried giving privileges USAGE inside manifest.yml but not able to fetch the database list.

2. I am confused on when to use the PROCEDURE UDFs in Snowflake as I think with session.sql(query) in Streamlit itself I will be able to get the data and execute the commands. Please correct me if I am wrong.

3. Do we have any related examples of using an API to fetch the data in a native app using Streamlit in Snowflake. Because developing something with no context is getting me too frustrated specifically when developing this with little knowledge on what to do with native apps.

I have tried using the privileges in the manifest.yml file and it didn't work I am getting the databases within the app context listed not all the databases of the account.

I am not sure how to start as in totally confused with REFERENCES, PRIVILEGES, SCHEMA as well.

Any sort of help to any of the questions or any guidance to this will be very much appreciated. If there is some course to learn native app development that would also help.