--- title: Query Delta Lake natively using BigQuery | daily.dev description: BigQuery now natively integrates with Delta Lake's transaction log, letting users query Delta tables directly without the older manifest-based approach that... canonical: https://daily.dev/posts/query-delta-lake-natively-using-bigquery-qohb7nl6p twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Query Delta Lake natively using BigQuery | daily.dev og:description: BigQuery now natively integrates with Delta Lake's transaction log, letting users query Delta tables directly without the older manifest-based approach that... og:url: https://daily.dev/posts/query-delta-lake-natively-using-bigquery-qohb7nl6p og:image: https://api.daily.dev/og/posts/QOhb7nL6P.png og:image:alt: Query Delta Lake natively using BigQuery 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. # Query Delta Lake natively using BigQuery **[Delta Lake Blog](https://daily.dev/sources/delta-lake)** · 3 min read · 0 upvotes · 0 comments ## Summary BigQuery now natively integrates with Delta Lake's transaction log, letting users query Delta tables directly without the older manifest-based approach that suffered from staleness and manual refreshes. Users create a BigLake table pointed at the Delta table's storage prefix (Amazon S3, Azure Blob Storage, ADLS Gen2, or Google Cloud Storage, currently in public preview), and BigQuery parses the Delta log at query time for better performance, automatic schema change detection, and BigLake's fine-grained row/column-level security and data masking, optionally managed via Dataplex. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How does BigQuery query Delta Lake tables now compared to the old manifest-based method? BigQuery now parses Delta log metadata directly at query time instead of relying on a manifest file. The previous manifest-based approach required manual refreshes and could suffer from read staleness; the new native integration through BigLake eliminates those staleness limitations and enables optimized query planning and improved performance. _daily.dev surfaces updates like this for teams weighing lakehouse query engine options._ ### Which cloud storage platforms support querying Delta Lake tables in BigQuery? BigQuery can query Delta Lake tables stored on Amazon S3, Azure Blob Storage, ADLS Gen2, and Google Cloud Storage, with this functionality in public preview. For tables on Amazon S3 or ADLS Gen2, BigQuery Omni processes the data locally in that respective cloud for performance and cost benefits. _Track multi-cloud data lake capabilities like this on daily.dev as they move out of preview._ ### How do I set up fine-grained security on Delta Lake tables queried through BigQuery? Fine-grained row and column-level permissions, plus data masking, can be configured on Delta tables through BigLake, which enforces a consistent security model across BigQuery storage, Amazon S3, Azure Data Lake Storage Gen2, and Google Cloud Storage. Permissions can be set with SQL statements directly or centrally managed at scale using Dataplex, which pushes policies down to BigLake. _Engineers designing governance for lakehouse data can follow security model updates on daily.dev._ ## Similar posts on daily.dev - [Delta Lake Explained: Boost Data Reliability in Cloud Storage](https://daily.dev/posts/delta-lake-explained-boost-data-reliability-in-cloud-storage-oechbmvm4) · databricks · 0 upvotes · 0 comments - [ClickHouse is data lake ready](https://daily.dev/posts/clickhouse-is-data-lake-ready-yi7rw0mlt) · ClickHouse · 2 upvotes · 0 comments - [Apache Iceberg vs Delta Lake: Choosing the Right Table Format](https://daily.dev/posts/apache-iceberg-vs-delta-lake-choosing-the-right-table-format-vtnia2ems) · BigData Boutique blog · 7 upvotes · 0 comments - [Borderless lakehouse integrates with Gemini](https://daily.dev/posts/borderless-lakehouse-integrates-with-gemini-xnwh0dwug) · Google Cloud · 0 upvotes · 0 comments --- Tags: [#data-engineering](https://daily.dev/tags/data-engineering), [#google-bigquery](https://daily.dev/tags/google-bigquery), [#apache-iceberg](https://daily.dev/tags/apache-iceberg) [View this post on daily.dev](https://daily.dev/posts/query-delta-lake-natively-using-bigquery-qohb7nl6p) ```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":"Query Delta Lake natively using BigQuery","url":"https://daily.dev/posts/query-delta-lake-natively-using-bigquery-qohb7nl6p","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/query-delta-lake-natively-using-bigquery-qohb7nl6p"},"datePublished":"2026-08-16T08:53:26.800Z","dateModified":"2026-08-16T08:55:49.495Z","description":"BigQuery now natively integrates with Delta Lake's transaction log, letting users query Delta tables directly without the older manifest-based approach that...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/737afb584caac51b835a22970ced26c0?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/737afb584caac51b835a22970ced26c0?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Delta Lake Blog","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":"Delta Lake Blog","logo":"https://media.daily.dev/image/upload/s--7f2q9Asf--/f_auto,q_auto/v1786870393/logos/delta-lake?_a=BAMAMicg0","url":"https://daily.dev/sources/delta-lake"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/query-delta-lake-natively-using-bigquery-qohb7nl6p","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"data-engineering,google-bigquery,apache-iceberg","timeRequired":"PT3M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Delta Lake Blog","item":"https://daily.dev/sources/delta-lake"},{"@type":"ListItem","position":3,"name":"Query Delta Lake natively using BigQuery"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/query-delta-lake-natively-using-bigquery-qohb7nl6p#faq","mainEntity":[{"@type":"Question","name":"How does BigQuery query Delta Lake tables now compared to the old manifest-based method?","acceptedAnswer":{"@type":"Answer","text":"BigQuery now parses Delta log metadata directly at query time instead of relying on a manifest file. The previous manifest-based approach required manual refreshes and could suffer from read staleness; the new native integration through BigLake eliminates those staleness limitations and enables optimized query planning and improved performance. daily.dev surfaces updates like this for teams weighing lakehouse query engine options."}},{"@type":"Question","name":"Which cloud storage platforms support querying Delta Lake tables in BigQuery?","acceptedAnswer":{"@type":"Answer","text":"BigQuery can query Delta Lake tables stored on Amazon S3, Azure Blob Storage, ADLS Gen2, and Google Cloud Storage, with this functionality in public preview. For tables on Amazon S3 or ADLS Gen2, BigQuery Omni processes the data locally in that respective cloud for performance and cost benefits. Track multi-cloud data lake capabilities like this on daily.dev as they move out of preview."}},{"@type":"Question","name":"How do I set up fine-grained security on Delta Lake tables queried through BigQuery?","acceptedAnswer":{"@type":"Answer","text":"Fine-grained row and column-level permissions, plus data masking, can be configured on Delta tables through BigLake, which enforces a consistent security model across BigQuery storage, Amazon S3, Azure Data Lake Storage Gen2, and Google Cloud Storage. Permissions can be set with SQL statements directly or centrally managed at scale using Dataplex, which pushes policies down to BigLake. Engineers designing governance for lakehouse data can follow security model updates on daily.dev."}}]} ```