firebase ext:install firebase/firestore-bigquery-export --project=PROJECT_ID

Collection path: What is the path of the collection that you would like to export? You may use {wildcard} notation to match a subcollection of all documents in a collection (for example: chatrooms/{chatid}/posts). Parent Firestore Document IDs from {wildcards}  can be returned in path_params as a JSON formatted string.
? Enter a value for Collection path: (posts)

BIGQUERY_PROJECT_ID=<PROJECT_ID>
COLLECTION_PATH=works
DATASET_ID=firestore_export
DATASET_LOCATION=asia-northeast1
EXCLUDE_OLD_DATA=yes
firebaseextensions.v1beta.function/location=us-central1
MAX_DISPATCHES_PER_SECOND=100
TABLE_ID=works
TABLE_PARTITIONING=NONE
TIME_PARTITIONING_FIELD_TYPE=omit
USE_COLLECTION_GROUP_QUERY=yes
USE_NEW_SNAPSHOT_QUERY_SYNTAX=yes
WILDCARD_IDS=true

diff --git a/firebase.json b/firebase.json
index 006b2dd..833d57d 100644
--- a/firebase.json
+++ b/firebase.json
@@ -32,5 +32,8 @@
       "enabled": true,
       "host": "0.0.0.0"
     }
+  },
+  "extensions": {
+    "firestore-bigquery-export": "firebase/firestore-bigquery-export@0.1.51"
   }
 }

{
  "fields": [
    {
      "name": "title",
      "type": "string"
    },
    {
      "name": "description",
      "type": "string"
    }
  ]
}

$ npx @firebaseextensions/fs-bq-schema-views \
  --non-interactive \
  --project=<PROJECT_ID> \
  --big-query-project=<PROJECT_ID> \    
  --dataset=firestore_export \   
  --table-name-prefix=works \            
  --schema-files=./schema.json 
Need to install the following packages:
@firebaseextensions/fs-bq-schema-views@0.4.7
Ok to proceed? (y) 
npm WARN deprecated inflight@1.0.6: This module is not supported, and leaks memory. Do not use it. Check out lru-cache if you want a good and tested way to coalesce async requests by a key value, which is much more comprehensive and powerful.
npm WARN deprecated glob@8.1.0: Glob versions prior to v9 are no longer supported
npm WARN deprecated glob@7.1.5: Glob versions prior to v9 are no longer supported
error: unknown option '--big-query-project=<PROJECT_ID>'

$ bq --api http://localhost:9050 query --project_id=demo-bq-firestore 'SELECT 1'
+-------+
| $col1 |
+-------+
|     1 |
+-------+

firebase emulators:start --project=demo-bq-firestore

i  emulators: Detected demo project ID "demo-bq-firestore", emulated services will use a demo configuration and attempts to access non-emulated services for this project will fail.
⚠  Extensions: The following Extensions make calls to Google Cloud APIs that do not have Emulators. demo-bq-firestore is a demo project, so these Extensions may not work as expected.
┌─────────────────────────┬──────────────────────────┬──────────────────────────────┬────────────────────────────────────────────┐
│ API Name                │ Instances using this API │ Enabled on demo-bq-firestore │ Enable this API                            │
├─────────────────────────┼──────────────────────────┼──────────────────────────────┼────────────────────────────────────────────┤
│ bigquery.googleapis.com │ firestore-bigquery-expo… │ No                           │ https://firebase.tools/l/LoMXec6nyrFK9XGx6 │
└─────────────────────────┴──────────────────────────┴──────────────────────────────┴────────────────────────────────────────────┘

⚠  functions: Error: Failed to determine service account. Initialize the SDK with service account credentials or set service account ID as an app option.

 [
 ...
  {
    "name": "inserted_at",
    "type": "TIMESTAMP",
    "description": "The timestamp when the record was inserted into the BigQuery table",
    "defaultValueExpression": "CURRENT_TIMESTAMP()"
  }
]

    const writer = new managedwriter.JSONWriter({
      connection,
      protoDescriptor,
      defaultMissingValueInterpretation:
        protos.google.cloud.bigquery.storage.v1.AppendRowsRequest.MissingValueInterpretation.DEFAULT_VALUE,
    });

    const query = `
      SELECT id, title, description
      FROM (
        SELECT
          id,
          title,
          description,
          ROW_NUMBER() OVER (PARTITION BY id ORDER BY inserted_at DESC) AS record_num
        FROM \`${bigqueryProjectId.value()}.${bigqueryDatasetId.value()}.works\`
      )
      WHERE record_num = 1 AND (title LIKE @word OR description LIKE @word)
    `;