[BUG][bigquery] --schema not working for underscore on bigquery

[daja93]

Describe the bug
Selection of --schemas does not work for schemas with underscore. The link to get metadata about the schema from bigquery seems not understood by bigquery

To Reproduce
Steps to reproduce the behaviour:

1. Run dbt-coves generate sources --schemas name_with_underscore

Expected behaviour
Generation of the selected schema

Console Log/Tracebacks
https://bigquery.googleapis.com/bigquery/v2/projects/my_project/datasets/%22name_with_underscore%22/tables?maxResults=100000&prettyPrint=false: Invalid dataset ID ""name_with_underscore"". Dataset IDs must be alphanumeric (plus underscores and dashes) and must be at most 1024 characters long.

Desktop (please complete the following information):

dbt-coves 1.6.26

python 3.11