# Google BigQuery Output Plugin Authentication Issue

**URL:** https://discuss.elastic.co/t/google-bigquery-output-plugin-authentication-issue/100598
**Category:** Logstash
**Created:** [September 14, 2017, 7:38pm UTC](https://discuss.elastic.co/t/google-bigquery-output-plugin-authentication-issue/100598 "2017-09-14T19:38:07Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![jeremytoce](https://avatars.discourse-cdn.com/v4/letter/j/bbe5ce/32.png) [@jeremytoce](https://discuss.elastic.co/u/jeremytoce)
#### Post date: [September 14, 2017, 7:38pm UTC](https://discuss.elastic.co/t/google-bigquery-output-plugin-authentication-issue/100598/1 "2017-09-14T19:38:07Z")

</div>

Hey all - I am struggling a bit with authenticating BigQuery for Logstash output use.

I have an issue that I am sure is a matter of clarification, but haven't been able to solve for several days.

I am receiving an invalid key or passphrase error, even though I have confirmed that the key and passphrase are indeed correct and it is my active service account. I have tried regenerating my service account credentials, but to no avail. Here is my configuration file:

```
# The # character at the beginning of a line indicates a comment. Use
# comments to describe your configuration.
input {
	beats {
    	port => "5043"
	}
}
# The filter part of this file is commented out to indicate that it is
# optional.
filter {
grok {
    match => { "message" => "%{COMBINEDAPACHELOG}"}
}
}
output {
   google_bigquery {
 project_id => "leanplum-staging"                          
 dataset => "test-arr-digest"                                         
 csv_schema => "path:STRING,status:INTEGER,score:FLOAT"
 key_path => "/company-07ed8561600a.p12"                 
 key_password => "notasecret"                            
 service_account => "test-arr-digest@company.iam.gserviceaccount.com" 
  }
}

```

And my error message is "Pipeline aborted due to error {:exception=\>#\<ArgumentError: Invalid keyfile or passphrase\>"

Thanks in advance for the assistance!

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [October 12, 2017, 7:38pm UTC](https://discuss.elastic.co/t/google-bigquery-output-plugin-authentication-issue/100598/2 "2017-10-12T19:38:45Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.