Snowflake Python API tutorials

The Snowflake Python API enables you to manage Snowflake resource objects using Python. Using the API, you can create, delete, and modify tables, schemas, warehouses, tasks, and more, without the need to write SQL or use the Snowflake Connector for Python.

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

Prerequisites

  • A Snowflake account, such as a trial account

  • Familiarity with Python, and one of the following supported versions of Python:

    • 3.8

    • 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 API library

  • How to create a Root object to use the API

  • How to create tables, schemas, and warehouses 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 API:

Common setup for Snowflake Python API tutorials

Installation and setup steps that need to be completed before you can explore any tutorials.

Tutorial 1: Create a database, schema, table, and warehouse

Step-by-step instructions to create a Snowflake database, schema, table, and virtual warehouse.

For a tutorial on managing Snowpark Container Services, see Quickstart: Intro to Snowpark Container Services with Snowflake Python APIs.