https://store-images.s-microsoft.com/image/apps.47896.198eae99-0b8f-48fe-a473-45a1f2aeb1c5.a986c20c-17f4-489a-aa74-ebeafa3a0642.f3a6b3a3-4b07-4b63-911e-f2acbbf35442

DuckDB + ADBC

Dataphion

DuckDB + ADBC

Dataphion

DuckDB with an ADBC server, emphasizing the distribution of DuckDB's execution power.

The VM has integrated DuckDB with an ADBC server, emphasizing the distribution of DuckDB's execution power. The solution leverages the robust storage and processing capabilities of DuckDB while enabling efficient communication and data exchange through the ADBC server. Analytical Users can now leverage the compute power of remote machine to execute OLAP workloads built on top of DuckDB while ADBC is a columnar, minimal-overhead alternative to JDBC/ODBC for analytical applications. Or in other words: ADBC is a single API for getting Arrow data in and out of different databases. Steps to connect to server: 1. By default the service will run on port 8899 when the VM is launched 2. Users can run all DuckDB queries in an ADBC client. Sample Python Script for ADBC Client: import adbc_driver_flightsql.dbapi conn = adbc_driver_flightsql.dbapi.connect("grpc://:8899") try: print("Connected to server") cursor = conn.cursor() cursor.execute(b"show tables") print(cursor.fetch_arrow_table())