Missing some events from events_table in BQ/Firebase link

[Volshebnik_Q]

Hello, dear community!

I have several Firebase projects.
All projects are connected to one BQ.
Each firebase project has one application.
I have events from each project. Like "analytics_<id>.events_20240519" for everyone

And then one application was added to one FireBase project. To smoothly move from the old to the new

And at the moment, every application has users.
However, the events come to BQ only from the old application.
And events do not come from the new.

What could be the reason for this error? I would appreciate any help! 

[ms4446 · Accepted solution]

It sounds like the new application added to your Firebase project is not properly configured to send events to BigQuery. Here are some possible reasons and steps to troubleshoot the issue:

Firebase Configuration:

• Ensure that the new application is properly linked to the Firebase project.
• Verify that Google Analytics is enabled for the new application in the Firebase console.

BigQuery Export Configuration:

• Check if the BigQuery export for Firebase Analytics is correctly configured for the new application.
• Ensure that the dataset in BigQuery is set up to receive data from the new application.

API and SDK Integration:

• Verify that the new application is using the correct Firebase SDK and that the SDK is properly initialized.
• Ensure that the necessary permissions and API keys are correctly set up for the new application.

Event Logging:

• Confirm that the new application is logging events correctly.
• Check the Firebase Analytics dashboard to see if the events are being recorded for the new application.

Permissions and Access:

• Ensure that the service account used for BigQuery export has the necessary permissions to write to the BigQuery dataset.
• Check if there are any errors or permission issues in the Firebase console or BigQuery logs.

Monitoring and Debugging:

• Use Firebase DebugView to monitor events in real-time and ensure that events from the new application are being captured.
• Check the logs in the Firebase console for any errors or issues related to event tracking.

Steps to Troubleshoot:

Verify Firebase Project Linking:

1. Go to Firebase Console -> Project Settings -> General -> Your Apps section.
2. Ensure that the new application is listed and linked to the correct Firebase project.

Check BigQuery Export Configuration:

1. In Firebase Console -> Analytics -> Data Settings -> BigQuery Linking, confirm that the new application is selected for BigQuery export.
2. Ensure that the correct BigQuery dataset is specified for the export.

Validate SDK Integration:

• Check the initialization code in your new application to ensure that the Firebase SDK is initialized correctly. For example:

// Initialize Firebase
var firebaseConfig = {
  apiKey: "YOUR_API_KEY",
  authDomain: "YOUR_PROJECT_ID.firebaseapp.com",
  projectId: "YOUR_PROJECT_ID",
  storageBucket: "YOUR_PROJECT_ID.appspot.com",
  messagingSenderId: "YOUR_MESSAGING_SENDER_ID",
  appId: "YOUR_APP_ID",
  measurementId: "YOUR_MEASUREMENT_ID"
};
firebase.initializeApp(firebaseConfig);
firebase.analytics();

Use DebugView:

1. In Firebase Console -> Analytics -> DebugView, you can see real-time events to ensure that events are being logged from the new application.

Check Logs and Errors:

1. In Firebase Console -> Analytics -> Data Settings -> BigQuery Linking, check for any errors in the linking process.
2. Look at the Firebase console logs for any issues related to the new application.

[Volshebnik_Q]

Thank you so much for your help, ms4446!
After going through each item of your hint, we managed to find out that previously unknown Analytics was connected to Firebase.
And from there, the export was not connected.