您可以将文件上传到Google Cloud Storage中，然后使用BigQuery进行导入。以下是相关代码示例：

1. 将本地文件上传到Google Cloud Storage：

from google.cloud import storage

Creates a client

storage_client = storage.Client()

Set the name of the bucket that the file will be uploaded to

bucket_name = "your-bucket-name"

Set the local file path

local_file_path = "path/to/local/file.csv"

Set the destination file name in the bucket

destination_file_name = "file.csv"

Upload the file

bucket = storage_client.bucket(bucket_name) blob = bucket.blob(destination_file_name) blob.upload_from_filename(local_file_path)

2. 使用BigQuery进行导入：

from google.cloud import bigquery

Creates a client

bigquery_client = bigquery.Client()

Set the project ID

project_id = "your-project-id"

Set the dataset ID

dataset_id = "your-dataset-id"

Set the table ID

table_id = "your-table-id"

Set the GCS URI for the file

gcs_uri = "gs://{}/{}".format(bucket_name, destination_file_name)

Set the job configuration

job_config = bigquery.LoadJobConfig() job_config.schema = [...] # Set the schema of the table job_config.write_disposition = "WRITE_TRUNCATE" # Set the write disposition

Start the job

load_job = bigquery_client.load_table_from_uri( gcs_uri,
bigquery.DatasetReference(project_id, dataset_id).table(table_id), job_config=job_config, )

Wait for the job to complete

load_job.result()