extensions

extensions copied to clipboard

Describe your configuration

• Extension name: firestore-bigquery-export (storage-resize-images, firestore-send-email, etc)
• Extension version: 0.1.12

Describe the problem

Running fs-bq-import-collection leads me to an error message with insufficient information to know what to do next.

Steps to reproduce:

I ran the following command and the answers to the interact questions:

? What is your Firebase project ID? **<MY_PROJECT_NAME>**
? What is the path of the the Cloud Firestore Collection you would like to import from? (This may, or may not, be the same Collection for which you plan to 
mirror changes.) **<MY_COLLECTION_NAME>**
? Would you like to import documents via a Collection Group query? **No**
? What is the ID of the BigQuery dataset that you would like to use? (A dataset will be created if it doesn't already exist) **<MY_DATASET_NAME>**
? What is the identifying prefix of the BigQuery table that you would like to import to? (A table will be created if one doesn't already exist) **<MY_PREFIX_NAME>**
? How many documents should the import stream into BigQuery at once? **300**
? Where would you like the BigQuery dataset to be located? **us**
? Would you like to run the import across multiple threads? **No**

Expected result

Command is successful; data loads to BigQuery without errors/issues.

Actual result

I get the following error message:

Importing data from Cloud Firestore Collection: <MY_COLLECTION_NAME>, to BigQuery Dataset: <MY_DATASET_NAME>, Table: <MY_PREFIX_NAME>_raw_changelog
Error importing Collection to BigQuery: Error: 16 UNAUTHENTICATED: Failed to retrieve auth metadata with error: invalid_grant

and I have no idea what I need to look into w.r.t. auth metadata to become authenticated. My user account is the only one that has created these projects (Firebase and BigQuery) and I've done all of the configuration via command line (firebase, gcloud, bq, etc...)

Ends up being a need to run gcloud auth application-default login as documented in the GENERATE SCHEMA VIEWS documentation.

It is not clear to me that this step/requirement is easy to identify in the documentation? Also, might the error message be a bit more specific?

thanks for the feedback. @dackers86 lets improve the error message and also think about making these docs pages more discoverable