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}