feat: Postgres-based meta database - Githubissues

apache / superset

Apache Superset is a Data Visualization and Data Exploration Platform

https://superset.apache.org/

Apache License 2.0

61.98k stars 13.59k forks source link

feat: Postgres-based meta database #30419

Open betodealmeida opened 19 hours ago

betodealmeida commented 19 hours ago

SUMMARY

Shillelagh can now use Postgres as a backend (via the Multicorn2 extension. This PR adds support for it to the meta database.

BEFORE/AFTER SCREENSHOTS OR ANIMATED GIF

TESTING INSTRUCTIONS

Install the latest version of Shillelagh: pip install "shillelagh[all]>=1.3.0"
Run the docker container in the Shillelagh repo that has Multicorn2 installed: docker compose -f postgres/docker-compose.yml up
Add a new Superset Meta Database with the URI superset+multicorn2://shillelagh:shillelagh123@localhost:5432/shillelagh

ADDITIONAL INFORMATION

[ ] Has associated issue:
[ ] Required feature flags:
[ ] Changes UI
[ ] Includes DB Migration (follow approval process in SIP-59)
- [ ] Migration is atomic, supports rollback & is backwards-compatible
- [ ] Confirm DB migration upgrade and downgrade tested
- [ ] Runtime estimates and downtime expectations provided
[ ] Introduces new feature or API
[ ] Removes existing feature or API