This is still in preview, but snowflake-connector-python removed the restriction to pyarrow dependency.
snowflakedb/snowflake-connector-python#1144 (comment)
In this version, they are also using nanoarrow, which is very new. Should try and see how this works with Dask.