Connection problem with bigquery

  • 14 June 2022
  • 1 reply

Hello, I need to export the mixpanel database to bigquery for deeper analysis.

Only when I try to create the pipeline, with this script,

curl --request POST \

     --url \

     --header 'Accept: application/json' \

     --header 'Authorization: Basic ...' \

     --header 'Content-Type: application/x-www-form-urlencoded' \

     --data trial=false \

     --data data_source=events \

     --data frequency=daily \

     --data data_format=json \

     --data schema_type=monoschema \

     --data sync=false \

     --data type=bigquery \

     --data project_id=2722956 \

     --data from_date=2022-06-01 \

     --data bq_region=US \

     --data \

     --data gcp_project=scrapyomama-335508 \

     --data bq_dataset_name=mixpanel

I have the following error 412 message:

{"Error":"failed creating dataset: bigquery: invalid access value"}

However, I have followed all the indications recommended for sharing rights on bigquery.

Do you know what I'm doing wrong?

thanks in advance

1 reply

Userlevel 5
Badge +5

Hi @mrsoyer are you able to write to with this?