sql.index

Get a list of tables from the SQL database

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.index function

<dl><dt>schema</dt>
<dd>Optional schema name to filter tables</dd></dl>

Arguments

Get a list of tables from the SQL database — sql.index

<dl>

<dt>schema</dt>
<dd>Optional schema name to filter tables</dd>

</dl>

Get a list of tables from the SQL database

sql.index: Get a list of tables from the SQL database

Description

Usage

Value

Arguments