How can we run DB QUERY node without LIMIT Clause?

[mlauber71]

@SnigdhaBiswas the DB Query creates a VIEW. If you want the data you will have to use the:

DB Reader

You can also execute ‘pure’ SQL commands that would then send commands to the database directly:

Example how to use H2 database to create table with upload and from scratch –...

[L4-BD] exercise 1 odyssey

@Thiemo.Kellner my suggestion would be to toy around with this workflow to see various functions and how they would work: [image] The ‘brown’ database connections are indeed a combination of SQL VIEWS that are put together without optimization (that would be the job of the database). I would assume this is because they are meant to function across a large number of databases and the combinations could be quite extensive (think: Hive, Impala, Big Data). So like with every database the user w…