DATA SOURCES
/
Cloud Firestore

Cloud Firestore

How to connect

  • Display Name: Give your data source a name for use within Internal. 
  • Upload: Upload the JSON key file for the Google Cloud service account that you created for Internal.
Note: To connect with Internal, your data source must be publicly accessible, with SSL encryption enabled, and configured to accept connections from Internal’s IP addresses.

34.66.153.118/32
35.225.125.80/32 

What happens when you connect

When you connect Cloud Firestore to Internal, we'll generate the following for you automatically:

  1. A list, insert, update, and delete function for each table in the database (if the connecting user account has these privileges). List functions read data from your tables and allow you to display that data in components - think of these as prebuilt SQL queries, so you don't have to write queries for everything.


Note: Functions will not be generated if no primary keys are found in the connected database.

Filtering and Sorting

Internal enables filtering and sorting on all columns that are indexed. While Firestore automatically creates most indexes for you, you may need to create missing indexes on your own. Supported operators vary based on the data type, but can include =, !=, <, <=",">, >=. </,>

Permissions

To connect your Firestore database to Internal, you'll need to use credentials with one of the following roles:

  • Cloud Datastore Viewer (allows read only access)
  • Cloud Datastore User (allows read/write access)
  • Cloud Datastore Owner (allows read/write access)