Parsing Dataset names in BigQuery

[ChristopheDuong]

Tell us about the problem you're trying to solve

When specifying a Dataset_id, the Google UI often includes the project_id in its naming like this: project_id:dataset_id

Describe the solution you’d like

In the BigQuery destination code, we could accept both syntax:

• project_id:dataset_id
• dataset_id

So it's smoother for the end user whether project_id is specified or not?

Additional context

Add any other context or screenshots about the feature request here.

Example setup from a user in slack:
https://airbytehq.slack.com/archives/C019WJFR1JT/p1607060567071700?thread_ts=1607060325.069200&cid=C019WJFR1JT

┆Issue is synchronized with this Asana task by Unito