SQLMESH with trino and dbt

[thomada1SICKAG]

I tryed to initialize a new dbt project with sqlmesh as described. However, I thought that sqlmesh would use my connection setup from my profiles.yaml.
After starting the ui I know get the following error:
The TRINO engine cannot be used to store SQLMesh state - please specify a different state_connection engine. See https://sqlmesh.readthedocs.io/en/stable/reference/configuration/#gateways for more information.

Inside the documentation, it is not specified how to fix this error if you use sqlmesh with dbt and a trino connection.
So does someone allready faced the issue and know how to fix that ?

[georgesittas]

Hi @thomada1SICKAG,

As you have discovered, the Trino engine cannot be used to store SQLMesh's state. You'll need to modify your config.py file to specify a supported state connection, using sqlmesh_config's state_connection keyword argument:

# config.py, as generated by sqlmesh init trino --template dbt
from pathlib import Path

from sqlmesh.dbt.loader import sqlmesh_config

config = sqlmesh_config(Path(__file__).parent, state_connection=<fill this in>)

Here's an example that demonstrates how to configure a Postgres state_connection:

[georgesittas]

I've opened a PR to improve the documentation around this: #4253

[thomada1SICKAG]

Thank you !
After a deeper research, I found a way to set it up.