I wish to god they would allow 2 connections. One read-only for my BI tool, and one read-write for dbt/sqlmesh
I think using a pyarrow dataset as an intermediary would allow for a zero copy read/write from one connection into a second connection.
alt Hacker News
I think using a pyarrow dataset as an intermediary would allow for a zero copy read/write from one connection into a second connection.