Hello everybody! I try to use target-bigquery, but...
# troubleshootingp
pablo_azofeifa
10/12/2023, 4:14 PMHello everybody! I try to use target-bigquery, but I get this error:
• google.api_core.exceptions.Forbidden: 403 POST. Access Denied: Dataset project_iddataset id Permission bigquery.tables.create denied on dataset project_id:dataset_id (or it may not exist).
Someone know what is the problem?
I change the method for batch_job and increase the amount of the batch_size but I get the same error.
This is my config in meltano.yml:
e
edgar_ramirez_mondragon
10/12/2023, 8:35 PMCan you confirm that you can create tables in that dataset?
p
pablo_azofeifa
10/12/2023, 9:24 PMWhat's means the creation of tables?
To give you a context, I try to create a pipeline with a tap-intacct (is a custom tap that get data from CSV files in a bucket in S3) with target-bigquery. So the idea is to move the data from S3 bucket to Big Query.
The tap-intacct works in a pipeline with target-csv, and get all the files in the bucket.
p
prakhar_srivastava
10/12/2023, 9:33 PMthis is a permission error, can you check if you can create a table usinf these credential either via api or some other methid
p
pablo_azofeifa
10/12/2023, 9:46 PMI can create a table directly from the console of Google Cloud, I assume that the credentials are Ok but doesn't work with the target?