Hi everybody,
I tried to work with a Google BigQuery Metadata and I have some difficulties in reversing tables.
The BigQuery Metadata has already been configured (by other persons) and some of my coworkers succeeded in reversing tables in the past.
To be sure of the configuration, I cheked all the points listed in this webpage
www.stambia.org/doc/189-technology-artic...with-google-bigquery
So, I have BigQuery connector and JDBC drivers installed in Designer.
The metadata is well configured with appropriated driver, credentialsFile and projectId
We have different Configuration and I have also cheked the configuration in different fields.
The connection can be etablished in
Connection window.
In
Properties window, I can also refresh "
Catalog Name" and "
Schema Name".
I suppose that proved all the login keys like credentialsFile and projectId corresponded were correct.
For information, I can execute loading mapping from tables formerly reversed from BigQuery to more traditional SQL DBMS
But when I tried to reverse for new tables, I have following error message after waiting a while during "
Operation in progress..." window
"com.google.cloud.bigquery.BigQueryException:Error getting access token for service account:"
Can anyone help me ?
Thanks a lot.
