Tutorials: Getting started with the Snowflake Python APIs (original) (raw)

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
  • 3.12 (Preview Feature — Open and available to all accounts.)
• 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