Databases
/
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 resource for each table in your database. Think of these as prebuilt queries, so you don't have to write queries for everything.
  2. An insert, update, and delete function for each table in the database (if the connecting user account has these privileges).
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 =, !=, <, <=",">, >=. </,>