RStudio

The familiar RStudio desktop but on the web.

Inside the hospital network, we've deployed instances of RStudio server per researcher from GAE13. You can access with an address like:

http://uclvlddpragae13:908X

x will be a number unique to you. You'll also need your RStudio username and password (ask one of the RSE team).

When you start a new session, you should see

utilities.R successfully loaded from /workspace/scripts/utilities.R

at the end of the console output. It's sourced from your .Rprofile.

Simply run the following to connect to the data lake:

con <- connect_to_ducklake()

You can then interact with the data using the DuckDB R package. For example

dbExecute(con, "SHOW ALL TABLES;")
first10 <- dbGetQuery(con, "SELECT * FROM camino.bronze.Organisms LIMIT 10")
print(first10),

See also