Firestore

Firestore is a NoSQL document database provided by Google Cloud Platform. It is designed to store and sync data for client and server-side development.

How do I activate this integration?

First Step

Second Step

You will then be shown a configuration modal where you can upload the Firestore credentials, fill in the database URL and click on Connect Firestore DB.

Third Step

Head over to the Data sources page and click on New data source.

Fourth Step

Fill in a name for the data source, an optional description, and choose Firestore as the type. Then click on Connect.

Fifth Step

In the page that appears, fill in the Firestore query parameters and click on Save changes. You should now see your data descriptions and sample data appear.

Where do I get the firestore credentials?

Go to your Firebase projects page, then select your project and as shown below, go to your Project Settings.

A file named <your-project>-firebase-adminsdk-<first-numbers-of your-key>.json get generated, and it is your ServiceAccount.json file.

What can I do with this integration?

You can pull in data from Firestore collections as data sources on Onvo to build your dashboards and reports. Any data source using the Firestore integration will be kept in sync with the underlying data to keep your dashboards live.

You can create beautiful, interactive dashboards using your Firestore data. Just ask for the kind of visualization you want in natural language to create a widget on the dashboard. You can also ask for data pre-processing before visualization. We also allow for questions in natural language to your data on Firestore.

Once you are happy with your dashboard, you can integrate them into your products with the SDK.

How do I create a dashboard using Firestore data?

On Onvo, you can do this by specifying the Firestore project details and collection in the data source configuration.

Config parameters

type

string

Type of the Firestore configuration (e.g., "service_account").

project_id

string

ID of your Firestore project.

private_key_id

string

Private key ID for authentication.

private_key

string

Private key for authentication.

client_email

string

Client email for authentication.

client_id

string

Client ID for authentication.

auth_uri

string

Authentication URI.

token_uri

string

Token URI.

auth_provider_x509_cert_url

string

Authentication provider X.509 certificate URL.

client_x509_cert_url

string

Client X.509 certificate URL.

universe_domain

string

Universe domain for Firestore.

databaseURL

string

URL of your Firestore database.

collection

string

Name of the Firestore collection to query.

Security considerations

Ensure that you keep your Firestore credentials secure. Restrict access to the Firestore database to only necessary entities.

If you need to whitelist IP addresses, make sure to allow 35.209.78.5 for Onvo AI to access your Firestore database.