Icon

DB SQL - SQLite Data Types

<p>SQLite Connector - different type settings for NUMERIC and BIGINT</p>

URL: SQLite Connector - different type settings for NUMERIC and BIGINT - KNIME Forum (91129) https://forum.knime.com/t/sqlite-db-query-reader-ignores-numeric-string-mapping-and-loses-decimal-part/91129/5?u=mlauber71
URL: Hub: Play around with SQLite and Date and Time functions https://hub.knime.com/s/lr2kArL8kWy1rdfw
URL: Hub: DB SQL - SQLite - store and read JPEG Files in databases - also using Python https://hub.knime.com/s/l8rO_yQCsWZ3PmHt

Standard columns as NUMERIC Double → Number Float in the SQLite connector

https://forum.knime.com/t/sqlite-db-query-reader-ignores-numeric-string-mapping-and-loses-decimal-part/91129/4?u=mlauber71

PRAGMA table_info(activities);

SELECT * FROM sqlite_master WHERE type='table'

Data downloadable from:

https://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/releases/chembl_36/chembl_36_sqlite.tar.gz

Individual settings for Data Types

Standard columns as string plus individuual settings with column names

SQLite Connector - different type settings for NUMERIC and BIGINT

https://forum.knime.com/t/sqlite-db-query-reader-ignores-numeric-string-mapping-and-loses-decimal-part/91129/5?u=mlauber71

Size of whole database
DB Query Reader
all types
DB Query Reader
PRAGMA table_info(activities);
DB Query Reader
Path to String
Table Row to Variable
gives standard_valuecolumn as string
DB Query Reader
/data/*.db
List Files/Folders
URL to File Path
same query asDB Query Reader
DB Table Selector
connect to ChEMBL_V36SQLite databasedownloadable from:https://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/releases/chembl_36/chembl_36_sqlite.tar.gz
SQLite Connector
same query asDB Query Reader
DB Table Selector
extracted standard_activitydata spec = "NUMERIC"
DB Data Spec Extractor
same query asDB Query Reader
DB Table Selector
Number Format Manager
extracted standard_activitydata spec = "NUMERIC"
DB Data Spec Extractor
Number Format Manager
extracted standard_activitydata spec = "NUMERIC"
DB Data Spec Extractor
gives standard_valuecolumn as string
DB Query Reader
gives standard_valuecolumn as string
DB Query Reader
SELECT sqlite_version()
DB Query Reader
SELECT * FROM sqlite_master WHERE type='table'
DB Query Reader
Number Format Manager
connect to ChEMBL_V36SQLite databasedownloadable from:https://ftp.ebi.ac.uk/pub/databases/chembl/ChEMBLdb/releases/chembl_36/chembl_36_sqlite.tar.gz
SQLite Connector
PRAGMA compile_options
DB Query Reader
VACUUM;
DB SQL Executor

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: giovannicincilla
Created at: 2026-01-05
On NodePit since: 2026-01-08
Last update: 2026-01-08
Created with KNIME version: v5.9.0
Tags: SQLSQLiteNUMERICBIGINT

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

Try NodePit Runner!