Maximizing BigQuery’s Manifest Support: A Guide to Leveraging Apache Hudi & Delta Lake Open Table Formats

Maximizing BigQuery’s Manifest Support: A Guide to Leveraging Apache Hudi & Delta Lake Open Table Formats

Maximizing BigQuery’s Manifest Support: A Guide to Leveraging Apache Hudi & Delta Lake Open Table Formats

As Seen On

BigQuery’s scope in the realm of data engineering has grown significantly with the advent of its manifest support. This new attribute has made the handling of open data table formats more manageable, paving the way for increased efficiency and flexibility in the field. Among these ground-breaking open table formats are Apache Hudi and Delta Lake, both of which can now benefit from BigQuery’s manifest file support, thus accelerating the path to data optimization.

Open table formats utilize embedded metadata to organize and communicate data between sources. This ability to harness the inherent meta-level features is what helps in generating manifest files pertinent to the data processing workflow. This process has gained momentum with BigQuery, which now fully supports these manifest files, currently transforming the data engineering landscape.

Stepping into the specifics, BigQuery utilizes the SymLinkTextInputFormat for its file support. The more in-depth details of this format reveal a filesetspec_type flag, primarily employed when a table’s partition specification matches that of a table or view in the Hive metastore. An additional facet is the feature of partition pruning for Hive-style partitioned tables, contributing significantly to the reduction of data amount required to process a query and optimizing finite data resources.

Creating a BigLake table using a manifest file demonstrates this effectively. However, one must note that it requires the same security permissions as accessing the files directly via SymLinkTextInputFormat, thus providing a secured environment for data handling.

Taking a closer look at Apache Hudi, we see a potent tool for managing big data workloads in near real-time. Hudi tables can be queried from BigQuery as external tables using the Hudi-BigQuery Connector, integrating these powerful resources seamlessly. However, current Hudi-BigQuery integrations have faced challenges in the realm of query processing optimizations due to the substantial volume of big data workloads.

Manifest support is what bridges this gap. Upgrading the Hudi-BigQuery Connector to leverage BigQuery’s manifest file support can significantly help overcome such obstacles, fostering quicker and more efficient processes for handling vast amounts of data.

Let’s dive into the step-by-step guide on how you can achieve this. The first involves downloading and building the BigQuery Hudi connector. This crucial step ensures the initial groundwork for harnessing the power of BigQuery and its open data formats. Next is the execution of the Spark application, which generates a BigQuery external table, augmenting the ease of data accessibility and operations.

Conclusively, it becomes evident how BigQuery’s manifest support has become imperative for open table formats like Apache Hudi and Delta Lake. By optimizing the inherent strengths of these platforms and fine-tuning the way they handle big data, BigQuery’s manifest support proves crucial for Big Data Engineers, Data Scientists, and IT professionals who aim to streamline data operations and maximize efficiency. Currently, the manifest file support in BigQuery offers a vital solution, holding the promising potential of revolutionizing big data management for the future.

Casey Jones Avatar
Casey Jones
12 months ago

Why Us?

  • Award-Winning Results

  • Team of 11+ Experts

  • 10,000+ Page #1 Rankings on Google

  • Dedicated to SMBs

  • $175,000,000 in Reported Client

Contact Us

Up until working with Casey, we had only had poor to mediocre experiences outsourcing work to agencies. Casey & the team at CJ&CO are the exception to the rule.

Communication was beyond great, his understanding of our vision was phenomenal, and instead of needing babysitting like the other agencies we worked with, he was not only completely dependable but also gave us sound suggestions on how to get better results, at the risk of us not needing him for the initial job we requested (absolute gem).

This has truly been the first time we worked with someone outside of our business that quickly grasped our vision, and that I could completely forget about and would still deliver above expectations.

I honestly can't wait to work in many more projects together!

Contact Us


*The information this blog provides is for general informational purposes only and is not intended as financial or professional advice. The information may not reflect current developments and may be changed or updated without notice. Any opinions expressed on this blog are the author’s own and do not necessarily reflect the views of the author’s employer or any other organization. You should not act or rely on any information contained in this blog without first seeking the advice of a professional. No representation or warranty, express or implied, is made as to the accuracy or completeness of the information contained in this blog. The author and affiliated parties assume no liability for any errors or omissions.