When using linked servers, I believe, all processing occurs on the calling server. For processing to occur on the linked server you would use OpenQuery.
Configures DuckDB as a SQL Server linked server via ODBC, enabling T-SQL queries that join local SQL Server tables with remote Parquet files over HTTP/HTTPS or AWS S3 in a single statement. SQL Server ...