Support for binary columns

[normanb]

Expected behavior

A database with a column type of binary (typically used in geospatial databases) should return a binary value when executing a query for a model.

Actual behavior

When running a query in VSCode for a model with a binary column type the following error is generated.

"Error [ERR_IPC_DISCONNECTED]: IPC channel is already disconnected"

This issue doesn't prevent the table being created / populated, but removes a useful feature.

Steps To Reproduce

I am using Spark, here is the DDL;

CREATE TABLE mytable
USING binaryFile
OPTIONS (
    pathGlobFilter '*.dat',
    path 'file:///opt/data'
);

Log output/Screenshots

Looks like an issue transferring the binary data over IPC.

Operating System

Ubuntu 24.04

dbt version

1.10.9

dbt Adapter

spark

dbt Power User version

0.58.10

Are you willing to submit PR?

• [x] Yes I am willing to submit a PR!