Exercise21
Chapter 2 / Exercise 2
Reads dataset cars-85 from KCBBook.sqlite DB, prepared in exercise1.
The goal of this exercise is to read data from a database and practice a bit of in-database processing with database nodes and SQL queries.
To read the database start with a connector node, either the generic DB Connector node or the dedicated SQLite Connector node.
Pre-process the dataset with database nodes or SQL queries as follows:
1. exclude 'symboling' and 'normalized losses'
2. keep only bmw and audi cars
Nodes
- DB Column Filter (Labs)2 ×
- DB Reader (Labs)2 ×
- DB Table Selector (Labs)2 ×
- DB Connector (Labs)1 ×
- DB Query Reader (Labs)1 ×
- Show all 11 nodes
Extensions
Links
- No links available