Published in


Using the Create-Table-Like Statement

How, When and Why to Use the BigQuery Function

Photo by Gianluca Cinnante on Unsplash

With the creates table like statement you can copy your table to another with all of the same metadata of the table. This can be useful, for example, if you want to make backup copies or archive data. It’s also nice that you don’t have to do this manually but by code and yes it’s also easy to automate.




Everything connected with Tech & Code. Follow to join our 900K+ monthly readers

Recommended from Medium

Zaio Research Project: C#

How Does Server Monitoring Service Save Your Business?

How disabling 802.11b data rates helps improve your Wi-Fi performance.

Inline Script inside sCrypt

SRECon17 Americas: Some Key Takeaways

Don’t Dress to Impress in the Winter

activemq vs kafka

Doing More By Doing Less – Launching With a Lean MVP

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store


Big Data Enthusiast based in Hamburg and Kiel. Thankful if you would support my writing via:

More from Medium

Data Studio now allows more Join Possibilities when Blending Data

Making Interactive Report Using Google Data Studio and BigQuery Sandbox (Public Dataset…

How to Compute a Moving Average in BigQuery Using SQL

WITH, Create Permanent Unnested Tables from Temporary Tables in a GA4 E-commerce Project in…

Cover image. A BigQuery and WITH CLAUSE logo appears.