How to use the new Table Clones Function in BigQuery

Great new Feature of Data Versioning in Google BigQuery

If you want to snapshot tables in Big Query, e.g. to ensure versioning, you now have one more option. Namely the function to clone a table. Google offers this solution for now in preview, however, the rest of us will get it also sooner or later as per usual.

Here the official statement:

The SQL to do so is quite simple:

Others options you have is to create a snapshot or to implement a versioning logic in your data processing. Click here for more.

🔵 Become a Writer

Related posts:

I recently bought a car(mustang!) and I was able to get a pretty low premium, do I need to put my mom as a additional driver? She has her own car and her own premium. ANSWER: I would recommend you to…

A few major holidays are right around the corner, and finding the perfect gift for the creative-minded can seem like just as much of a challenge as writing a novel, especially if the best idea you…

This is a question that we all are asked at some time or the other. And the obvious answer that we come up with is our names, designations and the likes. But how often do we stop by and consider the…