Skip to content

Native Application - Traditional Streamlit

Goal of this tutorial is to build a traditional native application that has sql function, data that is shared, and a streamlit application that uses that shared data.

Video

Requirements

  • Snowflake account, you can use a free trial. We also assume no complex security needs.

Download

Setup

This tutorial is very UI focused so we suggest to follow along with the video and use the files / code provided.

Example V1 - Basic funtions

The goals in this first step is to introduce you to a native application framework and how to upload files to the stage. In this example we'll run the first block of code and then upload V1 files to the stage. Then run the second to create the application from the package.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
use role accountadmin;
create application package snowflake_application_package;
use application package snowflake_application_package;
create schema core;
create or replace stage files;

-- Now go upload v1 zip contents to the package's files stage.

create application snowflake_application
from application package snowflake_application_package
using '@snowflake_application_package.core.files';

call snowflake_application.resources.hello();

1
2
3
| HELLO            |
|------------------|
| hello snowflake! |

Example V2 - Share data

The of this exmaple is to show how you can add data that will be shared with the application to the end consumer. In this example we'll run the first block of code and then upload V2 files to the stage. Then run the second to create the application from the package.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
use application package snowflake_application_package;

-- Create and add data to package.
create schema if not exists shared_data;

create table if not exists accounts (id int, name varchar, value varchar);

insert into accounts values
(1, 'Nihar', 'Snowflake'),
(2, 'Frank', 'Snowflake'),
(3, 'Benoit', 'Snowflake'),
(4, 'Steven', 'Acme');

select * from accounts;

grant usage on schema shared_data to share in application package snowflake_application_package;
grant select on table accounts to share in application package snowflake_application_package;

drop application snowflake_application;

-- Upload V2 files to the stage before running.

create application snowflake_application
from application package snowflake_application_package
using '@snowflake_application_package.core.files';

use application snowflake_application;
select * from data.accounts_view;

1
2
3
4
5
6
| ID | NAME   | VALUE     |
|----|--------|-----------|
| 1  | Nihar  | Snowflake |
| 2  | Frank  | Snowflake |
| 3  | Benoit | Snowflake |
| 4  | Steven | Acme      |

Example V3 - Streamlit

For this example we'll add a streamlit application to our application so users can visulize the data we have shared with them. In this we'll upload the V3 files and then run the code.

1
2
3
4
5
6
7
8
-- Upload V3 files to the stage.
drop application snowflake_application;

use application package snowflake_application_package;

create application snowflake_application
from application package snowflake_application_package
using '@snowflake_application_package.core.files';

1
2
3
| status                                                    |
|-----------------------------------------------------------|
| Application 'SNOWFLAKE_APPLICATION' created successfully. |

Now we can click on the application and go to the app. Navigate to application

Now we can see our streamlit application that is referencing our shared data. Streamlit applicaiton

Versioning and deploying the application

To version your application and deploy the application so it can be share to other consumers please watch the video, it is all done in the UI.