maxthemanager

import os
from google.cloud import bigquery
os.environ["GOOGLE_APPLICATION_CREDENTIALS"] = r'D:\Work\Flyaps\Demo\BQ_service_account.json'
client = bigquery.Client()
dataset_id = "peerless-text-365915.Demo_dataset_python"
dataset = bigquery.Dataset(dataset_id)
dataset.location = "europe-west3"
client.create_dataset(dataset, timeout=30)
table_id = f"{dataset_id}.industry"
job_config = bigquery.LoadJobConfig(source_format=bigquery.SourceFormat.CSV, autodetect=True)