Shuaib-8

from google.cloud import bigquery 
from google.oauth2 import service_account 

credentials = service_account.Credentials.from_service_account_file('FILE PATH JSON')

project_id = 'PROJECT ID' 

client = bigquery.Client(credentials = credentials, project = project_id)  

# Example querying 

Shuaib-8

-- Get the column name and data type
SELECT column_name, data_type
-- From the system database information schema
FROM INFORMATION_SCHEMA.COLUMNS 
-- For the customer table
WHERE table_name = <'table_name'>;