Icon

Fetch_​Data_​from_​Database

Fetch Data from Database
Fetch Data From DatabaseThis example workflow shows how to retrieve data from SQLite database. Specifically, it shows howto select columns from a table and get records matching a specific condition. NOTE: Only the records satisfying the combined query conditions are retrieved from the databaseand they are retrieved only once by the DB Reader Node at the end of the workflow. genes.sqliteselect * from human_genesexclude columns Transcript stable ID &Protein stable IDfilter for Chromosome = 21ANDGene type = "protein_coding"get query results as a KNIME table SQLite Connector DB Table Selector DB Column Filter DB Row Filter DB Reader Fetch Data From DatabaseThis example workflow shows how to retrieve data from SQLite database. Specifically, it shows howto select columns from a table and get records matching a specific condition. NOTE: Only the records satisfying the combined query conditions are retrieved from the databaseand they are retrieved only once by the DB Reader Node at the end of the workflow. genes.sqliteselect * from human_genesexclude columns Transcript stable ID &Protein stable IDfilter for Chromosome = 21ANDGene type = "protein_coding"get query results as a KNIME table SQLite Connector DB Table Selector DB Column Filter DB Row Filter DB Reader

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Temesgen H. Dadi
Created at: 2020-07-29
On NodePit since: 2021-12-18
Last update: 2024-04-28
Created with KNIME version: v4.3.1
Tags: Life SciencesDatabaseSQLite

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!