What is a Database URL?
The Database URL
is the connection string of a database.
By default in Mitto it is the local database (postgresql://localhost/analytics
).
The structure of database connection strings is as follows:
<driver>://<username>:<password>@<server>:<port>/<database>?<parameters>
Common database drivers
DBMS | Driver |
---|---|
Amazon Redshift | redshift+psycopg2 |
Google BigQuery | bigquery |
IBM DB2 | db2+ibm_db |
MariaDB | mysql+pymysql |
MySQL | mysql+pymysql |
PostgreSQL | postgresql |
SQL Server | mssql+pyodbc |
Snowflake | snowflake |
Parameters
DBMS | Parameter |
---|---|
SQL Server | ?driver=ODBC+Driver+17+for+SQL+Server |
Snowflake | ?warehouse={warehouse} |