How to add a new query on the website

First, go to a page Connect Google BigQuery and:
1. give access to a Google BigQuery (make sure you have activated BigQuery API in your Google Cloud project),
2. choose project that you want to be billed for a query being created,
3. write a name and create a query.

4. You will be taken to the query editor page. Write a query, for example you can query sample data:

SELECT
  corpus,
  count_corpus_words
FROM (
  SELECT
    corpus,
    COUNT(word) AS count_corpus_words
  FROM
    publicdata:samples.shakespeare
  GROUP BY
    corpus) AS sub_shakespeare
WHERE
  count_corpus_words > {corpusSize default="4000"}

5. Publish it.

Find more details about BigQuery's query syntax and functions.

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.