Skip to content
    Google Firestore -> BigQuery Schema Creator@YanniGK
    Open on Replit
    index.js
    readme.md
    updated_schema.json
    Packager files
    package-lock.json
    package.json
    Config files
    .replit
    replit.nix

    Replit Google BigQuery Schema Generator

    1. Update updated_schema.json with your firebase document properities
    2. Authenticate the Google Cloud CLI in the Shell
    gcloud auth application-default login
    1. Run the Google BigQuery Schema Script
      (Be sure to change the placeholder variables!)
    npx @firebaseextensions/fs-bq-schema-views --non-interactive --project=PROJECT_ID --dataset=DATABASE_ID --table-name-prefix=TABLE_NAME_COLLECTION_NAME --schema-files=./updated_schema.json

    ex.

    npx @firebaseextensions/fs-bq-schema-views --non-interactive --project=polyglotprod --dataset=firestore_export --table-name-prefix=users --schema-files=./updated_schema.json

    Source
    Part of a Larger Blog Post
    created by Yanni Kouloumbis during Replit Ventures