Skip to content
# techs used - duckdb for a local dummy database
# columnar database
import duckdb
import timeit
import pandas as pd
### DDL to instantiate database ###
# create initial database connection (and instantiate database if it doesn't exist already)
con = duckdb.connect('dim-model.db')

# create two separate schemas if they don't exist already
con.sql("""
CREATE SCHEMA IF NOT EXISTS snow;
CREATE SCHEMA IF NOT EXISTS star;
""")