we have a table in DWH which is source to downstreams.I want to block select from the table when we are inserting/truncating or doing maintanance of the table.

what happens is that if communication is not proper,somtimes downstreams just use this table when there is no data,and get surprising results.

in this scenario when the table is not to be used,can we just put a exception message to them when ever they run select...