Only want report to load last 30 min of data in sql ?

I believe you could use a where condition which would be something like:

where submitted_datetime >= (current_timestamp - interval '30' minute)

Do let me know if it works!