Я застрял с этой ошибкой, дайте мне знать, если есть обходные пути:
googleBigQuery: Catchable fatal error: Argument 1 passed to
Google\Cloud\BigQuery\BigQueryClient::runQuery() must be an instance
of Google\Cloud\BigQuery\JobConfigurationInterface, string given
Пример кода:
<?php
require __DIR__ . '/vendor/autoload.php';
use Google\Cloud\BigQuery\BigQueryClient;
// get the project ID as the first argument
$projectId = 'bigquery-public-data';
$bigQuery = new BigQueryClient([
'projectId' => $projectId,
]);
$query = 'SELECT TOP(corpus, 10) as title, COUNT(*) as unique_words ' .
'FROM [bigquery-public-data:samples.shakespeare]';
$options = ['useLegacySql' => true];
$queryResults = $bigQuery->runQuery($query, $options);
if ($queryResults->isComplete()) {
$i = 0;
$rows = $queryResults->rows();
foreach ($rows as $row) {
printf('--- Row %s ---' . PHP_EOL, ++$i);
foreach ($row as $column => $value) {
printf('%s: %s' . PHP_EOL, $column, $value);
}
}
printf('Found %s row(s)' . PHP_EOL, $i);
} else {
throw new Exception('The query failed to complete');
}