sql.desc

A comprehensive data analysis framework for NIH-funded research that streamlines workflows for both data cleaning and preparing NIH Data Archive ('NDA') submission templates. Provides unified access to multiple data sources ('REDCap', 'MongoDB', 'Qualtrics') through interfaces to their APIs, with specialized functions for data cleaning, filtering, merging, and parsing. Features automatic validation, field harmonization, and memory-aware processing to enhance reproducibility in multi-site collaborative research as described in Mittal et al. (2021) <doi:10.20900/jpbs.20210011>.

Joshua G. Kenney

wizaRdry

A Magical Framework for Collaborative & Reproducible Data
Analysis

Trevor F. Williams

Minerva K. Pappu

Michael J. Spilka

Danielle N. Pratt 

Victor J. Pokorny

Santiago Castiello de Obeso

Praveen Suthaharan

Christian R. Horgan

sql.desc function

<dl><dt>table_name</dt>
<dd>Name of the table to get metadata for</dd></dl>

Arguments

Get SQL table columns/metadata — sql.desc

<dl>

<dt>table_name</dt>
<dd>Name of the table to get metadata for</dd>

</dl>

Get SQL table columns/metadata

sql.desc: Get SQL table columns/metadata

Description

Usage

Value

Arguments