skillfed

snowflake.core

Snowflake Python API for Resource Management

snowflake-core v1.13.1 5.9M downloads/30d#2,010 on PyPI
Permissive license Apache-2.0 Active released

What it is and what it does

snowflake-core is the official Python subpackage for interacting with Snowflake entity metadata and managing Snowflake resources programmatically. It sits on top of snowflake-connector-python and provides a higher-level API for resource lifecycle operations—creating, deleting, and modifying Snowflake objects—rather than executing raw SQL.

The package is marked Production/Stable and actively maintained, with releases tracking closely to current development. It requires Python 3.10 or later and brings in a lean set of dependencies (pydantic for validation, requests for HTTP, pyyaml for configuration, and standard utilities). It is intended for developers, system administrators, and data engineers who need to automate Snowflake resource management as part of larger Python applications or infrastructure-as-code workflows.

Use it for:

  • Automate creation and teardown of Snowflake databases, schemas, and tables in CI/CD pipelines
  • Build infrastructure-as-code tools that manage Snowflake warehouse and compute resource configuration
  • Programmatically manage user roles, permissions, and resource grants across Snowflake accounts
  • Integrate Snowflake resource provisioning into Python-based data platform orchestration
  • Query and modify Snowflake metadata to audit or enforce organizational policies

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides Python access to Snowflake entity metadata and resource management, allowing you to create, delete, and modify Snowflake resources programmatically.

Yes. snowflake-core is actively maintained, has no known vulnerabilities, low install friction, and is the official Python API for Snowflake resource management. Install it if you need to automate Snowflake object lifecycle operations from Python; skip it if you only need to query data (use snowflake-connector-python directly for SQL execution).

Install

snowflake-core on PyPI

pip

pip install snowflake-core

uv

uv add snowflake-core

poetry

poetry add snowflake-core

Installing snowflake.core

Before you install

Low install friction with a pure Python wheel distribution. Active maintenance with a release within the last 2 days. Requires Python 3.10 or later and depends on snowflake-connector-python plus standard utilities like pydantic, requests, and pyyaml.

License in practice

Licensed under Apache-2.0 (permissive), allowing use in commercial and private projects with minimal restrictions beyond attribution.

Quickstart

pip install snowflake-core

from snowflake.core import Root
from snowflake.connector import connect

conn = connect(user='...', password='...', account='...')
root = Root(conn)
# Now interact with Snowflake resources via root

Requires Python 3.10 or later and valid Snowflake account credentials (user, password, account identifier).

Verify before relying

  • Specific resource types and operations supported beyond generic create/delete/modify
  • Performance characteristics when managing large numbers of resources
  • Backward compatibility guarantees across minor versions

Package facts

License Apache-2.0 (permissive)
Python support supports the current Python release (>=3.10)
Install friction low — pure-Python wheel
Runtime dependencies 9 — certifi, packaging, pydantic, python-dateutil, pyyaml, requests, snowflake-connector-python, typing-extensions, urllib3
Maintenance actively maintained — 2 days since the last release
First released
Downloads 5,926,935/month — #2,010 on PyPI (30-day window, as of 2026-08-14)
Known vulnerabilities none known (OSV.dev, checked 2026-08-14)

Evidence: snowflake_core-1.13.1-py3-none-any.whl

Keywords: Snowflake, analytics, cloud, database, db, warehouse

Development Status :: 5 - Production/StableEnvironment :: ConsoleEnvironment :: Other EnvironmentIntended Audience :: DevelopersIntended Audience :: EducationIntended Audience :: Information TechnologyIntended Audience :: System AdministratorsLicense :: OSI Approved :: Apache Software LicenseOperating System :: OS IndependentProgramming Language :: Python :: 3Programming Language :: SQLTopic :: DatabaseTopic :: Scientific/Engineering :: Information AnalysisTopic :: Software DevelopmentTopic :: Software Development :: LibrariesTopic :: Software Development :: Libraries :: Application FrameworksTopic :: Software Development :: Libraries :: Python Modules

Tags

snowflake resource management pythonsnowflake metadata apisnowflake entity managementsnowflake python apisnowflake warehouse managementsnowflake database administrationsnowflake object lifecycle
snowflakeresource-managementinfrastructure-as-code

More Software Development packages

typing-extensions

Provides backported and experimental type hints…

permissive · top 100 on PyPI

numpy

NumPy provides an N-dimensional array object…

permissive · top 100 on PyPI

fastapi

FastAPI is a Python web framework for building…

permissive · top 100 on PyPI

annotated-doc

Provides a way to document function parameters,…

permissive · top 100 on PyPI

typer

Typer builds command-line applications from…

permissive · top 1,000 on PyPI

distlib

Distlib provides low-level packaging utilities…

permissive · top 1,000 on PyPI

snowflake

Unified Python API for Snowflake workloads,…

permissive · top 5,000 on PyPI

snowflake-ml-python

Snowflake ML Python provides SDKs and…

permissive · top 5,000 on PyPI

snowflake-sqlalchemy

Snowflake SQLAlchemy is a SQLAlchemy dialect…

permissive · top 1,000 on PyPI

django-snowflake

Provides a Django database backend that…

permissive · top 15,000 on PyPI

snowflake-connector-python

Connects Python applications to Snowflake data…

permissive · top 1,000 on PyPI

dbt-snowflake

dbt-snowflake is the Snowflake adapter for dbt,…

permissive · top 5,000 on PyPI

snowflake-snowpark-python

Snowpark Python provides APIs to query and…

permissive · top 1,000 on PyPI

snowflake-cli

Snowflake CLI is a command-line tool for…

permissive · top 5,000 on PyPI

meltanolabs-target-snowflake

A Singer target that loads data into Snowflake…

permissive · top 15,000 on PyPI

pulumi-snowflake

A Pulumi resource provider that lets you…

permissive · top 15,000 on PyPI