(…)
with the appropriate connection details for both the PostgreSQL and Snowflake instances. More details on adding peers are available here.
updated_at BETWEEN {{.start}} AND {{.end}}
in the SELECT statement provides input to PeerDB on which part(s) of the query should be scoped by the watermark column for the rows to be synced.localhost:8085
to gain full visibility into the different jobs and steps that PeerDB performs under the hood to manage the MIRROR.