Learn R Programming

sqltargets (version 0.3.0)

tar_sql_deps: List SQL query dependencies.

Description

List the target dependencies of one or more SQL queries.

Usage

tar_sql_deps(path)

Value

Character vector of the names of targets that are dependencies of the SQL query.

Arguments

path

Character vector, path to one or more SQL queries.

Examples

Run this code
lines <- c(
  "-- !preview conn=DBI::dbConnect(RSQLite::SQLite())",
  "-- targets::tar_load(data1)",
  "-- targets::tar_read(data2)",
  "select 1 as my_col",
  ""
)
query <- tempfile()
writeLines(lines, query)
tar_sql_deps(query)

Run the code above in your browser using DataLab