Cloud Firestore Setup Guide Beta

Follow these instructions to connect your Cloud Firestore database to your destination using Fivetran.

---

Prerequisites

To connect your Firestore database to Fivetran, you must have a .

---

Setup instructions

IMPORTANT: If you have a Firebase service account, skip to the .

Create Firebase service account

1. Log in to your Firebase project dashboard.

2. On the left navigation pane, click the Settings icon and then select Project settings.

   

3. Go to the Service accounts tab.

4. Select Firebase Admin SDK.

   

5. Click Create service account.

Create service account key

1. Go to the Project settings page.

2. Go to the Service accounts tab.

3. Select Firebase Admin SDK.

   

4. Click Generate new private key.

5. Make a note of the JSON private key. You will need it to configure Fivetran.

Finish Fivetran configuration

1. In the , enter your chosen Destination schema name.

2. In the Service Account Key field, upload the private key you created in

3. Select your :

   • If your table has more than 1000 first-level fields, you must select packed as your sync mode. If you anticipate the number of first-level fields will exceed 1000 in the future, you should select packed mode. Once you select packed mode, you will see your tables and can select which ones to sync in packed mode.
   • If your table has fewer than 1000 first-level fields, you can select either packed or unpacked as your sync mode.

4. Click Save & Test. Fivetran will take it from here and sync your data from your Firestore database.

Setup test

Fivetran performs the following tests to ensure that we can connect to your Firestore database using the credentials you provided in the setup form:

• The Connecting to Database Test checks if we can access your Firestore database.
• The Collection Access Check Test checks if we can list and access at least one collection in your Firestore database.

NOTE: The test may take a few minutes to finish running.

---

Related articles