Hello, I'm trying

tap-facebook-pages

(voxmedia) with docker, when I run

config tap-facebook-pages test

, meltano is asking for GOOGLE_APPLICATION_CREDENTIALS:

Plugin configuration is invalid
google.auth.exceptions.DefaultCredentialsError: Could not automatically determine credentials. Please set GOOGLE_APPLICATION_CREDENTIALS or explicitly create credentials and re-run the application. For more information, please see <https://cloud.google.com/docs/authentication/getting-started>

So I got an API key, I put it in the .env and got:

Plugin configuration is invalid
google.auth.exceptions.DefaultCredentialsError: File AIzaSyCdOacK5PwyDBxczt74wV84VOCKh6AQkKw was not found.

I understand that meltano is expecting a json, but what must be inside? But, isn't there a way to recover the data in a json? (I think is for storing the data this google part). Any help much appreciated EDIT: when running

meltano run tap-facebook-pages target-jsonl

I'm still getting the same error:

2023-01-13T19:08:46.131099Z [info     ] google.auth.exceptions.DefaultCredentialsError: Could not automatically determine credentials. Please set GOOGLE_APPLICATION_CREDENTIALS or explicitly create credentials and re-run the application. For more information, please see <https://cloud.google.com/docs/authentication/getting-started> cmd_type=elb consumer=False name=tap-facebook-pages producer=True stdio=stderr string_id=tap-facebook-pages

EDIT 2: I set the variable

GOOGLE_APPLICATION_CREDENTIALS

in the .env and put the corresponding json. Now I get the error:

google.api_core.exceptions.Forbidden: 403 Access Denied: Table g9-data-warehouse-prod:facebook_posts.most_recent: User does not have permission to query table g9-data-warehouse-prod:facebook_posts.most_recent, or perhaps it does not exist in location US.

Apparently is querying a table that does not exist. I don't understand why is querying the database when I'm using the loader target-jsonl. It seems this tap is unusable.