python - CRUD web application with Bigquery?

Question

I have a bigquery table about 200 rows, i need to insert,delete and update values in this through a web interface(the table cannot be migrated to any other relational or non-relational database).

The web application will be deployed in google-cloud on app-engine and the user who acts as admin and owner privileges on Bigquery will be able to create and delete records and the other users with view permissions on the dataset in bigquery will be able to view records only.

I am planning to use the scripting language as python, 
server(django or flask or any other)-> not sure which one is better

The web application should be displayed as a data-grid like appearance with buttons create,delete or view visiblility according to their roles.

I have not done anything like this in python,bigquery and django. I am already familiar with calling bigquery from python-client but to call in a web interface and in a transactional way, i am totally new. I am seeing examples only related to django with their inbuilt model and not with big-query. Can anyone please help me and clarify whether this is possible to implement and how?

question from:https://stackoverflow.com/questions/65883921/crud-web-application-with-bigquery

Answer 1

No, at most you could achieve the "R" of "CRUD." BigQuery isn't a transactional database, it's for querying vast amounts of data and preparing the results as an immutable view.

It doesn't provide a method to modify the source data directly and even if you did you'd need to run the query again. Also important to note are that queries are asynchronous and require much longer to perform than traditional databases.

The only reasonable solution would be to export the table data to GCS and then import it into a normal database for querying. Alternatively if you can't use another database and since you said there are only 1,000 rows you could perform your CRUD actions directly on that exported CSV.