How to prevent data from being deleted in BigQuery dataset connected to a Google sheet

[xwen002]

"I have set up a BigQuery dataset that is linked to a Google Sheet, allowing users to input data into the sheet, which is then automatically synced to BigQuery. How can I prevent data in the BigQuery dataset from being deleted if users inadvertently delete data in the Google Sheet?"

[nceniza]

Are you preferring to Connected Sheets?  I can recommend utilising Access Controls that is mentioned here. 

A user with Google Sheets-only access can perform analysis in the sheet and use other Google Sheets features, but the user won't be able to perform the following actions:

• Manually refresh the BigQuery data in the sheet.
• Schedule a refresh of the data in the sheet.

---