Firebolt

?? Master Primary Indexes in Firebolt ?? Indexes aren’t just a feature; they’re a game-changer for query performance. Firebolt’s Primary Indexes let you: ? Dramatically reduce query latency ? Optimize data pruning and scanning ? Handle massive datasets with precision In this blog, Hiren Patel (Head of Product) breaks down: - How primary indexes work in Firebolt. - Strategies for designing and selecting the right indexes for your workloads. - Common use cases and best practices for optimization. ?? Read, listen, and optimize: https://lnkd.in/gjr-4WxD #DataEngineering #CloudDataWarehouse #FireboltTech #PerformanceOptimization #Indexes

?? Simplified Role-Based Access in Firebolt ?? Managing data access shouldn’t be a headache. Firebolt’s Role-Based Access Control (#RBAC) makes it easy to secure and manage permissions at scale. ? Hierarchical Access: #permissions cascade for simpler management ? Granular Control: Assign #roles with specific privileges ? Global & Regional Scopes: centralized yet flexible Enhance #security, streamline #access, and stay in control. ?? Read the article here from Adam Bouhmad to learn more: https://lnkd.in/edykJXJA #datasecurity #accesscontrol #datagovernance

Firebolt is expanding into #APAC ???? We're bringing our high-performance, low-latency data warehouse into one of the most exciting and fast-growing markets. Leading the charge will be Sandeep Mathur, our new Managing Director for APAC who will drive regional go-to-market and build global teams based in #India. ?? Read the full announcement: https://lnkd.in/dnjF7GKD ?#datawarehouse #analytics #gotomarket

AI isn’t just transforming how we analyze data—it’s changing how we move it. ??? In our latest episode, Daniel Palma from Estuary joins us to break down the future of data movement and AI. Learn more about: ?? How #AI is optimizing large-scale data movement ?? The rise of #vectordatabases and structured data in #AIapplications ?? What’s next for #ApacheIceberg and the evolution of the #datalakehouse Tune in: https://lnkd.in/d8yK5NmB Spotify: spoti.fi/42Ss5jQ

What does it take to build high-performance geospatial analytics? ???? Processing location data at scale is notoriously complex. So when we built #geospatial support in Firebolt, we needed a solution that handles massive datasets with precision—without sacrificing speed. ?? GEOMETRY vs. GEOGRAPHY – key accuracy trade-offs ?? S2 Geometry for efficient spatial indexing ?? Challenges of integrating #geospatialdata at scale In this blog, Demian Hespe takes you inside how we built Firebolt’s geospatial capabilities—and why it’s a game-changer for anyone working with spatial data. ?? Read here: https://lnkd.in/dP7QxYwr #geospatialanalytics #dataengineering #clouddatawarehouse

Location data just got Firebolt Fast ??? Announcing public preview of geospatial analytics in Firebolt—bringing low-latency, high-performance spatial data processing to the modern cloud data warehouse. ?? Run large-scale #geospatial queries with consistently low latency ?? Leverage S2 geometry for efficient spatial #indexing (coming soon) In this launch blog, Tara Shankar Jana "TJ" unpacks the key benefits, use cases, technical details of Firebolt’s geospatial engine. He also shares a cool #demo with the code, #SQL available on #Github. ?? Read it here: https://lnkd.in/dPsm-iHV #geospatialanalytics #dataengineering #clouddatawarehouse

Video: Integrating Metabase with Firebolt Here's a step-by-step guide on how to connect Metabase to Firebolt, enhancing your data visualization?with our high-performance query engine. Whether you're looking to prototype, test, or go into production, this integration offers: - Direct access to Firebolt's speed for your Metabase queries - Simplified data exploration and dashboard creation - Scalability for your analytics needs without compromising on performance Check out the video demo from Jonathan L. for a technical walkthrough. For more information about this integration, visit: - Documentation:?https://lnkd.in/gATyUBke - Integration Page:?https://lnkd.in/g8vYNCqx - For more learning videos: https://lnkd.in/gmvb9HcC #DataVisualization #Metabase #Firebolt #DataWarehouse #QueryPerformance

Got data engineering questions? We’ve got answers. Introducing The SQL Clinic! ?? Firebolt’s new open office hours kick off this Wednesday at 9:30 AM PST, where Solution Architect Connor Carreras and Firebolt Field Team’s Guy Duer will answer your toughest questions about #SQL, Firebolt, and #dataengineering. ? Optimizing slow #queries? ? Designing complex #datamodels? ? Looking for #bestpractices? This is your chance to bring real-world challenges and get practical solutions—straight from the experts. No slides, no marketing—just hands-on problem-solving. Drop in, ask your questions, and leave with answers you can use. See you Wednesday!

We had the incredible honor of hosting Magdalena Balazinska for Firebolt’s first-ever external speaker event, organized by our internal women’s group, #SHEQL! Magdalena is the Director of the Paul G. Allen School of Computer Science & Engineering at the University of Washington and holds the prestigious Bill & Melinda Gates Chair. A trailblazer in the field of database management systems, she has earned numerous accolades, including the Microsoft Research New Faculty Fellowship (2007), the VLDB Women in Database Research Award (2016), and the ACM #SIGMOD Test-of-Time Award (2017) for her groundbreaking work in fault-tolerant #distributedstreamprocessing. Magdalena shared her inspiring journey with us from her early fascination with #engineering in her hometown in Poland to earning her Ph.D. at MIT and becoming a leader in academia. She also offered invaluable insights into fostering opportunities for #womeninengineering and discussed her team’s current cutting-edge research in #datasystems, #cloudcomputing, and image and video analytics. Magdalena created a space for us at Firebolt to reflect on and have meaningful conversations about creating an inclusive and empowering environment within tech. A heartfelt thank you to Magdalena for sharing your story, insights, and expertise with us. You’ve not only inspired our team but also paved the way for what we hope will be the first of many events spotlighting remarkable #femaleleaders in tech here at Firebolt! Her profile at UW: https://lnkd.in/dGF9fxJv

Join Mosha Pasumansky, CTO of Firebolt, as he explains how we implemented geospatial?? SQL support in Firebolt. Wanna find where something happened? You can do that. Wanna find where it didn't? You can do that, too. Watch the full video now: https://lnkd.in/gVgKdB6A He explores things like the differences between SQL geometry (map projections ???) and geography (modeling the earth as round), utilizing Google's open source S2 library, and calculating cell covers for polygons to optimize certain functions.