Limiting DremioJDBC fetch size


We are using Dremio JDBC version 24.3.0 to connect Dremio from Tableau. While attempting to fetch data from Dremio to Tableau using Tableau Backgrounder, we have encountered an issue. The process is successful for tables with less than 490,000 rows. However, when dealing with tables exceeding 490,000 rows, the job fails.

Is there any way to limit the fetch size when using the Dremio JDBC driver?

Thank you for reviewing my question.

@YJKIM For external sources like MySQL, PG, Oracle you can go to the source settings (via Dremio UI), go to the advanced tab and configure fetch size