Snowflake

All the Komodo data you are subscribed to is available in a Komodo-managed Snowflake warehouse.

What is Snowflake?

Snowflake is a cloud-based data warehousing service. Komodo uses Snowflake to store all your healthcare data, and provisions a dedicated warehouse for each account.

Accessing Your Data

You can access your Snowflake warehouse via a connection from this package that returns a DB-API 2.0 compliant connection.

from komodo import get_snowflake_connection

conn = get_snowflake_connection()
cursor = conn.cursor()
cursor.execute("SELECT * FROM my_table")
rows = cursor.fetchall()

DB-API 2.0 Compliance

The connection object follows the Python DB-API 2.0 specification, making it compatible with:

• Standard Python database patterns
• Pandas read_sql() function
• Any library expecting DB-API 2.0 connections

This means you can use familiar database operations like:

• cursor.execute() - Run queries
• cursor.fetchone() - Fetch single rows
• cursor.fetchall() - Fetch all results
• cursor.description - Get column metadata

Working with Your Data

Your Snowflake warehouse contains all the data you’re subscribed to, organized in databases, schemas, and tables. Use standard SQL to query and analyze this data through the SDK connection.