R

Print
Dark
Light

Article summary

Did you find this summary helpful?

Thank you for your feedback!

Doorda R SDK

This package interacts with Doorda Hosted service on Presto for query execution.

Features

Simplified Functions
Progress Bar when executing queries

Installation

install.packages("devtools")
require("devtools")
devtools::install_github("doorda/doorda-r-sdk", dependencies=TRUE)

Create Connection

library('DBI')
library("DoordaHostSDK")
conn <- dbConnect(DoordaHost(),
          user='username',
          password='password',
          catalog='catlog_name',
          schema='schema_name')

Check Database Connection

isConnected(conn)

Query Database

results_df = dbQuery(conn, "SELECT * FROM table_name")

Get Catalog Names

catalog_names = showCatalogs(conn)

Get Schema Names

schema_names = showSchemas(conn)

Get Table Names

table_names = showTables(conn)

Get Table Stats (Currently only number of rows supported)

table_stats = getTableStats(conn, "table_name")

Get Column Names of Tables

column_names = dbListFields(conn, "table_name")

R