alitrack commented on issue #20708:
URL: https://github.com/apache/superset/issues/20708#issuecomment-1224093868
@Mause
Does not work, even in python code
```python
connect_args={
"preload_extensions": ["httpfs"],
"config": {
"s3_endpoint":"127.0.0.1:9900",
"s3_access_key_id":"minioadmin",
"s3_secret_access_key":"minioadmin",
"s3_url_style":"path",
"s3_use_ssl":False
}
}
from curses import endwin
from sqlalchemy import create_engine
engine = create_engine("duckdb:///",connect_args=connect_args)
import pandas as pd
def test_s3():
df = pd.read_sql("""
select count(*) from 's3://ontime/*.parquet'
""", engine)
print(df)
try:
test_s3()
except Exception as e:
print(e)
engine.execute("""
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=0;
""")
test_s3()
```
btw, you can try the Minio Play account (it is public)
``` sql
SET s3_endpoint='play.min.io:9000';
SET s3_access_key_id='Q3AM3UQ867SPQQA43P2F';
SET s3_secret_access_key='zuf+tfteSlswRu7BJ86wekitnifILbZam1KYY3TG';
SET s3_url_style = 'path';
SET s3_use_ssl=true;
SET s3_region = 'us-east-1';
select * from 's3://sales5m/sales_5m_0.parquet' limit 3;
```
--
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]
