Pull a BigQuery table (or filtered slice) as a data.frame.

Requires the bigrquery package and Application Default Credentials.

Usage

morie_datasets_bigquery(
  project,
  dataset,
  table,
  where = NULL,
  limit = NULL,
  select = "*",
  billing_project = NULL
)

Arguments

project

Source project (e.g. "bigquery-public-data").

dataset

Source dataset (e.g. "chicago_crime").

table

Source table (e.g. "crime").

where

Raw SQL WHERE clause (without leading WHERE).

limit

Optional integer LIMIT.

select

Projection list; defaults to "*".

billing_project

GCP project to bill; NULL uses ADC-discovered.

Value

A data.frame.