This is an old revision of the document!
Table of Contents
Snowflake Support in OHDSI tools
This page has a list of branches in repositories to be merged into the corresponding ‘master’ branches and officially released in the upcoming future (targeting ATLAS/WebAPI 2.12 release in August / September 2022)
To enable Snowflake support before the official release across all repositories, please build the environment utilizing the branches listed below. After all components are released they can use the officially released versions of each particular component or then whole stack as the dependencies should be properly referenced:
- OMOP CDM - Snowflake OMOP CDM DDL scripts can be found there
- DatabaseConnector - an R package to connect to a Snowflake database
- SqlRender - an R package to translate OHDSI SQL to the Snowflake dialect
- Achilles - an R package which provides descriptive statistics for a Snowflake OMOP CDM database
- ARACHNE Commons (a common component used by ATLAS/WebAPI and ARACHNE to share common code)
- ArachneCommons - for WebAPI/ATLAS, this is the primary dependency
- ArachneCommons - for ARACHNE Execution Engine
- ARACHNE Execution Engine - an application used to execute SQL and R code provided by ATLAS/WebAPI (Patient Level Prediction (PLP), Population Level Effect Estimation (PLE) analyses or ARACHNE Data Node
- WebAPI - a centralized API to perform analytical work on Snowflake OMOP CDM databases
- ATLAS - a web application helps researchers to analyze Snowflake OMOP CDM data and make decisions based on the analyses results
Known Limitations
DatabaseConnectorJars will be updated with the new dialect support information when the DatabaseConnector branch is officially released with the corresponding dialect

