Setting up Snowpark Container Services

In this section, we’ll lay down the groundwork necessary for exploring Snowpark Container Services. We will use Docker to create an OCI-compliant image to deploy to Snowpark. We’ll start by creating Snowflake objects.

Creating Snowflake objects

To create Snowflake objects, follow these steps in Snowsight with the ACCOUNTADMIN role:

1. Create a role named test_role using the following command. This role will be used for our Snowpark application:

   USE ROLE ACCOUNTADMIN;
   CREATE ROLE test_role;

   This will print the following output:

Figure 8.2 – A Snowflake role

2. Create a database and grant access to the database role by running the following command:

   CREATE DATABASE IF NOT EXISTS SNOWPARK_DEFINITIVE_GUIDE;
   GRANT OWNERSHIP ON DATABASE SNOWPARK_DEFINITIVE_GUIDE
     TO ROLE test_role COPY CURRENT GRANTS;

   This will display the following output:

Figure...