Simple TD API Client

Upload R data.frame to Arm Treasure Data, see < https://www.treasuredata.com/>. You can execute database or table handling for resources on Arm Treasure Data.

RTD

RTD is an official R client for Arm Treasure Data. It aims to make it simple to handle or connect from R to TD.

Since RTD covers only basic execution on TD, we recommend to use RPresto or RJDBC for querying.

Requirements

To upload data.frame from R, there are two options:

embulk
bulk-import

If you want to use embulk, ensure you've installed embulk and set PATH for it.

Install

As of version 0.4.1, RTD has been back to CRAN. You can install RTD as:

install.packages("RTD")

You can install via devtools::install_github for the latest development version.

install.packages("devtools") # Install devtools if needed
devtools::install_github("treasure-data/[email protected]")

Or, you can use install-github.me instead like:

source("https://install-github.me/treasure-data/[email protected]")

Example

See also RTD_example.Rmd or RPubs.

library(RTD)

client <- Td(apikey=Sys.getenv("TD_API_KEY"), endpoint=Sys.getenv("TD_API_SERVER"))

# Show list of databases
list_databases(client)

# Create database
create_database(client, "test")

# Craete table
create_table(client, "test", "example")

# Delete table
delete_table(client, "test", "example")

# Upload data.frame. Target database and table will be created automatically.
td_upload(client, "test", "mtcars", mtcars)

# Drop database
delete_database(client, "test")