evidence icon indicating copy to clipboard operation
evidence copied to clipboard
verified publisher icon evidence-dev

Enable DuckDB Extensions

Open archiewood opened this issue 3 years ago • 2 comments

See #644

HTTPFS is allows you to query CSV / parquet files that are stored in S3 using DuckDB

Implementation ideas

  • Checkbox in the settings UI where you connect to DuckDB ("Use HTTPFS" or similar), which then shows fields to enter of s3_region and s3_access_key_id, and s3_secret_key_id.
  • Use the duckdb connector to conditionally run the required SQL statements, if HTTPFS is selected?

archiewood avatar Feb 27 '23 17:02 archiewood

It would also be good to enable https://duckdb.org/docs/guides/import/excel_import.html for users.

archiewood avatar Jun 12 '23 19:06 archiewood

JSON support would make it easier to handle JSON columns in queries: https://duckdb.org/docs/extensions/json.html#installing-and-loading. For now, this can be handled in the sources query if the source database supports it.

hydrojumbo avatar Jun 04 '24 04:06 hydrojumbo

Support for DuckDB extension autoloading shipped with DuckDB 1.0, so any of the default library of extensions should work in DuckDB source queries.

Other extension not yet supported

archiewood avatar Aug 14 '24 20:08 archiewood