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.
To upload data.frame from R, there are two options:
If you want to use embulk, ensure you’ve installed embulk and set PATH for it.
You can install via devtools::install_github for the
latest development version.
install.packages("devtools") # Install devtools if needed
devtools::install_github("treasure-data/RTD@v0.4.0")Or, you can use install-github.me instead like:
source("https://install-github.me/treasure-data/RTD@v0.4.0")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")