dbt-frostlake

A dbt adapter for Frostlake — the dbt-snowflake adapter with its connection layer pointed at a Frostlake HTTP server, so a Snowflake-shaped dbt project runs locally with zero warehouse cost.

The plugin declares dependencies=["snowflake"], which hands it dbt-snowflake's entire macro and materialization surface unchanged; only open() differs, connecting through frostlake_connector (which raises the real snowflake.connector error classes, so dbt-snowflake's error handling keeps working).

Install

pip install dbt-snowflake -e ../frostlake-python -e ../frostlake_connector -e .

(frostlake_connector lives one directory up in this repository; frostlake-python is the underlying PEP 249 driver.)

Profile

my_project:
  target: dev
  outputs:
    dev:
      type: frostlake
      host: localhost      # Frostlake HTTP server
      port: 18082
      database: demo_db
      schema: public
      threads: 1

account/user are accepted (the inherited schema has them) and ignored by the server.

Smoke-tested surface

Against a booted DatabaseHttpServer (see ../demo): dbt debug, dbt seed (typed CSV loads incl. DECIMAL), dbt run (view + table materializations), dbt test (unique, not_null), dbt show, and dbt docs generate (information_schema catalog) — all green.

Start a server for it

cd ../../frostlake
mvn clean package -DskipTests
data/start-http-server.sh 18082 -f init.sql   # init.sql: CREATE DATABASE IF NOT EXISTS demo_db;