#SQL

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.
#python #sql #snowflake #pydata

Peter Hoffmann Peter Hoffmann

Convert the Himalayan Database to SQLite

Conversion of the Himalayan database of the legendary Elizabeth Hawley from FoxPro to SQLite.
#python #sql #mountain

Peter Hoffmann Peter Hoffmann

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
#python #sql #pydata #azure

Peter Hoffmann Peter Hoffmann

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.
#python #sql #pydata #azure

Peter Hoffmann Peter Hoffmann