# Unable to output to BigQuery
**URL:** https://discuss.elastic.co/t/unable-to-output-to-bigquery/81694
**Category:** Logstash
**Created:** [April 8, 2017, 11:13pm UTC](https://discuss.elastic.co/t/unable-to-output-to-bigquery/81694 "2017-04-08T23:13:05Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Filipe\_Ferminiano\_Ro](https://discuss.elastic.co/u/Filipe_Ferminiano_Ro)
#### Post date: [April 8, 2017, 11:13pm UTC](https://discuss.elastic.co/t/unable-to-output-to-bigquery/81694/1 "2017-04-08T23:13:05Z")
I'm trying to send logstash data to BigQuery with this plugin:
[https://www.elastic.co/guide/en/logstash/current/plugins-outputs-google\_bigquery.html#plugins-outputs-google\_bigquery-csv\_schema](https://www.elastic.co/guide/en/logstash/current/plugins-outputs-google_bigquery.html#plugins-outputs-google_bigquery-csv_schema)
The files are being written in tmp\_files folder, but I'm seeing no data in Big Query and I see no error in Big Query console.
This is my logstash conf file:
```
input
{
http
{
host => "0.0.0.0"
port => 31311
}
}
filter
{
grok {
match => { "id" => "%{URIPARAM:id}?" }
}
kv
{
field_split => "&?"
source => "[headers][request_uri]"
}
}
output
{
google_bigquery
{
codec => "plain"
project_id => "..."
dataset => "logs"
csv_schema => "message:STRING,version:INTEGER,timestamp:TIMESTAMP,type:STRING,host:STRING,path:STRING"
key_path => "abc.p12"
service_account => "123-compute@developer.gserviceaccount.com"
temp_directory => "/tmp/logstash-bq"
temp_file_prefix => "logstash_bq"
date_pattern => "%Y-%m-%dT%H:00"
flush_interval_secs => 2
uploader_interval_secs => 15
deleter_interval_secs => 15
}
stdout { codec => rubydebug }
}
```
What am I missing? And how to fix?
---
### Author:  [@system](https://discuss.elastic.co/u/system)
#### Post date: [May 6, 2017, 11:19pm UTC](https://discuss.elastic.co/t/unable-to-output-to-bigquery/81694/2 "2017-05-06T23:19:32Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.