grafana mongodb time seriesgrafana mongodb time series

MongoDB, Inc. (MDB) Q1 2024 Earnings Call Transcript Operating cash flow in the first quarter was $53.7 million. I wanted to also follow up on margins with respect to Atlas. So in the context of large language model applications and customers trying to build applications with large language models and the rules of vectors and vector databases, from your guys' perspective, is this a use case that MongoDB can address? Next, let's insert a document that stores multiple pieces of metadata in the meta field. Thanks. Good afternoon, and thank you for joining us today to review MongoDB's first quarter fiscal 2024 financial results, which we announced in our press release issued after the close of market today. The primary reason for our strong operating income results versus guidance is our revenue outperformance. I'm Grot. Let's examine some of the new operators and a stage that were added in version 5.0 to make working with dates and times easier. Thinking about a long-term opportunity, I feel exceptionally confident about our core underlying growth driver, the need for companies to use software as a competitive advantage. MongoDB Monitoring with Grafana & Prometheus - devconnected Wouldnt it be great to monitor your MongoDB so you can quickly see, at a glance, everything that is happening under the covers? Thank you. Can you hear me all right? Setting Up Grafana MongoDB Integration: 4 Easy Steps Thanks. non-null value. These operators and stages are available for all collections time series or regular. Joining me on the call today are Dev Ittycheria, President and CEO of MongoDB; and Michael Gordon, MongoDB's COO and CFO. And so I will clearly say it wasn't AI that drove the acquisition of workloads. We believe AI will be the next frontier of development productivity -- developer productivity and will likely lead to a step-function increase in software development velocity. That being said, our revenue is driven by usage, so when usage goes up, our revenue goes up. Is it fair to assume that, in next couple of quarters, consumption level may reset at a new normal and then maybe resume growth from that level? That's focus on the input metrics that drive the outputs that you see. The examples in this section use these variables and Grafana functions: Check out this video for a step-by-step walk-through on creating Thank you taking my question and congrats on a great quarter. They are looking at data over a time interval with hourly or daily ranges. I wanted to sanity check. In this example of time series data that captures stock trading information, we have the date as the time classifier and the stock symbol as the identification field while information like open and close prices are the measurements in this case. And we do that not just from our sales organization but also from our self-serve business. This post has been updated to reflect changes in the availability of the MongoDB data source plugin for Grafana Cloud users. Heres a look at some of the things you can do with the MongoDB data source: Lets take a look at some sample data, from a database called sample_mflix, provided by Many customers are turning to MongoDB to free up their developer's time for innovation, enabling them to move faster and deliver better customer experiences, while driving cost-savings. A Detailed Guide to Key Metrics of MongoDB Monitoring That's part of what led to the early renewal and extension given the success of the joint offering. two dimensions. And that's it for me. Thank you. While not all data is time series in nature, a growing percentage of it can be classified as time series. Let's start with Atlas. I - What You Will Learn II - MongoDB, Grafana and Prometheus Architecture III - Installing The Different Tools a - Installing Prometheus b - Installing the MongoDB exporter c - Enabling MongoDB authentication Wouldnt it be cool to quickly see everything you ever wanted to know about a certain movie?The poster, ratings, awards, reviews, plot, writers, directors, etc.? Yes. I have a mongodb collection with 2 arrays per document. So we are seeing -- again, part of acquiring a workload is acquiring a relational workload and replatforming it on MongoDB, so when we say acquiring a workload, you should not always assume it's a new workload. And I want to be clear. Please disable your ad-blocker and refresh. Time-Series Data - Step-by-Step - Read the Docs I don't want to preempt what we're going to be talking about on June 22, but I encourage you to attend because that's where we'll share a little bit about our AI strategy. I will start by reviewing our first quarter results before giving you a broader company update. So what I would say is, when we look at it, you've got a higher starting Q2 ARR as a result of the strong Q1 performance. Thanks. And I saw -- and I think you've seen the results of that showing up in Q1. Thanks for the question, Howard. With that, I'd like to turn the call over to Dev. In $group, documents are grouped together and then calculations are performed on each group. And so that's just a very different dynamic when you start thinking about less from the income statement but more kind of away from the other parts of the balance sheet and some of the other calculations that you all do. Maybe, the first one on the consumption trends. Our gross margin progression plan, particularly as it relates to Atlas has been very strong. To summarize, MongoDB delivered strong first quarter results in a difficult environment. Thank you very much. You have to -- thanks for your question, Mike. It was really sharp execution by go-to-market teams. And then we also just don't just focus on acquiring but also making sure they're onboarded properly, they're serviced properly so that those workloads grow well and the customer's experience with those workloads is very positive so they continue to add new workloads to our platform. A better alternative is to Dev, last quarter you talked about a couple of very large financial institutions beginning to migrate, I believe it was hundreds of apps. And obviously there'll be puts and takes in every quarter, but our go-to-market organization is very, very focused on this. You may have noticed the dropdown for selecting the movie. At Grafana Labs, weve been working hard to help you build rich context with new data sources like ServiceNow, GitHub, and Snowflake, and were excited to expand your library of available data even more. And so recently, we heard from another data platform [indiscernible] seeing some of the customers move data out of the platform to maybe economize on costs. I think the journey to the cloud is far from over. The growth in our total customer count is being driven primarily by Atlas, which had over 41,600 customers at the end of the quarter compared to over 33,700 in the year-ago period. It's all about acquiring workloads, so our incentive mechanisms, management attention and focus is all about this North Star about acquiring new workloads. That drove more consumption and so that's what drove the outperformance. I have Grafana v8.3.2. points. Using the following query, we can look at movie production over the last two decades. In terms of what's happening in terms of the macro environment, I definitely agree with you that it's tough out there, but what we see is innovation is still a priority. But as the user numbers increase, performance degraded. It now appears that you have a cadence where you -- despite challenging consumption trends on a per-customer basis, you've been able to add new customers at record pace, so results have been actually quite resilient. As we said, our consumption is tied to the application usage. Examples are weather measurement data and stock trading data. The Q2 days, it does affect because it's consumption and it's recognized as it's utilized. With a bucket_interval of 30 minutes and a date range of Last 30 days, And then one quick last one for you, Michael, on the gross margin outlook. And you're running now in the mid-70s. And so we do face very difficult compares throughout the year on enterprise advanced. I'll be discussing our results on a non-GAAP basis unless otherwise noted. This further strains So you're correct. We are incredibly excited about the opportunity ahead and we'll continue to invest responsibly to maximize our long-term value. Time-series data includes several metrics, such as: gauge, a metric that maintains a value until it changes; counter, a metric that tracks increments over time; . Below is a list of six best practices for working with time series data in MongoDB: Time series data is everywhere, but storing and querying it can be challenging. For the second quarter, we expect revenue to be in the range of $388 million to $392 million. MongoDB supports the idea of "Compound Variables", which enable you to use one variable as multiple variables to perform complex multi-key filters. Prior to version 5.0, MongoDB had a suggested data model for time series data. Let me provide some context on Atlas consumption in the quarter. And again -- so that drives us to go acquire more workloads, high-quality workloads, that we can then onboard quickly. This could be server metrics, application performance monitoring, network data, sensor data, events, clicks, trades in a market, and . Thanks. Time series data is generally composed of these components: Time when the data point was recorded. Time series data are measurements taken at time intervals from one or more sources. That's part of the reason why we talk about and go to great pains to explain the EA compares and some of those other things. The big driver of the improved bottom line output is the stronger Q1 performance and then the upgraded revenue outlook and it's really just sort of flowing through to the P&L. Yes. This makes MongoDB and MongoDB Atlas a compelling store for large volumes of time series data. And I would argue that there's an emerging trend that Atlas is one of the preferred places for AI companies to go to build apps, and so we feel really good about our positioning. And there are some adjunct solutions out there that have come out that are bespoke solutions but are not tied to actually where the data resides, so it's not the best developer experience. And one for you, Michael. And when we look at where we are now and the outlook, I think that's the right view, so I don't think that there's any particular data that would point to things suddenly becoming better or becoming materially worse. Though it's not generally considered a true time series database per se, its creators often promote its use for time series workloads. I think your long term -- unless it changed, I think it was 70%. This includes China Mobile, Tata Digital and Grant Thornton International. And I think you're going to see a lot of things happening over the course of the next few months and quarters and years, but we feel we're in a very good position to take advantage of this new trend. So that's really what's happening in terms of what's driving our revenue. We have this very close value linkage, and so it maps quite tightly to the underlying application usage for our customers and their end users. For example, in Q1, more than 200 of the new Atlas customers were AI or ML companies. Thank you. That's helpful. [Operator Instructions] Our first question comes from the line of Raimo Lenschow of Barclays. You are correct. So those are the drivers and that's a big focus for us as well. Innovate fast at scale with a unified developer experience, Webinars, white papers, datasheets and more. It Grafana Time Series Panel mongodb chankim9696 March 22, 2023, 9:28am 1 Hi! Requirements This plugin has the following requirements: A MongoDB instance with at least one user One of the following account types: Grafana Cloud: Pro customers, Advanced customers, or Pro trial users with the Enterprise plugin add-on enabled Here is a single document example of a stock trading measurement: Generally, time series data includes the time and measurement, as well as other identifying information such as the source of the data. The MongoDB shell will return one document: MongoDB optimizes the data, as it stores data ordered by time as opposed to the natural order in regular collections. And so I think I feel significantly more confident in delivering against that now that we've got Atlas at a much higher percent of the revenue. You can improve query performance by adding secondary indexes on the metaField and/or the timeField. Atlas now has -- about 80% of Atlas does not flow through deferred. See the official MongoDB documentation on configuring online archives for more information. MongoDB is one of the most popular NoSQL databases in the world, used by millions of developers to store application metrics from e-commerce transactions to hospital equipment inventory, from user logins to World War I diaries. MongoDB databases contain mountains of information that SREs, software engineers, and executives can visualize to run their businesses more effectively. two separate panels with 2 separate symbol variables. This extends that contract. But where should the ever-increasing volume of time series data be stored? Therefore, our starting Atlas ARR for Q2 is higher. It sounded like from what you guys are saying that you guys are executing well, but things are still pretty tight from a budget environment perspective. Gross profit in the first quarter was $279.9 million, representing a gross margin of 76%, which is up from 75% in the year-ago period. And the reason being is that as developer productivity increases, the volume of new applications will increase, which by definition will create new apps, which means more data stores. In this step, you will build a dashboard to visualize your MongoDB data in Grafana. You can capture all of that. So what I'd say is we have -- I would just say, when we look at our outlook, there's no reason, based on the data that we have, to assume things get materially better or materially worse. Install forever-mac; Copy server/mongodb-grafana-proxy.plist to ~/Library/LaunchAgents; run launchctl load mongodb-grafana-proxy from ~/Library/LaunchAgents; This launch ctrl plist runs the node script via forever. Thank you. So that is a tailwind to Q2 relative to Q1 by those few extra days. Thank you. Making a timeseries graph for each document in my mongodb collection Thank you. And that's consistent with what we thought in last quarter's call, when we provided our initial view. Please. Turning to Enterprise Advanced. 7 Powerful Time-Series Database for Monitoring Solution - Geekflare Over the time since we've launched it, we've seen an 8 times increase in their end user consumption. This compares to free cash flow of $8.4 million in the first quarter of fiscal 2023. The MongoDB plugin provides an editor where you can write/paste your MongoDB queries. The value of $averageMonthClosingPrice is the average of the previous month's closing price for the indicated stock symbol. Moreover, the shift to AI will favor modern platforms that offer a rich and sophisticated set of capabilities, delivered in a performance and scalable way. It integrates with a variety of time-series databases including CrateDB It is available licensed under the Apache License 2.0. And I just think it's important to understand that because you can see the slower growth rate on EA shining through in Q1. I appreciate the comments, Dev. As I've said many times in the past, a durable competitive advantage is built through custom software, it cannot be obtained with an off-the-shelf product. Grafana Labs uses cookies for the normal operation of this website. But why did we see that sequential decline in deferred revenue that we haven't typically seen? Learn how to store and analyze your time series data using a MongoDB cluster. Adjust the time range of your Yes. Lets run a query to see some more recent movies. We have seen those historically. With the Grafana MongoDB plugin, weve shown that its possible to quickly visualize and observe not only MongoDB data, but also diagnostic metrics. In the selection options, select Multi-Value. We added 2,300 customers this year. Thank you. Data will be removed after a document date value reaches now - expireAfterSeconds.. but doesn't connect the values over the weekend. I think the other thing that's important to understand in terms of the financials is really the cash flow dynamics and understanding that. Implementing Time Series in MongoDB - DZone Consider a stock day trader constantly looking at feeds of stock prices over time and running algorithms to analyze trends to identify opportunities. In summary, I'm pleased with our first quarter results in a difficult macro environment. There's got to be some compelling event for a customer to do so. Consider the original stock data example: For this example, the dowJonesTickerData collection is using date as a timeField and symbol as a metaField. I mean, are you at a point where the new customer momentum more than offsets declining consumption growth trends that you have better visibility into your business than you did probably, say, a year back, six months back? Our income from operations was $43.7 million, or 12% operating margin for the first quarter compared to a 6% margin in the year-ago period. Yes, what I would say is, I think, in the short term, the consumption trends are clearly tied to our customers' underlying business. dashboard if desired. The -- in terms of the broader assumptions, the primary driver of the increase in the fiscal 2024 full year guide is the fact that Atlas outperformed in Q1. Or is that more something we should expect in the coming quarters? First, on the $10 million onetime lift from Alibaba, if you could just clarify the entirety of that lens in other subscription. MongoDB, Inc. (NASDAQ:MDB) Q1 2024 Earnings Call Transcript June 1, 2023 5:00 PM ET, Dev Ittycheria - President & Chief Executive Officer, Michael Gordon - Chief Operating Officer & Chief Financial Officer, Thank you for standing by, and welcome to MongoDB's First Quarter Fiscal Year 2024 Earnings Conference Call. Your question please, Tyler. We can see that this data set does not contain any movies after 2015, so that explains it. As we've talked about for the last several years, we've been deemphasizing upfront commitments, trying to reduce the level of friction, trying to focus on acquiring more workloads and getting more workloads on the platform. Use time series collections with time series data when possible. With the new $setWindowFields operator, you can calculate a rolling average of the closing price over the last 30 days for each stock: The result of running the above aggregation is a set of documents. SELECT time_bucket_gapfill('$bucket_interval', time) AS time, GROUP BY time_bucket_gapfill('$bucket_interval', time), Create multiple time-series graphs in a single panel. Select Time series as your visualization type. No, I would say generally consistent is what we've seen. Obviously all that's factored into the full year guide, and you can see the significant upgrade in the bottom line outlook. We're all trying to get a sense of where are we in sort of the cloud optimization budget scrutiny sort of cycle. We're very excited about the prospects of relational migrator and helping to reduce the cost and time to migrate relational apps to MongoDB, but we're still early in that journey. In addition, it is frequently updated, and devops friendly. However, EA revenues were up sequentially, which is better than what we had anticipated in our Q1 guidance. Okay. value of your data. But first, you need rows containing null values wherever you have Time series database (TSDB) explained | InfluxData I think, as your company is going through a transition from, of course, like more term licenses, towards Atlas being more of a consumption-based model, it's exciting to see the margin upside flowing through as revenue is coming through, but I wanted, I think, a refresher on how to think about just essentially unit -- sorry, just on how to think about margin progression with Atlas in play. The plugin supports template variables, which allow that feature. Total revenue in the quarter was $368.3 million, up 29% year-over-year. Because the provided link is a kind of node-exporter for Prometheus. CPU, memory, and network bandwidth. Grafana dashboards are most effective when they are layered with context. I just wanted to follow up on Raimo's question on AI. Time series collections are a new collection type introduced in MongoDB 5.0. Second, we expect to see a sequential decline in the EA business after a stronger than expected Q1. With regards to time series and some of the other capabilities, we feel really good about the platform. And then that drives future usage, so that's the real focus for us. Thank you very much. I would just add, we were expecting enterprise events to be down. Sure. Try free Learn more about Atlas Time series data is generated everywhere from social media to stock tickers to IoT devices. And so that's what sort of gave them and obviously us collectively the confidence to sort of extend that. They're the same length as eachother, and the FRAME array simply ascends from 0 (eg. Your question please, Brent. I apologize. Each measurement inserted should be a single measurement, either as individual documents or batches of documents with one measure per document. Thanks, Brian, and thank you to everyone for joining us today. allows you to see trends and fluctuations in your data. Step 3 Building a MongoDB Dashboard in Grafana. How it can be resolved? I'll see you guys in New York in June. Moving on to Atlas consumption trends. These statements are subject to a variety of risks and uncertainties, including the results of operations and financial conditions that could cause actual results to differ materially from our expectations. MongoDB is a document-oriented database which means it works on principles of dealing with "documents"; it allows you to express data in its natural form, the way it's meant to be. That's the first part. It's a much more graceful migration than having to replatform on to another technology when they want to move that workload to the cloud. Our next question comes from the line of Kash Rangan of Goldman Sachs. weekdays, there are large gaps in the dataset where there is no data. Great, blocking and tackling and walking while chewing gum. The only way we can really influence that is, over the long term by acquiring more and more workloads either through from existing customers or acquiring new customers. So we're all excited about this AI theme. I wouldn't particularly call out a particular spike up. Quickly search through all your logs or stream them live. OK, lets look at some time series data! We can use the $dateTrunc to truncate the dates to the appropriate month. First, I'll start with our first quarter results. graph makes it easy to see if the value of a stock is going up or down. Thanks very much. Get started working with time series data in, MongoDB 5.0 has an optimized time series collection type which is designed to efficiently store and consume time series data. And then Michael, real quick. MongoDB plugin for Grafana | Grafana Labs After taking into consideration approximately $2 million in capital expenditures and principal repayments of finance lease liabilities, free cash flow was $51.8 million in the quarter. Is this happening to you frequently? Right away you might have noticed movie production steadily increased then dropped off after 2014. For the full fiscal year 2024, we expect revenue to be in the range of $1.5 billion to $2 billion to $1.542 billion. Using the following query, we can look at movie production over the last two decades. Yes. Yes. change to your query. We see that customers really want to leverage software as a competitive advantage. This returned approximately 3 800 data points. Our new business performance and strong total customer net additions demonstrate the continued demand for our developer data platform. Thank you, Latif. Or do you see pockets of workloads where that might occur on MongoDB's platform as well? And then I've got a quick follow-up. You should also include the following options: Lastly, you may want to include this option if you would like to remove data after a certain time has passed: The following example creates a time series collection named dowJonesTickerData where the timeField is date and the metaField is symbol: Each document that you add to the time series collection will need to specify at least the timeField. In this article, you'll learn what time series data is, how you can store and query time series data in MongoDB, and what the best practices are for working with time series data in MongoDB. Your question please, Jason. Nearly every company needs to query, analyze, and report on time series data. As you know, we will be facing very difficult EA compares throughout fiscal 2024, and Q1 was no exception as evidenced by our slower year-over-year EA revenue growth. I have Grafana v8.3.2. time_bucket hyperfunction. What your Grafana - Prometheus - MongoDB exporter will look like; How to install Prometheus, a modern time-series database on your computer; How to configure import a MongoDB dashboard in seconds; How to set up the MongoDB developed by Percona as well as binding it to MongoDB; Shifting to our product mix. What is the hourly stock price of AMD today? And maybe how you're preparing your go-to-market team to tackle that opportunity. I just wanted to ask about the linearity of consumption through the quarter and then any comments you have on consumption in the month of May? I need to display some stat in time series in format, when I choose 1 year interval it should display info grouped by months (12 data points), when 1 month interval (30-31 data points) grouped by days, when 1 day (24 data points) grouped by hours. Learn how to store and analyze your time series data using a MongoDB cluster. Or it could be that they're -- they can't add new features fast enough on a brittle legacy platform so they need to migrate to a new modern platform where they continue to service their own business well. To ensure this doesnt happen in the future, please enable Javascript and cookies in your browser. Grafana returns this graph: Because the stock market is only open from 9:30AM to 4:00PM on Otherwise, you get an error. of AMD stock in a 3-month period, you get approximately 1,500,000 data Each document in the results will contain a new field: $averageMonthClosingPrice. Maybe this will go to Mike. Of our total customer count, over 6,700 are direct sales customers, which compares to over 4,800 in the year-ago period. If you want to enable search on multiple metadata fields (e.g., symbol and company), we recommend updating your data model. I know you said that execution was great, which is awesome. I think people tend to overestimate the impact of new trends in the short term but underestimate them in the long term. For example, let's drop our existing dowJonesTickerData collection and create a new one that has a metaField named "meta.". Sorry. What are some things we might want to monitor? Now I'd like to spend a few minutes reviewing the adoption trends of MongoDB across our customer base. Grafana Cloud timestamp, mongodb srvajpe November 28, 2022, 12:26pm 1 I have data for every millisecond stored in MongoDB. Yes, sir. Mike, if we could unpack the 2Q guide a little bit. And Q1 tends to be a seasonally slower quarter for new EA business. It does show up in that kind of other, other line, so it's not showing up in Atlas or in the EA line items, just for sort of clarity around the geography. Digital transformation is redefining how organizations operate, and MongoDB is helping customers on this journey by delivering the developer data platform that powers the migration from on-premises to the cloud. Thank you for participating. And we plan to do a pretty broad set of announcements at our MongoDB.local New York on June 22, so stay tuned for some announcements then. We saw a strong quarter of customer -- of direct customer additions in our enterprise channel. They use software to deliver their core value proposition, provide customers with great experiences and drive operational efficiency.