build_query: Build a query for Google BigQuery from a text string

In opendoor-labs/projectmap: Project Map

Description

Takes a character string and concatenates some optional lines

Usage

build_query(query, standard = T, limit = NULL, show = F)

Arguments

query	A character string written in SQL language.
standard	Appends "#standardSQL" to the top if set to T. Default is F.
limit	Appends "LIMIT = 1000", for example, or whatever integer value limit is set to. Default is NULL and will not append anything.
show	A boolean (T, F) indicator of whether to print the query to the console for visualization.

Value

A character string.

Author(s)

Alex Hubbard ([e-mail])

Examples

query = "SELECT * FROM table"
build_query(query, standard = T, limit = 1000, show = T)

opendoor-labs/projectmap documentation built on Oct. 8, 2019, 1:58 p.m.