导出到Bigquery的数据流: insertAll错误，无效的表引用

SELECT * FROM `your_project_id.your_dataset_id.your_table_id` LIMIT 1;

CREATE TABLE `your_project_id.your_dataset_id.your_table_id` (
  column1 datatype,
  column2 datatype,
  ...
);

`your_project_id.your_dataset_id.your_table_id`

`my-project.my_dataset.my_table`

const {BigQuery} = require('@google-cloud/bigquery');

async function insertData() {
  const bigqueryClient = new BigQuery();

  const datasetId = 'your_dataset_id';
  const tableId = 'your_table_id';
  const projectId = 'your_project_id';

  const tableRef = bigqueryClient.dataset(datasetId).table(tableId);

  const rowsToInsert = [
    {column1: 'value1', column2: 'value2'},
    {column1: 'value3', column2: 'value4'}
  ];

  try {
    const [results] = await bigqueryClient.insertAll({
      projectId: projectId,
      datasetId: datasetId,
      tableId: tableId,
      rows: rowsToInsert
    });

    console.log('Rows inserted successfully:', results);
  } catch (error) {
    console.error('ERROR:', error);
  }
}

insertData();