How to Use LifeScale

Accessing LifeScale

LifeScale can be accessed via any web browser from any device on the medical network, from anywhere in the world on a medical center device via the medical center VPN, or from anywhere in the world on nearly any device using Horizon.

Google Chrome is the recommended browser.

Log in using your medical center userID and password.

Once logged in, you can view the available tables comprising the LifeScale Core Data under ‘filteredaccessx’.

Analysis Tools in LifeScale

Within the Databricks environment, you can use Python, R, SQL and Scala.

Guidelines for Saving Data, Files and Notebooks

To assist you and your team in efficiently utilizing the Databricks system, we recommend referring to the following links for detailed instructions on saving data, files, and notebooks:

1. Delta Tables Tutorial: This tutorial provides comprehensive guidance on working with Delta Lake, including creating and managing Delta tables, which are the default table format in Databricks.​
2. SQL Reference for Volumes: The SQL reference for volumes offers insights into leveraging volumes for storage within the Databricks environment.
3. Unity Catalog Volumes Documentation: Unity Catalog Volumes enable governance over non-tabular datasets by representing logical storage units in cloud object storage. This documentation explains how to create and manage volumes for organizing and storing files within Databricks.

Instructional Videos

These videos are stored in an OSUWMC system requiring medical center credentials for access.

• LifeScale Alpha Researchers Instructional
• LifeScale Beta Researchers Instructional 
• Microsoft Azure Databricks Help Office Hours (11/15/23) 
• Microsoft Azure Databricks Help Office Hours (11/29/23) 
• Microsoft Azure Databricks Help Office Hours (12/13/23) 
• Microsoft Azure Databricks Help Office Hours (12/20/23) 
• Microsoft Azure Databricks Help Office Hours (1/17/24) 
• Microsoft Azure Databricks Help Office Hours (2/22/24)