[GitHub] [superset] sapcode commented on issue #22467: Superset with DuckDB engine parameters dialog gives error

[GitBox <gi...@apache.org>]

sapcode commented on issue #22467:
URL: https://github.com/apache/superset/issues/22467#issuecomment-1374276228

   Following workaround will create a DuckDB Connection with stored Engine Parameter:
   
   1. Create DuckDB database with empty Engine Parameter + Activate Allow DML
   2. Open SQLLab and fire the 2 commands: install 'httpfs'; load 'httpfs';
   3. Go back and Edit the DuckDB database Engine Parameter and this time paste in the full string:
   { "connect_args":{ "preload_extensions": ["httpfs"], "config": { "s3_endpoint": "argo-artifacts:9000", "s3_access_key_id": "XXX", "s3_secret_access_key": "XXX", "s3_url_style": "path", "s3_use_ssl": "False" } } }
   4. Save the DuckDB database -> Now from this point onwards the SQL Lab will always use the Engine Parameter
   
   So finally it looks like that the "preload_extensions" should install the httpfs if it's not present during the first database setup otherwise the first "add database dialog" will not add the DuckDB database.
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@superset.apache.org
For additional commands, e-mail: notifications-help@superset.apache.org