How to create Google BigQuery Tables

In this video we show how to create Google BigQuery tables in a number of different ways.
We start by showing how to create Google BigQuery datasets from the BigQuery module before demonstrating how to create Google BigQuery tables from a CSV.
We then run through how to create BigQuery tables from a SQL query using another bigquery table as a source for the new table.
Finally, we look at creating empty tables through a create table SQL command and through the bigquery create table dialogue. This video is part of a google bigquery tutorial series we are currently running on the channel.

[@KD-wp6cm]

How can we create multiple dataset(not public) user one project

[@analyticswithadam]

From one query? Can you explain what you trying to do?

[@KD-wp6cm]

@@analyticswithadam Like Snowflake, I want to create multiple datasets under one gbq project. One dataset will be called as landing, under which all the tables from source will be dumped. Next dataset as Staging where transformed data will be stored... Then another Project for DEV/UAT.

[@viliangoranov8271]

Hello i have a problem with Bigquery he tells me that location is not found i’m a beginner and i don’t know how to fix it i have tried many things but i can’t fix it i will be thankful if someone can help me

[@analyticswithadam]

Location of a public dataset?

[@khalilrhellab3527]

hello you forget to put the CSV file in description!

[@analyticswithadam]

Sorry about that, you can download it from here www.kaggle.com/datasets/psycon/daily-coffee-price