Deploying Metabase Container into Snowpark Container Services

Requirements

1. Docker.
2. Snowflake account: an Enterprise Edition within a supported region: Region info.
3. Set default role to another that is not ACCOUNTADMIN or SYSADMIN.

Snowflake Setup

1. In Snowflake UI, run commands from setup.sql. More info here.
2. Save image repository URL. It should be: <orgname>-<acctname>.snowflakecomputing.com/tutorial_db/data_schema/tutorial_repository.

Build and Push Image

1. Building from Dockerfile:

docker build --rm --platform linux/amd64 -t <repository_url>/metabase_service_image:latest .

2. Authenticate Docker with the Snowflake registry:

docker login rctdbyr-fe41115.registry.snowflakecomputing.com -u <user>

3. Push image:

docker push <repository_url>/<image_name>

Create and Access Service:

1. Execute commands from create_access_service.sql

Clean up

1. Execute commands from clean_up.sql