synq-sqlmesh

synq-sqlmesh is a client application to integrate locally running SQLMesh to Synq

How to use

If you have Golang installed, you can build the binary yourself, otherwise download appropriate binary from the releases screen (darwin == macOS).

synq-sqlmesh uses web module of sqlmesh to collect metadata. It was tested with versions >= 0.96.x. If you do not have web module installed do

pip install 'sqlmesh[web]

All commands assume sqlmesh command is available in the PATH. If that is not the case, --sqlmesh-cmd could be used to point synq-sqlmesh to proper location.

Dump metadata for inspection

cd sqlmesh-project
synq-sqlmesh collect meta.json

Automatic upload to Synq

export SYNQ_TOKEN=<token>
synq-sqlmesh upload

Advanced usage

❯ synq-sqlmesh --help
Small utility to collect SQLMesh metadata information and upload it to Synq

Usage:
  synq-sqlmesh [command]

Available Commands:
  collect     Collect metadata information from SQLMesh and store to the file
  upload      Collect metadata information from SQLMesh and send to Synq API

Flags:
  -h, --help                         help for synq-sqlmesh
      --sqlmesh-cmd string           SQLMesh launcher location (default "sqlmesh")
      --sqlmesh-project-dir string   Location of SQLMesh project directory (default ".")
      --sqlmesh-ui-host string       SQLMesh UI host (default "localhost")
      --sqlmesh-ui-port int          SQLMesh UI port (default 8080)
      --sqlmesh-ui-start             Launch and control SQLMesh UI process automatically (default true)
      --synq-endpoint string         Synq API endpoint URL (default "https://developer.synq.io/")
      --synq-token string            Synq API token

Use "synq-sqlmesh [command] --help" for more information about a command.

Building from source code

Make sure at least golang 1.21 is installed and do:

go generate
go build -o synq-sqlmesh
./synq-sqlmesh version