bqr_query: Query a BigQuery Table

In MarkEdmondson1234/bigQueryR: Interface with Google BigQuery with Shiny Compatibility

Description

MaxResults is how many results to return per page of results, which can be less than the total results you have set in your query using LIMIT. Google recommends for bigger datasets to set maxResults = 1000, but this will use more API calls.

Usage

bqr_query(projectId, datasetId, query, maxResults = 1000,
  useLegacySql = TRUE)

Arguments

projectId	The BigQuery project ID
datasetId	A datasetId within projectId
query	BigQuery SQL
maxResults	Max number per page of results. Set total rows with LIMIT in your query.
useLegacySql	Whether the query you pass is legacy SQL or not. Default TRUE

Value

a data.frame. If there is an SQL error, a data.frame with additional class "bigQueryR_query_error" and the problem in the data.frame$message

See Also

BigQuery SQL reference

Examples

## Not run: 

bqr_query("big-query-r","samples",
          "SELECT COUNT(repository.url) FROM [publicdata:samples.github_nested]")


## End(Not run)

MarkEdmondson1234/bigQueryR documentation built on May 7, 2019, 2:53 p.m.