Working with Tables and Data Frames - Teradata Package for R

Teradata® Package for R User Guide

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Package for R
Release Number
17.20
Published
March 2024
ft:locale
en-US
ft:lastEdition
2024-04-09
dita:mapPath
efv1707506846369.ditamap
dita:ditavalPath
ayr1485454803741.ditaval
dita:id
nqx1518630623256
lifecycle
latest
Product Category
Teradata Vantage

In this section, assume you have a connection with the name con to an Analytics Database as user "tdapUser", where the default database is "tdapUserDB".

See Testing Connection to Vantage with Teradata SQL Driver for R for details on how to set up a connection.

In the following examples, in addition to the "tdplyr" package, the "dplyr" and "dbplyr" packages are also needed. Start by loading these two packages in your R session, if they are not already loaded:

library(dplyr)
library(dbplyr)

Required Access Privileges on Vantage

Users must be granted the SELECT privilege to the following Data Dictionary views:
  • DBC.DatabasesV
  • DBC.TablesV
Granting the user this access privilege will allow the user to perform data preparation operations using the tdplyr package.