[GitHub] [superset] alitrack commented on issue #20708: Unable to read S3 parquet files using DuckDB as Database Connector

Thu, 11 Aug 2022 05:43:46 -0700 


alitrack commented on issue #20708:
URL: https://github.com/apache/superset/issues/20708#issuecomment-1211938637

   There is a dirty job,  
   
   appends a method at the bottom of 
[db_engine_specs/duckdb.py](https://github.com/apache/superset/blob/master/superset/db_engine_specs/duckdb.py#L80)
 
   
   here is a example, 
   
   ```python
       @classmethod
       def execute(cls, cursor: Any, query: str, **kwargs: Any) -> None:
           sql = f"""
           install 'httpfs';
           load 'httpfs';
           SET s3_endpoint='127.0.0.1:9900';
           SET s3_access_key_id='minioadmin';
           SET s3_secret_access_key='minioadmin';
           SET s3_url_style = 'path';
           SET s3_use_ssl=false;
           """
           cursor.execute(sql)
   
           return super().execute(cursor, query, **kwargs)
   
   ```
   
   it overrides the execute method of BaseEngineSpec.
   
   <img width="468" alt="image" 
src="https://user-images.githubusercontent.com/20972179/184135676-d9d7a7b7-095f-4ddd-9def-d8a14ebe857e.png";>
   
   


-- 
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: [email protected]

For queries about this service, please contact Infrastructure at:
[email protected]


---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to