ChEMBL connect locally by KNIME
Had a play around with KNIME DB this time. Downloaded sqlite ChEMBL database from ChEMBL homepage. Then connected and made this simple sampling workflow.
All you need to do is unzip the ChEMBL sqlite file and set the Connector node almost default.
Many nodes available too...
What I like about KNIME-ing DB sqls is that you can see the output data clearly in each SQL statement. On the other hand SQL statement itself do tend to get mixed up and everything but doing it locally so I can test anything anyway. Wait, how do I just say "show tables;"... hmmmm.....
But I guess there is ChEMBL DB Schema in the ChEMBL homepage too
https://www.ebi.ac.uk/chembl/db_schema
So I guess I can just see this and figure out. WOW this db is complex!