Skip to content

Instantly share code, notes, and snippets.

@Veenap

Veenap/Executing queries on the BigQuery data with R

Created August 6, 2020 03:25
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Veenap/f887f4a96b6e0590b6e156b27c609fb5 to your computer and use it in GitHub Desktop.
Save Veenap/f887f4a96b6e0590b6e156b27c609fb5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Executing queries on the BigQuery data with R
#import library
library(bigrquery)
#Your project ID here
project_id <- "your-project-id" # Your project ID goes here
#Sample query
sql_string <- "SELECT * FROM dataset.my_table LIMIT 1000"
#Execute the query and storing the result
query_results <- query_exec(sql_string, project = project_id, useLegacySql = FALSE)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment