Airbyte is an open-source data integration engine that helps you consolidate your data in your data warehouses, lakes and databases.

Airbyte

Hi, I'm trying to create a BigQuery destination but I'm getting this error message:
```2021-01-26 03:04:46 DEBUG (/tmp/workspace/66/0) DefaultCheckConnectionWorker(run):97 - Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@416cdada[status=failed,message=com.fasterxml.jackson.core.JsonParseException: Unexpected character ('-' (code 45)) in numeric value: expected digit (0-9) to follow minus sign, for valid numeric value
at [Source: (ByteArrayInputStream); line: 1, column: 3]]```
My `dataset ID` only contains letters whereas the `project ID` contains `-` ; I suspect that it's because the `project ID`  has `-` in its name? Is it not supported? Thanks. :slightly_smiling_face:

weird. we have a project id which also contains `-`

can you try copying and pasting your credentials json into the form again? i think this may be an issue where an extra character gets inserted by accident.

We resolved this issue today: <https://github.com/airbytehq/airbyte/issues/1745>

so it will be part of the new version. In the meantime charles suggestion will work.

that issue was closed because it was a duplicate.

i just recreated this issue though and if you copy and paste your credentials again it should work the second time.

logs-66-0.txt

Thanks, I'll try. :thumbsup:

This is the log file, by the way.

Hmm, unfortunately, it still fails. :thinking_face:

Yes, though, I was able to see the extra characters being added but I made sure to delete it. Just wondering where this is caught: `Unexpected character ('-' (code 45)) in numeric value: expected digit (0-9) to follow minus sign, for valid numeric value` . The only input I have `-` is the `project ID` and the key.

so what's possibly happening is that copying and pasting the credentials json isn't formatted quite right. this can be tricky to get right. let me share an example of what ours looks like with secrets redacted making sure we're both working with the same thing.

in the credentials json field you're copying and pasting a json blob that has this structure?

```{
  "type": "service_account",
  "project_id": "dataline-integration-testing",
  "private_key_id": "abcdefghijklmnopqrstuvwxyzabcdefhijklmnopqrst",
  "private_key": "-----BEGIN PRIVATE KEY-----\nasdfasdfasffasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasdfasfdasfasfdasfasfasdfasdfasdfasdfasdfasdfasdfasdfasfasdfasdfasdf==\n-----END PRIVATE KEY-----\n",
  "client_email": "<mailto:test-account@airbyte-integration-testing.iam.gserviceaccount.com|test-account@airbyte-integration-testing.iam.gserviceaccount.com>",
  "client_id": "1234567890123456",
  "auth_uri": "<https://accounts.google.com/o/oauth2/auth>",
  "token_uri": "<https://oauth2.googleapis.com/token>",
  "auth_provider_x509_cert_url": "<https://www.googleapis.com/oauth2/v1/certs>",
  "client_x509_cert_url": "<https://www.googleapis.com/robot/v1/metadata/x509/test-bigquery-user%40dataline-integration-testing.iam.gserviceaccount.com>"
}```

Yep.

Oh, shoot, just realized my mistake. There was just an issue with what I'm pasting. :sweat_smile:

Thanks for your help, though, I realized my mistake. :slightly_smiling_face: