コンテナランタイム版の Streamlit in Snowflake を Snowflake CLI でローカルからデプロイしてみた

USE ROLE SYSADMIN;
-- データベース・スキーマ
CREATE DATABASE IF NOT EXISTS yasuhara_st_db;
CREATE SCHEMA IF NOT EXISTS yasuhara_st_db.app;

-- ロール
USE ROLE USERADMIN;
CREATE ROLE IF NOT EXISTS yasuhara_st_creator;

-- 権限付与
USE ROLE SECURITYADMIN;
-- ロール継承
GRANT ROLE yasuhara_st_creator TO ROLE SYSADMIN;
-- データベース・スキーマの使用権限
GRANT USAGE ON DATABASE yasuhara_st_db TO ROLE yasuhara_st_creator;
GRANT USAGE ON SCHEMA yasuhara_st_db.app TO ROLE yasuhara_st_creator;
-- スキーマへのStreamlit作成権限
GRANT CREATE STREAMLIT ON SCHEMA yasuhara_st_db.app TO ROLE yasuhara_st_creator;

ALTER USER <user> SET RSA_PUBLIC_KEY = 'MII・・・';

-- コンピュートプールの作成
CREATE COMPUTE POOL IF NOT EXISTS yasuhara_st_pool
    MIN_NODES = 1
    MAX_NODES = 1
    INSTANCE_FAMILY = CPU_X64_XS;

-- 外部アクセス統合の作成
CREATE OR REPLACE EXTERNAL ACCESS INTEGRATION yasuhara_pypi_external_access_int
    ALLOWED_NETWORK_RULES = (snowflake.external_access.pypi_rule)
    ENABLED = TRUE;

-- 開発用ロールへの権限付与
GRANT USAGE ON INTEGRATION yasuhara_pypi_external_access_int TO ROLE yasuhara_st_creator;
GRANT USAGE, MONITOR, OPERATE ON COMPUTE POOL yasuhara_st_pool TO ROLE yasuhara_st_creator;

mkdir my_sis_app
cd ./my_sis_app

# 仮想環境の作成
uv venv .venv
source .venv/bin/activate

$ python --version
Python 3.11.9

code pyproject.toml

[project]
name = "yasuhara-streamlit-app"
version = "0.1.0"
requires-python = ">=3.11"
dependencies = [
  "streamlit[snowflake]",
  "snowflake-snowpark-python"
]

[tool.uv]
constraint-dependencies = ["numba>=0.56.0"]

uv pip install -e .

mkdir .streamlit
mkdir .keys # 鍵を配置
code .streamlit/secrets.toml

[connections.snowflake]
account = "<アカウント>-<組織>"
user = "<Snowflakeのユーザー名>"
authenticator = "SNOWFLAKE_JWT"
private_key_file = "./.keys/<rsa key>.p8"
role = "yasuhara_st_creator"
warehouse = "X_SMALL_WH"
database = "yasuhara_st_db"
schema = "app"

code streamlit_app.py

import streamlit as st

st.title("コンテナランタイムのローカルからの開発テスト")

# Snowflakeへの接続（ローカルでは .streamlit/secrets.toml の [connections.snowflake] を使う）
st.subheader("Snowflake session check")
conn = st.connection("snowflake")
session = conn.session()

row = session.sql("""
select
  current_account() as acct,
  current_user() as usr,
  current_role() as role,
  current_timestamp() as ts
""").collect()[0]

st.json(row.as_dict())

streamlit run streamlit_app.py

code snowcli.toml

default_connection_name = "dev"

[connections.dev]
account = "<アカウント>-<組織>"
user = "<Snowflakeのユーザー名>"
authenticator = "SNOWFLAKE_JWT"
private_key_file = "./.keys/rsa_key.p8"
role = "yasuhara_st_creator"
warehouse = "X_SMALL_WH"
database = "yasuhara_st_db"
schema = "app"

snow --config-file ./snowcli.toml connection test

code snowflake.yml

definition_version: 2

entities:
  yasuhara_streamlit:
    type: streamlit

    identifier:
      name: yasuhara_streamlit_app
      database: yasuhara_st_db
      schema: app

    runtime_name: SYSTEM$ST_CONTAINER_RUNTIME_PY3_11
    compute_pool: yasuhara_st_pool
    query_warehouse: x_small_wh
    main_file: streamlit_app.py

    external_access_integrations:
      - yasuhara_pypi_external_access_int

    artifacts:
      - streamlit_app.py
      - pyproject.toml

snow --config-file ./snowcli.toml streamlit deploy yasuhara_streamlit

[project]
name = "yasuhara-streamlit-app"
version = "0.1.0"
requires-python = ">=3.11"
dependencies = [
  "streamlit[snowflake]",
  "snowflake-snowpark-python",
  "pendulum>=3.0.0"
]

[tool.uv]
constraint-dependencies = ["numba>=0.56.0"]

import streamlit as st
import pendulum

st.title("コンテナランタイムのローカルからの開発テスト")

st.subheader("PyPI package test: pendulum")

st.write("Now (Tokyo):", pendulum.now("Asia/Tokyo").to_iso8601_string())

# Snowflake接続確認（ローカルでは .streamlit/secrets.toml の [connections.snowflake] を使う）
st.subheader("Snowflake session check")
conn = st.connection("snowflake")
session = conn.session()

row = session.sql("""
select
  current_account() as acct,
  current_user() as usr,
  current_role() as role,
  current_timestamp() as ts
""").collect()[0]

st.json(row.as_dict())

uv pip install -e .
streamlit run streamlit_app.py

snow --config-file ./snowcli.toml streamlit deploy yasuhara_streamlit --replace