Tutorials: Getting started with the Snowflake Python APIs¶

With the Snowflake Python APIs, you can use Python to manage Snowflake resource objects. You can create, drop, and alter tables, schemas, warehouses, tasks, and more, without writing SQL or using the Snowflake Connector for Python.

In the following tutorials, you learn how to get started with the API for object and task management in Snowflake.

Prerequisites¶

A Snowflake account (Note: trial accounts are not supported in Tutorial 3: Create and manage Snowpark Container Services)
Familiarity with Python, and one of the following supported versions of Python:
- 3.9
- 3.10
- 3.11
Familiarity with Jupyter notebooks
A code editor that supports Jupyter notebooks, or the ability to run notebooks in your browser using jupyter notebook

What you’ll learn¶

How to install the Snowflake Python APIs library
How to create a Root object to use the API
How to create tables, schemas, and warehouses using the API
How to create and manage tasks using the API
How to create and manage components in Snowpark Container Services using the API

What you’ll build¶

Multiple objects within Snowflake

Tutorials¶

The following tutorials provide step-by-step instructions for you to explore the Snowflake Python APIs:

Common setup for Snowflake Python APIs tutorials: Installation and setup steps for exploring the tutorials
Tutorial 1: Create a database, schema, table, and warehouse: Step-by-step instructions to create a Snowflake database, schema, table, and virtual warehouse
Tutorial 2: Create and manage tasks and task graphs (DAGs): Step-by-step instructions to create and manage tasks and task graphs
Tutorial 3: Create and manage Snowpark Container Services: Step-by-step instructions to create and manage components in Snowpark Container Services