Skip to main content

DISCOVER, CONNECT, GROW

Microsoft Reactor

Join Microsoft Reactor and engage with startups and developers live

Ready to get started with AI?  Microsoft Reactor provides events, training, and community resources to help startups, entrepreneurs and developers build their next business on AI technology. Join us!

DISCOVER, CONNECT, GROW

Microsoft Reactor

Join Microsoft Reactor and engage with startups and developers live

Ready to get started with AI?  Microsoft Reactor provides events, training, and community resources to help startups, entrepreneurs and developers build their next business on AI technology. Join us!

Go back

Better Together: Elasticsearch and the Dremio Lakehouse

16 July, 2024 | 12:30 AM - 2:30 AM (UTC) Coordinated Universal Time

Location: Redmond

Address: Redmond Reactor 3709 157th Ave NE, Redmond, WA 98052

  • Format:
  • alt##In personIn person (Redmond)
  • alt##LivestreamLivestream

Topic: Modern Data and Analytics

Language: English

Join us on Monday, July 15th, for a Seattle Elastic User Group meetup with Dremio. Alex Merced (Developer Advocate at Dremio) and Justin Castilla (Sr. Developer Advocate at Elastic) will present, followed by networking, light bites, and refreshments.

Agenda:

  • 5:30 pm: Doors open; say hi, grab a seat, and eat some food.
  • 6:00 pm: Better Together: Elasticsearch and the Dremio Lakehouse - Alex Merced (Developer Advocate at Dremio)
  • 6:30 pm: Talk # 2 - details coming soon! - Justin Castilla (Sr. Developer Advocate at Elastic)
  • 7:00-7:30 pm: Networking & refreshments
  • 7:30 pm: Event ends

Talk Abstracts:

Better Together: Elasticsearch and the Dremio Lakehouse - Alex Merced (Developer Advocate at Dremio)

The synergy between Elasticsearch and the Dremio Lakehouse emerges as a transformative approach for analytics. This talk, titled "Better Together: Elasticsearch and the Dremio Lakehouse," delves into the innovative integration of Elasticsearch as a dynamic source within Dremio's platform. By harnessing Elasticsearch's powerful search capabilities alongside Dremio's efficient data lakehouse architecture, organizations can achieve a seamless, high-performance analytics environment.

The integration supports Elasticsearch versions 6.x and 7.x, with Dremio. This collaboration enables users to plan and execute queries efficiently by leveraging Elasticsearch's rich metadata, including dataset discovery and details for enhanced query planning and execution.
Furthermore, Dremio's elastic connector provides a user-friendly perspective of Elasticsearch indices and mappings, simplifying data access and analysis.

Key highlights include exposing data through Elastic aliases, support for synthetic tables via wildcards, and the parallelization of queries to optimize data retrieval speeds.
The talk will cover Dremio's list promotion rules, special handling for geoshape data types, and how it maintains mapping consistency through schema learning and automatic discovery of new fields. Additionally, we will explore the extensive pushdown capabilities that allow for efficient query execution directly in Elasticsearch, reducing data movement and accelerating insights.

This session aims to provide attendees with practical knowledge on configuring and optimizing the Elasticsearch source within Dremio, ensuring a unified and efficient analytical platform. We will also touch on the technical considerations for integrating Elasticsearch with Dremio, including configuration specifics, debugging, logging, and working with Elasticsearch and x-pack.

By the end of the talk, participants will be well-equipped to leverage the combined strengths of Elasticsearch and Dremio, creating a robust foundation for their data lakehouse analytics endeavors.

For questions please contact us at reactor@microsoft.com