@burningphoenix

from google.cloud import bigquery # Create a "Client" object client = bigquery.Client() # Construct a reference to the "hacker_news" dataset dataset_ref = client.dataset("hacker_news", project="bigquery-public-data") # API request - fetch the dataset dataset = client.get_dataset(dataset_ref) # List all the tables in the "hacker_news" dataset tables = list(client.list_tables(dataset))

CREATE TABLE lpu ( id INTEGER PRIMARY KEY, name TEXT NOT NULL, gender TEXT NOT NULL ); INSERT INTO lpu VALUES (1, 'Aryan', 'M'); INSERT INTO lpu VALUES (2, 'Akansha', 'F'); INSERT INTO lpu VALUES (3, 'Yash', 'M');