readSQLtable: Read SQL from Databricks
In codonlibrary/disutils: Helpful functions from a healthcare perspective
Description
Usage
Arguments
Value
Description
Reading an SQL table from Databricks assumes that the user already has Databricks credentials
and access rights to a particular Databricks cluster.
Usage
1
2
readSQLtable(tableName, token, query = NULL, hostName = NULL,
httpPath = NULL)
Arguments
tableName
Name of the table to read.
token
DataBricks token. IT IS PERSONAL TO YOU.
query
SQL query. Default: "SELECT * FROM tableName"
hostName
Server host name. Default: "db.ref.core.data.digital.nhs.uk"
httpPath
HTTP path to the Databricks cluster. Default: "sql/protocolv1/o/0/rstudio-pilot"
Value
The SQL table.
codonlibrary/disutils documentation built on Nov. 4, 2019, 9:09 a.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Value
Description
Reading an SQL table from Databricks assumes that the user already has Databricks credentials and access rights to a particular Databricks cluster.
Usage
1 2 | readSQLtable(tableName, token, query = NULL, hostName = NULL,
httpPath = NULL)
|
Arguments
tableName |
Name of the table to read. |
token |
DataBricks token. IT IS PERSONAL TO YOU. |
query |
SQL query. Default: "SELECT * FROM tableName" |
hostName |
Server host name. Default: "db.ref.core.data.digital.nhs.uk" |
httpPath |
HTTP path to the Databricks cluster. Default: "sql/protocolv1/o/0/rstudio-pilot" |
Value
The SQL table.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.