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