As an example, if somebody tries to run a pipeline with big query sink on their laptop with a service account key specified but project id as 'auto-detect', the pipeline will fail with some 403 exception in the logs about some project number.
In this scenario, it is incorrect configuration, as the project id of the dataset must be specified if it can't be picked up from the environment. The plugin should check that at prepare time and error with a nice message, something like
'The project ID could not be detected from the environment. Please specify the project ID'