Skip to main content

LEARN, CONNECT, BUILD

Microsoft Reactor

Join Microsoft Reactor and engage with developers, entrepreneurs, and startups live

Ready to get started with AI and the latest technologies? Microsoft Reactor provides events, training, and community resources to help developers, entrepreneurs and startups build on AI technology and more. Join us!

LEARN, CONNECT, BUILD

Microsoft Reactor

Join Microsoft Reactor and engage with developers, entrepreneurs, and startups live

Ready to get started with AI and the latest technologies? Microsoft Reactor provides events, training, and community resources to help developers, entrepreneurs and startups build on AI technology and more. 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.

Related Events

The events below may be of interest to you as well. Be sure to visit our Reactor homepage to see all available events.

For questions please contact us at reactor@microsoft.com