I hereby claim:
- I am vinayaugustine on github.
- I am vinaya (https://keybase.io/vinaya) on keybase.
- I have a public key whose fingerprint is E280 CC65 6D27 8007 6488 EE21 07B0 0EB2 C1ED 15CA
To claim this, I am signing this object:
I hereby claim:
To claim this, I am signing this object:
<?xml version="1.0" encoding="utf-8"?> | |
<!-- | |
Copyright (c) 2014 ABB Group | |
All rights reserved. This program and the accompanying materials | |
are made available under the terms of the Eclipse Public License v1.0 | |
which accompanies this distribution, and is available at | |
http://www.eclipse.org/legal/epl-v10.html | |
Contributors: | |
* Vinay Augustine (ABB Group) - initial API, implementation, & documentation |
I hereby claim:
To claim this, I am signing this object:
from google.cloud import bigquery | |
client = bigquery.Client() | |
query = ( | |
"SELECT feedback_record_id,feedback_records.body AS body,human_assigned_category,machine_assigned_category,ruf_categorizations.updated_at AS updated_at " | |
"FROM `uservoice-001.biglog.feedback_record_ruf_categorizations` AS ruf_categorizations " | |
"LEFT JOIN `uservoice-001.biglog.feedback_records` AS feedback_records " | |
"ON ruf_categorizations.feedback_record_id = feedback_records.id " | |
"WHERE human_assigned_category IS NOT NULL AND body IS NOT NULL AND CHAR_LENGTH(TRIM(body)) > 0 " | |
"ORDER BY feedback_record_id" |