Allow a business user to upload data from csv to a Google Big Query table

I am preparing a tableau dashboard that reads data from certain tables. One of the tables has data that is manually added on an ad-hoc basis. The data comes from the business side. Is there a way to allow the business user to upload the csv to the big query table without having them to do anything too technical?

As a workaround you can consider below methods:

1 Using Cloud Storage transfers:

In this method,first you need to submit a csv file to the cloud storage.Then you can set up a Cloud Storage transfer.This transfer service for cloud storage allows you to schedule recurring data loads from Cloud Storage to BigQuery.For more information you follow this link. But keep in mind that this service has some limitations.

2 Automate a Python script on Google Cloud.

There are different ways to automate a python script on google cloud. In your case,you can consider using a cloud function with cloud schedular to run your python code automatically.First you need to create a cloud function to run your code. Then you can use a cloud schedular to trigger your function automatically.In a more secure way you can use trigger cloud function indirectly by using pubsub. For more information you can follow this link.

There's not currently a user friendly way to import straight to an existing big query table from a csv. You could package your python script into a small application that allows the business user to select a file and then runs your python script to upload the csv to BQ.
I've had to do a similar solution.