How do I connect a self-hosted GRIST to an SQL View also on our servers?

Just need a table, updated let’s say, once every 2 hours, with the info on construction jobs coming from another system.

I suppose best method would be to generate an SQL View and connect Grist to it?