Snowflake support

[andrej-vasilj]

Hey guys, normally I work with Postgres, but at my current work they use Snowflake. I'm evaluating Piccolo as a possible ORM solution for my FastAPI backend, but I'm wondering if it can connect to a Snowflake database? Has anybody tried this?

[dantownsend]

I haven't personally tried it, but if it's Postgres compatible then hopefully it will work.

[KianAnbarestani]

Piccolo doesn’t support Snowflake. Use SQLAlchemy with snowflake-sqlalchemy:
pip install snowflake-sqlalchemy
then :

from sqlalchemy import create_engine, text

engine = create_engine(
    "snowflake://USER:PASSWORD@ACCOUNT/DB/SCHEMA?warehouse=WAREHOUSE&role=ROLE"
)

with engine.connect() as conn:
    result = conn.execute(text("SELECT CURRENT_VERSION()"))
    print(result.scalar())