November 2023

To use Hybrid Execution, all clients (Python, GlareDB CLI) must update to 0.7.0+. TLS was enabled and made required for Hybrid Execution.

Microsoft SQL Server

Available in: GlareDB@v0.7.0, GlareDB Cloud

GlareDB now supports SQL Server as an external data source. You can configure EXTERNAL TABLEs and EXTERNAL DATABASEs from SQL Server.

Azure Blob Storage

Available in: GlareDB@v0.7.0, GlareDB Cloud

GlareDB can now use CSV, ndjson, or Parquet files in Azure Blob Storage as external tables:

CREATE EXTERNAL TABLE my_azure_source
 FROM azure
 OPTIONS (
  account_name = '<azure-account>',
  access_key = '<access-key>'
  location = 'azure://<storage-container>/<object-path>'
);

Node bindings

Available in: GlareDB@v0.7.0

GlareDB is now available in Node.js and distributed via npm:

npm i @glaredb/glaredb

// CommonJS
const glaredb = require("@glaredb/glaredb");

let con = await glaredb.connect();
let res = await con.sql("SELECT 'hello JS'");
await res.show();

// ESM
import glaredb from "@glaredb/glaredb";

let con = await glaredb.connect();
let res = await con.sql("SELECT 'hello JS'");
await res.show();

Table functions

Available in: GlareDB@v0.7.0, GlareDB Cloud

  • Tildes (~) in paths are now properly expanded

Available in: GlareDB@v0.6.1, GlareDB Cloud

  • read_excel to read .xlsx files:

    select * from read_excel('file://data.xlsx')

SQL improvements

Available in: GlareDB@v0.7.0, GlareDB Cloud

  • Set READ_WRITE and READ_ONLY modes for external databases and tables. By setting a database or table to READ_ONLY, inserts are not permitted.

    ALTER DATABASE <database> SET ACCESS_MODE TO READ_WRITE;
ALTER TABLE <table> SET ACCESS_MODE TO READ_ONLY;

Available in: GlareDB@v0.6.1, GlareDB Cloud

  • DESCRIBE supports describing tables

    DESCRIBE my_table

Python improvements

Available in: GlareDB@v0.7.0

  • A convenient prql method was added that can be called without setting the current dialect

    import glaredb
con = glaredb.connect()
con.prql('<my prql query>').show()