#SQL
Using SQLite with JSON Data
Using SQLite to store, query and modify JSON data with full flexibility. Using JSON columns works best, if you need to support a flexible datamodel and during prototyping. Read more →
Tenant Isolation in Snowflake for ML - Operational Patterns
Follow-up to Tenant Isolation in Snowflake: how to run multi-tenant ML workloads in practice, from copying tenant data and promoting changes between environments to experimenting with real customer data under strict controls. Read more →
Tenant Isolation in Snowflake
Snowflake offers several ways to isolate tenants: separate accounts, separate databases, separate schemas, or shared tables with a tenant_id column. This post compares them with pros, cons and best practices. Read more →
Python Support in Snowflake
Snowflake offers different ways to access and call python from within their compute infrastructure. This post will show how to access python in user defined functions, via stored procedures and in snowpark. Read more →
Convert the Himalayan Database to SQLite
Conversion of the Himalayan database of the legendary Elizabeth Hawley from FoxPro to SQLite. Read more →
Azure Synapse SQL On-Demand OPENROWSET Common Table Expression with SQLAlchemy
Using SQLAlchemy to create openrowset common table expressions for Azure Synapse SQL-on-Demand Read more →
Using turbodbc to access Azure Synapse SQL-on-demand endpoints
Azure Synapse SQL-on-Demand offers a web client, the desktop version Azure Data studio and odbc access with turbodbc to query parquet files in the Azure Data Lake. Read more →
