Skip to contents

get_table(db_name, tbl_name)

get_table.Rd

Retrieve a dataset defined by a table name.

Usage

get_table(db_name = "Elmer", schema, tbl_name)

Arguments

db_name

String. The name of the database to run the query against. Should be "Elmer" or "ElmerGeo". Default = "Elmer".

schema

String. The name of the schema that the table exists in. No default.

tbl_name

String. The name of the table to be retrieved. No default.

Value

A data frame.

Examples

get_table(schema = 'chas', tbl_name = 'tenure_dim')
#>   tenure_dim_id          created_at          updated_at
#> 1             1 2021-01-08 14:47:29 2021-01-08 15:07:17
#> 2             2 2021-01-08 14:47:29 2021-01-08 15:07:17
#> 3             3 2021-01-08 14:47:29 2021-01-08 15:07:33
#>                     tenure_name tenure_order
#> 1                Owner occupied            1
#> 2               Renter occupied            2
#> 3 Total: Occupied housing units            0