[ARROW-13465] [R] to_arrow() from duckdb

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 6.0.0
• Component/s: R
• Labels: pull-request-available
• External issue URL: https://github.com/apache/arrow/issues/29128
• Assignee: Jonathan Keane
• Reporter: Jonathan Keane
• Created: 27/Jul/21 17:56
• Updated: 11/Jan/23 08:33
• Resolved: 15/Oct/21 13:11

Description

With https://github.com/duckdb/duckdb/pull/2054 duckdb will have functionality to emit Arrow tables (and ideally record batches).

We should document the workflow (and possibly write thin wrappers around these to make them consistent with other Arrow functions).

This might be an opportunity to make a larger `to_arrow()` generic that can take either a duckdb query/table/reference or a pyarrow object (wrapping `py_to_r()`) so there's a unified interface for the purposes of getting arrow data out of known sources.

Issue Links

• is related to: ARROW-12688 [R] Use DuckDB to query an Arrow Dataset
• links to: GitHub Pull Request #11032