Querying Databases

This workflow demonstrates how to query a database to aggregate and filter data and join two database tables.

In this example, the contracts data (~50K rows) are aggregated and filtered to find the products with more than 10K contracts. After that, for these popular products the contracts number is joined to other products data (price, terms). The processing (aggregation, filtering, and joining) happens on the database, and only the small final table (3 rows) is imported into KNIME