#SQL

Posted on October 13, 2024 in sql · sqlite

Using SQLite to store, query and modify JSON data with full flexibility. Uson JSON columns works best, if you need to support a flexible datamodel and during prototyping. Read More

Posted on March 12, 2024 in architecture · snowflake · sql

Hands-on patterns for operating Snowflake-backed ML platforms at scale. It covers tenant data duplication strategies, environment promotion workflows, ML experimentation with real customer data under strict controls, and operational trade-offs between cost, safety, and velocity. Read More

Posted on October 16, 2023 in architecture · snowflake · sql

Multi-tenancy is an architectural approach in which a single software system or data platform serves multiple independent customers (tenants), while ensuring that each tenant’s data, workloads, and configurations remain logically or physically isolated according to defined boundaries. Snowflake offers different options to achive tenant isolation. Read More

Posted on November 16, 2022 in python · sql · snowflake · pydata

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

Posted on January 10, 2021 in python · sql · mountain · sqlite

Conversion of the Himalayan database of the legendary Elizabeth Hawley from FoxPro to SQLite. Read More

Posted on September 27, 2020 in python · sql · pydata · azure

Using SQLAlchemy to create openrowset common table expressions for Azure Synapse SQL-on-Demand Read More

Posted on May 25, 2020 in python · sql · pydata · azure

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