I would like to know the correct way to copy production data into a staging environment which can be used for all downstream tasks.
We are using GCP & Bigquery and we have the two environments as separate GCP projects. Currently I have a conditional in my sources, which copies all the prod data over.
I recently saw dbt clone and would like to leverage this instead but cannot find a complete guide on how to best set this up. Ideally this setup would also include how to the execute CI tests against any new PRs into the dbt models.
Thanks in adance!