Need to pull a Google sheet through Datafusion.
There is some documentation but it does not provide a practical example of how to configure the fields.
Currently I am receiving a 403 Forbidden error in Directory Identifier, service account details space, though all access is provided.
The error you mention is related to Permissions. Service account should have the proper permission to read from Google sheet and then to write to BigQuery. This is one of the setups where the sheet needs to be shared with the service account or the user who wants to access it.
I guess you won't be able to provide the whole configuration so I will advise you to check Cloud Data Fusion Access Control Documentation to set proper permissions to your needs.
Also please be aware that there are still improvements in progress regarding CDAP Google drive/sheet plugins, which can be found here.
