We use dbt's
profiles.yml files when connecting to your databases. If you haven't set up dbt yet, please go through the dbt documentation. Once you set up your database profiles, metriql CLI reads your
profiles.yml file and connects to your database using these credentials.
metriql doesn't support all the dbt adapters at the moment because, unlike dbt, metriql needs to understand the SQL dialect and generate relevant SQL expressions when you run ad-hoc questions. Here is the list of adapters metriql supports:
|Adapter for||Added version||Supported by dbt||Available report types||Documentation|
|Presto||0.07-beta||Partial support||See dbt|
You can build new adapters using our SPI, build a JAR, and include it in the classpath. See Creating new adapter