Read all data from a SQL Table

Read all rows of data from a SQL table as either a dataframe stored in memory or as a lazy tibble.

Usage

read_table(conn, database, schema, table, lazy = FALSE)

Arguments

conn

A DBIConnection object, as returned by DBI::dbConnect().

database

Name of database or catalog.

schema

Name of schema.

table

Name of table.

lazy

Bool with default value FALSE indicating a tibble in memory will be returned to the user. TRUE specifies that a lazy tibble will be returned.

Value

Tibble or lazy tibble.

See also

Other basics: append_table(), create_table(), nuke_table(), overwrite_table(), survey_table(), truncate_table()

Examples

if (FALSE) { # \dontrun{
read_table(
  conn = my_connection,
  database = "my_database",
  schema = "my_schema",
  table = "my_table",
  lazy = FALSE
)
} # }