Connection to databases

Spotrix requires a Python DB-API database driver and an SQLAlchemy dialect to be installed for each database you want to connect to.

Supported Databases & Dependencies

Spotrix does not ship bundled with connectivity to databases, except for SQLite, which is part of the Python standard library. You’ll need to install the required packages for the database you want to use as your metadata database as well as the packages needed to connect to the databases you want to access through Spotrix.

A list of some of the recommended packages.

Database	PyPI Package
Guinsoo	No additional library needed
Apache Pinot	pip install pinotdb
Apache Presto	pip install pyhive
Trino	pip install trino
Apache Druid	pip install pydruid
ClickHouse	pip install clickhouse-connect
MindsDB	pip install MindsDB
DuckDB	pip install duckdb
Sqlite	No additional library needed
MySQL	pip install mysqlclient
MariaDB	pip install mysqlclient
Apache Drill	pip install sqlalchemy-drill
Apache Impala	pip install impyla
Apache Hive	pip install pyhive
Apache Kylin	pip install kylinpy
Apache Solr	pip install sqlalchemy-solr
Apache Spark SQL	pip install pyhive
Dremio	pip install sqlalchemy_dremio
Elasticsearch	pip install elasticsearch-dbapi
Google Sheets	pip install shillelagh[gsheetsapi]
PostgreSQL	pip install psycopg2
TimescaleDB	pip install psycopg2
YugabyteDB	pip install psycopg2

Note that many other databases are supported, the main criteria being the existence of a functional SQLAlchemy dialect and Python driver. Searching for the keyword "sqlalchemy + (database name)" should help get you to the right place.