Import a dataset using BigQuery Query.

dai.create_dataset_from_bigquery(
  dataset_id,
  destination,
  query,
  progress = getOption("dai.progress", TRUE)
)

Arguments

dataset_id

Name of BQ Dataset to use for tmp tables

destination

destination filepath within GCS (gs://<bucket>/<file.csv>)

query

SQL query to pass to BQ

progress

Whether to display a progress bar.

Value

DAIFrame representing the dataset.

Details

Find more details about how to enable data connectors in the documentation.

Examples

# \donttest{
data <- dai.create_dataset_from_bigquery('h2o_bigquery_demo', 'gs://h2o-bq-large-dataset/unit_test.csv',
                                         'SELECT * FROM h2o_bigquery_demo.cc_train')
# }