What if my source is in a different database to my target database?

Use the database property to define the database that the source is in.

models/<filename>.yml

version: 2

sources:
  - name: jaffle_shop
    database: raw
    tables:
      - name: orders
      - name: customers