--- title: BigQuery and Firebase: Integration and Streaming | daily.dev description: Explains how integrating Firebase with BigQuery lets developers run custom, deeper analysis on app data beyond the built-in Firebase console dashboards. Covers... canonical: https://daily.dev/posts/bigquery-and-firebase-integration-and-streaming-t9fxmi9g7 twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: BigQuery and Firebase: Integration and Streaming | daily.dev og:description: Explains how integrating Firebase with BigQuery lets developers run custom, deeper analysis on app data beyond the built-in Firebase console dashboards. Covers... og:url: https://daily.dev/posts/bigquery-and-firebase-integration-and-streaming-t9fxmi9g7 og:image: https://api.daily.dev/og/posts/t9FXmi9g7.png og:image:alt: BigQuery and Firebase: Integration and Streaming og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # BigQuery and Firebase: Integration and Streaming **[Firebase](https://daily.dev/sources/firebase-blog)** · 8 min read · 0 upvotes · 0 comments ## Summary Explains how integrating Firebase with BigQuery lets developers run custom, deeper analysis on app data beyond the built-in Firebase console dashboards. Covers which Firebase products (Analytics, Cloud Messaging, Crashlytics, Performance Monitoring, A/B Testing) can export to BigQuery, how to enable the export, and how streaming works for Google Analytics and Crashlytics to get same-day data instead of waiting until the next day. Also details export limits, the batch vs. real-time tables for Crashlytics, and BigQuery's free vs. paid features including the Sandbox mode for testing without billing. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I get same-day Google Analytics data into BigQuery instead of waiting until the next day? Enable BigQuery streaming for Google Analytics, which publishes periodic updates to an intraday table named events_intraday_YYYYMMDD throughout the day. Without streaming, Firebase-linked BigQuery data only becomes available for the previous day, so today's data isn't queryable until tomorrow. Streaming is best-effort and may omit some late or failed hits, and has no backfill once enabled. _Developers building real-time analytics pipelines can find integration deep dives like this on daily.dev._ ### What is the daily BigQuery export limit for a standard Google Analytics property? Standard Google Analytics properties are limited to 1 million exported events per day to BigQuery. If a property consistently exceeds that limit, the daily export is paused and the missed days are not reprocessed afterward. Upgrading to GA 360 raises the limit, and data filtering can be used to control which events get exported to stay under it. _daily.dev surfaces practical limits and gotchas like this for teams planning analytics infrastructure._ ### What's the difference between the Crashlytics batch table and real-time table in BigQuery? The batch table exports data once daily, supports backfill up to 90 days prior, and suits long-term trend analysis since Firebase durably stores events before writing them. The real-time table writes data immediately with no backfill, making it ideal for live dashboards and custom alerts. Combining both via a stitching query gives complete, up-to-date reporting. _daily.dev helps engineers compare data pipeline trade-offs like batch versus real-time exports._ ## Similar posts on daily.dev - [Introducing BigQuery Agent Analytics](https://daily.dev/posts/introducing-bigquery-agent-analytics-9cxicqkzb) · Google Cloud · 1 upvotes · 0 comments --- Tags: [#firebase](https://daily.dev/tags/firebase), [#google-bigquery](https://daily.dev/tags/google-bigquery), [#google-analytics](https://daily.dev/tags/google-analytics), [#data-streaming](https://daily.dev/tags/data-streaming) [View this post on daily.dev](https://daily.dev/posts/bigquery-and-firebase-integration-and-streaming-t9fxmi9g7) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"BigQuery and Firebase: Integration and Streaming","url":"https://daily.dev/posts/bigquery-and-firebase-integration-and-streaming-t9fxmi9g7","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/bigquery-and-firebase-integration-and-streaming-t9fxmi9g7"},"datePublished":"2026-08-23T12:21:07.409Z","dateModified":"2026-08-23T12:35:30.344Z","description":"Explains how integrating Firebase with BigQuery lets developers run custom, deeper analysis on app data beyond the built-in Firebase console dashboards. Covers...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/7ed721de96163685d26ab7e314be3ebc?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/7ed721de96163685d26ab7e314be3ebc?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Firebase","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Firebase","logo":"https://media.daily.dev/image/upload/s--i395oqZH--/f_auto,q_auto/v1787487448/logos/firebase-blog?_a=BAMAMicg0","url":"https://daily.dev/sources/firebase-blog"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/bigquery-and-firebase-integration-and-streaming-t9fxmi9g7","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"firebase,google-bigquery,google-analytics,data-streaming","timeRequired":"PT8M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Firebase","item":"https://daily.dev/sources/firebase-blog"},{"@type":"ListItem","position":3,"name":"BigQuery and Firebase: Integration and Streaming"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/bigquery-and-firebase-integration-and-streaming-t9fxmi9g7#faq","mainEntity":[{"@type":"Question","name":"How do I get same-day Google Analytics data into BigQuery instead of waiting until the next day?","acceptedAnswer":{"@type":"Answer","text":"Enable BigQuery streaming for Google Analytics, which publishes periodic updates to an intraday table named events_intraday_YYYYMMDD throughout the day. Without streaming, Firebase-linked BigQuery data only becomes available for the previous day, so today's data isn't queryable until tomorrow. Streaming is best-effort and may omit some late or failed hits, and has no backfill once enabled. Developers building real-time analytics pipelines can find integration deep dives like this on daily.dev."}},{"@type":"Question","name":"What is the daily BigQuery export limit for a standard Google Analytics property?","acceptedAnswer":{"@type":"Answer","text":"Standard Google Analytics properties are limited to 1 million exported events per day to BigQuery. If a property consistently exceeds that limit, the daily export is paused and the missed days are not reprocessed afterward. Upgrading to GA 360 raises the limit, and data filtering can be used to control which events get exported to stay under it. daily.dev surfaces practical limits and gotchas like this for teams planning analytics infrastructure."}},{"@type":"Question","name":"What's the difference between the Crashlytics batch table and real-time table in BigQuery?","acceptedAnswer":{"@type":"Answer","text":"The batch table exports data once daily, supports backfill up to 90 days prior, and suits long-term trend analysis since Firebase durably stores events before writing them. The real-time table writes data immediately with no backfill, making it ideal for live dashboards and custom alerts. Combining both via a stitching query gives complete, up-to-date reporting. daily.dev helps engineers compare data pipeline trade-offs like batch versus real-time exports."}}]} ```