BigQueryType.fromStorage to ingest default project_ids

[patrick-wu]

Context

At my organization, we have separate GCP projects for sandbox, QA and prod, and they all contain identical schemas of datasets & tables on BigQuery. This means that if we were to take advantage of BigQueryType.fromStorage's cost-effectiveness, ideally we should pass in table specs without projectIds and have it inferred via a compile time argument.

When i try to compile with projec-id-less table specs, the macro expansion fails in the following manner:

/...Schemas.scala:29:6: exception during macro expansion: io.grpc.StatusRuntimeException: 

INVALID_ARGUMENT: 'x-goog-request-params' header value 'table_reference.project_id=&table_reference.dataset_id=my_dataset' is invalid.
[error]     @BigQueryType.fromStorage(

which seems like an empty project ID is used to build the dry run request.

Suggested feature

Is it possible to use a compiled argument, like -Dbigquery.project, somewhere within the StorageImpl section of the type provider to fill in as a default project id?