Direct export
With Allow data export without approval on (Settings > General, SQL Editor section — the workspace default), anyone who can run a query can click Export on the result to download it — exporting is not a separate permission. See Export data for how Export behaves.Just-in-time data export
To put every export behind an approval, a Workspace Admin turns off Allow data export without approval; members can then no longer export directly. As long as Allow access grants is enabled on the project, they can still export through the access grant mechanism:-
Click Request export on the query result. The Request access grant drawer opens with Export pre-checked; you can also check Export in any access grant request.

-
The approver sees on the request issue that the grant allows exporting the result.

- Once approved, run the approved statement and export its result before the grant expires.
export: Yes) to narrow the list to export grants; an expired grant can be re-requested from there.


