[Python] Integrate Superset with API using Shillelagh

I am trying to connect my Superset deployment using docker, with JSON APIs. I have tried using it with Shillelagh but i am getting following errors:



Following are the logs:

superset_worker | [2025-02-20 11:37:14,903: INFO/MainProcess] Task sql_lab.get_sql_results[4402fb45-20eb-403f-b621-2f0f5e39ae13] received superset_worker | [2025-02-20 11:37:14,907: INFO/ForkPoolWorker-1] Query 28: Executing 1 statement(s) superset_worker | [2025-02-20 11:37:14,907: INFO/ForkPoolWorker-1] Query 28: Set query to 'running' superset_app
| 2025-02-20 11:37:14,908:INFO:werkzeug:192.168.176.1 - - [20/Feb/2025 11:37:14] "POST /api/v1/sqllab/execute/ HTTP/1.1" 202 - superset_worker | [2025-02-20 11:37:14,913: INFO/ForkPoolWorker-1] Query 28: Running statement 1 out of 1 superset_worker | [2025-02-20 11:37:14,926: INFO/ForkPoolWorker-1] Task sql_lab.get_sql_results[4402fb45-20eb-403f-b621-2f0f5e39ae13] succeeded in 0.023185771999123972s: {'query_id': 28, 'status': 'failed', 'error': 'shillelagh error: Unsupported table: https://data.cdc.gov/resource/unsk-b7fc.json', 'errors': [{'message': 'shillelagh error: Unsupported table: https://data.cdc.gov/resource/unsk-b7fc.json', 'error_type': 'GENERIC_DB_ENGINE_ERROR', 'level': 'error', 'extra': {...}}]}
​

Following is the screenshot of logs if that is easier to read



Would greatly appreciate any help in this regard, thanks!

Continue reading...