如何使用google appscript在BigQuery中导入csv日期格式

function importCSVtoBigQuery() {
  var projectId = 'YOUR_PROJECT_ID';
  var datasetId = 'YOUR_DATASET_ID';
  var tableId = 'YOUR_TABLE_ID';
  var fileUrl = 'CSV_FILE_URL';
  
  var file = UrlFetchApp.fetch(fileUrl);
  var csvData = Utilities.newBlob(file.getContent()).getDataAsString();
  var data = Utilities.parseCsv(csvData);
  
  var rows = [];
  for (var i = 1; i < data.length; i++) {
    var row = {};
    for (var j = 0; j < data[0].length; j++) {
      if (data[0][j] === 'date_column_name') {
        row[data[0][j]] = new Date(data[i][j]);
      } else {
        row[data[0][j]] = data[i][j];
      }
    }
    rows.push(row);
  }
  
  var table = BigQuery.Tables.get(projectId, datasetId, tableId);
  var tableSchema = table.schema.fields;
  
  var job = {
    configuration: {
      load: {
        destinationTable: {
          projectId: projectId,
          datasetId: datasetId,
          tableId: tableId
        },
        schema: {
          fields: tableSchema
        },
        sourceFormat: 'CSV',
        writeDisposition: 'WRITE_APPEND',
        sourceUris: [fileUrl],
        skipLeadingRows: 1,
        autodetect: false,
        allowQuotedNewlines: true,
        allowJaggedRows: true,
        ignoreUnknownValues: true,
        maxBadRecords: 0,
        fieldDelimiter: ','
      }
    }
  };
  
  var insertJob = BigQuery.Jobs.insert(job, projectId);
  Logger.log('Job ID: ' + insertJob.jobReference.jobId);
}