fakesnow 0.0.2

Fake Snowflake Connector for Python. Run Snowflake DB locally.

fakesnow ❄️

Fake Snowflake Connector for Python. Run Snowflake DB locally.

Usage

import fakesnow
import snowflake.connector

with fakesnow.patch():
    conn = snowflake.connector.connect()

    print(conn.cursor().execute("SELECT 'Hello fake world!'").fetchone())

Standard imports (eg: snowflake.connector.connect) are patched. To patch additional imports, eg:

with fakesnow.patch("mymodule.connect"):
    ...

pytest fixtures are provided for testing. Example conftest.py:

from typing import Iterator

import fakesnow.fixtures
import pytest

pytest_plugins = fakesnow.fixtures.__name__

@pytest.fixture(scope="session", autouse=True)
def setup(_fakesnow_session: None) -> Iterator[None]:
    # the standard imports are now patched
    ...
    yield

Implementation coverage

• multiple databases
• cursors
• get_result_batches()
• write_pandas(..)
• table comments
• qmark binding
• access control
• standalone/out of process api/support for faking non-python connectors
• stored procedures

Partial support

• date functions
• tags
• semi-structured data

Contributing

See CONTRIBUTING.md to get started and develop in this repo.