#AZURE

#python #sql #pydata #azure

Peter Hoffmann Peter Hoffmann

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


#python #parquet #pydata #pandas #azure

Peter Hoffmann Peter Hoffmann

Inspired by Uwe Korns post on DuckDB this post shows how to use Azure Synapse SQL-on-Demand to query parquet files with T-SQL on a serverless cloud infrastructure. Read More


#python #sql #pydata #azure

Peter Hoffmann Peter Hoffmann

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


#python #pydata #azure #parquet

Peter Hoffmann Peter Hoffmann

Last summer Microsoft has rebranded the Azure Kusto Query engine as Azure Data Explorer. While it does not support fully elastic scaling, it at least allows to scale up and out a cluster via an API or the Azure portal to adapt to different workloads. It also offers parquet support out of the box which made me spend some time to look into it. Read More


#exasol #azure #pydata #talk

Peter Hoffmann Peter Hoffmann

Exasol on Microsoft Azure – automatic deployment in less than 30 minutes Read More