How To Interact With Database Tables From R Development Environment and Jupyter Notebook

Learn what commands to use to interact with database tables in the R Development Environment and Jupyter Notebook apps in your workspace.

9 steps

Aridhia

Using **R Development Environment**, you can import or export data tables stored in the workspace in one of two ways:\ Using a XAP function like in the below image: [[dataset <- xaputils::\[xap.read_table("dataset_name")]]

Or by using the DBI library: [[dataset <- dbReadTable(xaputils::xap.conn, "dataset_name")]]

To list all the tables and database views in the current workspace, run:[[xaputils::xap.list_tables()]]

The following XAP function writes a data frame to a table in the "**Database**" tab. Note if a database table with that name already exists, the function will overwrite it: [[xaputils::xap.db.writeframe(dataset, "dataset_name")]]\ \ Note: if a database table with that name already exists, **the function will overwrite it**.

Alternatively, you can use the DBI library to do this: [[dbWriteTable(xaputils::xap.conn, "dataset_name", dataset)]]

XAP is an R package for interfacing with the workspace from the Built-in Apps.\ You can display the full list of platform-specific functions by running: [[library(xaputils)]] [[ls("package:xaputils")]]

To install other packages after running this command, you need to detach the xaputils package as its method of installation is not compatible with the package manager: [[detach(package:xaputils,unload=TRUE)]]

If you want to learn more about a specific XAP function, you can print out its documentation in the Built-in Apps:\ \ [[?xap.name_of_function]]

For similar documentation regarding the **Jupyter Notebook** app, you can find guidance on the [Using your Jupyter Notebook App](https://knowledgebase.aridhia.io/workspaces/analysing-data/apps/using-your-jupyter-notebook-app) knowledge base article.