Is it possible to override the default table name set by target-bigquery? I would like to be able to dynamically pass a env variable as the table name

Yes, using stream maps. Not sure whether Meltano will expand env vars in stream map config like it does in other places - see https://docs.meltano.com/guide/configuration/#environment-variable-expansion.

Ah great, just stumbled across this. Will try env in that location and report back. Thanks 👍