I woud like to access S3 resources by httpfs on DuckDB shell. I installed httpfs extension. But i always meet that error : " Invalid Input Error: Secret type 's3' does not exist, but it exists in the httpfs extension. Please try installing the httpfs extension by running: INSTALL httpfs; Alternatively, consider enabling autoinstall by running: SET autoinstall_known_extensions=1; ", when i create Secret . Does anyone know reasons why?
The error when creating Secret in Duck DB Shell
Firstly, I installed extension httpfs (INSTALL httpfs;) and then i also loaded httpfs (LOAD httpfs;). Then i created Secret with (CREATE SECRET ();) to connect with my S3 resources. But it didn't work.