PostgreSQL: Get Started - Northwind database
Learn how to set up a PostgreSQL database with the Northwind schema, including tables, functions, and relations. This guide provides step-by-step instructions for creating a sample database.
DuckDB: Healthcare - Providers Open Payments Data
In this example, we will use DuckDB to query the Open Payments data from the Centers for Medicare & Medicaid Services (CMS). This dataset contains information about financial relationships between healthcare providers and pharmaceutical companies.
MySQL: HR CRM Example
The working example demonstrates how to set up a MySQL database with Hugr, including the creation of tables, functions, and mutations. It provides a practical guide for developers looking to integrate MySQL with Hugr.
HTTP REST API: OpenWeatherMap Example
An example of using the HTTP REST API with OpenWeatherMap as a data source.
DuckDB: Spatial - OpenStreetMap Example
An example of using DuckDB with OpenStreetMap data.
H3 Spatial Example
Learn how to create geoembeddings using H3 hexagons with Hugr.
SQL Server: Adventure Works
This example demonstrates how to set up a Microsoft SQL Server database with the Adventure Works sample data as a hugr data source.
Azure: Fabric Warehouse
This example demonstrates how to connect to a Microsoft Fabric Warehouse using Azure EntraID (service principal) authentication as a hugr data source. The example uses a star schema design with a Trip fact table and dimension tables.
DuckLake: NYC Yellow Taxi
This example demonstrates how to use DuckLake as a data source in hugr, featuring the NYC Yellow Taxi trip dataset with ~36M real taxi trip records stored in MinIO S3. It showcases self-describing schemas, time-travel queries with the @at directive, relationships, DDL operations, and DuckLake management functions.
Iceberg: Weather Observations with Time-Travel
This example demonstrates how to use Apache Iceberg as a data source in hugr, featuring a weather observations dataset with time-travel across monthly snapshots. It uses Apache Polaris as the Iceberg REST catalog with OAuth2 authentication, MinIO for S3-compatible data storage, and showcases self-describing schemas, namespace-to-module mapping, and relationship extensions.