Using SET statement for duckdb - setting AWS keys for S3 access

[MDoder97]

Basically the title, haven't been able to get SET statement working in the editor.
https://duckdb.org/docs/guides/import/s3_import.html

Is this implemented, can I do anything to help implement this.

Thanks

[RandomFractals]

@MDoder97 this is most likely because this free DuckDB SQL Tools Preview extension version opens local DuckDB files in read-only access mode:

https://github.com/RandomFractals/duckdb-sql-tools#read-only-duckdb

[RandomFractals]

Future releases of DuckDB SQL Tools might enable write access mode.

Meanwhile, you can sign up and try DuckDB Pro Tools that open DuckDB files in read and write access mode and provide many advanced DuckDB schema navigation features with over 30 built-in DuckDB Tools metadata and view shortcut commands.

See DuckDB Pro Tools docs for more info:

https://github.com/RandomFractals/pro-data-tools/blob/main/duckdb-tools.md#duckdb-pro-tools