Couldn't use caching when the connector is BigQuery

[cyyeh]

Environment

• Version:

  cli version: 0.7.1
  core version: 0.7.1
  build version: 0.7.1
  serve version: 0.7.1
  

• OS: macOS with M1 chip

What's wrong?

Couldn't use caching when connector is BigQuery. After discussing with @onlyjackfrost, there might be two places we need to modify in packages/extension-driver-bq/src/lib/bgDataSource.ts:

// Use the directory to avoid filename collision,
    // The wildcard indicates the partition,
    // ref: https://cloud.google.com/bigquery/docs/reference/standard-sql/other-statements#export_option_list
    const bucketObjPrefix = path.join(bucketName, directory);
    const uri = `gs://${path.join(bucketObjPrefix, 'part*.parquet')}`;
    const queryOptions = {
      query: `EXPORT DATA OPTIONS( uri="${uri}", format='PARQUET') AS ${statement}`,
      location: options?.location || 'US',
    };

const getFilesResponse = await storage.bucket(bucketName).getFiles({
  prefix: directory.slice(1),
})

What's the correct behavior?

Users can caching when the connector is BigQuery

Reproducing steps