How to Create a Table in BigQuery

Tables in BigQuery, and other databases are created with the create table statement, where you define the columns of the table by specifying their names followed by data types.

create table Database_test_IB1.employee (
	emp_id		integer,
	first_name	string,
	last_name	string,
	start_day	date,
	salary		decimal(8,2)
);
create table Database_test_IB1.airport ( 	
city 			string, 
airport_code 	string, 
x_coordinate 	integer,
y_coordinate 	integer,
z_coordinate 	integer
);

IN THIS PAGE