How to Force Run a Specific Number of Rows in SQL

Owen E. · 2025-07-25T20:03:41.866Z

Is there a way to force run x amount of rows? I know you can run x amount of rows without forcing or force all rows but what about force x amount of rows

How to Force Run a Specific Number of Rows in SQL | Clay

7 comments

· Sorted by Oldest

Clay
APP
·
·
Yes, you can force run a specific number of rows. Right-click on the column, hover over Run Column, then select Choose Number of rows to run. You can specify both the number of rows to run and the starting row. This gives you control over exactly how many rows to force run, rather than being limited to all rows or none.
Source: Run Options
Owen E.
·
·
I dont think this force runs
Clay
APP
·
·
You're correct - the "Choose Number of rows to run" option doesn't force run rows. That method only runs rows that haven't been processed yet. To force run a specific number of rows, you need to: 1. Select the specific rows you want to force run by clicking and dragging to highlight them 2. Right-click on the selected rows 3. Choose "Run # of cells" from the context menu Alternatively, you can use the column header method but select "Force Run All Rows" instead, though this forces all rows rather than a specific number. The key difference is that force running will re-process rows even if they already have results, while the regular run options only process unrun rows.
Source: Run Options
Clay
APP
·
·
Hey Owen! Thanks for reaching out. You can try to display only those rows using the following option. Then when you click on the column header it will give you the option to force run x number of rows, x being the number of rows currently being displayed post applying the filter. This is a test table I created in my workspace as an example:
(901 kB)
Clay
APP
·
·
Also I would suggest opening only one ticker per issue and not multiple for the same issue to ensure we can get back to you fast and prevent any confusion!
Hasnain R.
·
·
Not directly Clay doesn’t support force run only X rows out of the box. But workaround: select the rows you want right-click → Run selected rows with force. That way you control exactly how many get force run.
Hari K.
·
·
Hey Owen! Wanted to check in and see if you were able to solve this?

Clay
APP
·
·
Yes, you can force run a specific number of rows. Right-click on the column, hover over Run Column, then select Choose Number of rows to run. You can specify both the number of rows to run and the starting row. This gives you control over exactly how many rows to force run, rather than being limited to all rows or none.
Source: Run Options
Owen E.
·
·
I dont think this force runs
Clay
APP
·
·
You're correct - the "Choose Number of rows to run" option doesn't force run rows. That method only runs rows that haven't been processed yet. To force run a specific number of rows, you need to: 1. Select the specific rows you want to force run by clicking and dragging to highlight them 2. Right-click on the selected rows 3. Choose "Run # of cells" from the context menu Alternatively, you can use the column header method but select "Force Run All Rows" instead, though this forces all rows rather than a specific number. The key difference is that force running will re-process rows even if they already have results, while the regular run options only process unrun rows.
Source: Run Options
Clay
APP
·
·
Hey Owen! Thanks for reaching out. You can try to display only those rows using the following option. Then when you click on the column header it will give you the option to force run x number of rows, x being the number of rows currently being displayed post applying the filter. This is a test table I created in my workspace as an example:
(901 kB)
Clay
APP
·
·
Also I would suggest opening only one ticker per issue and not multiple for the same issue to ensure we can get back to you fast and prevent any confusion!
Hasnain R.
·
·
Not directly Clay doesn’t support force run only X rows out of the box. But workaround: select the rows you want right-click → Run selected rows with force. That way you control exactly how many get force run.
Hari K.
·
·
Hey Owen! Wanted to check in and see if you were able to solve this?