Chapter 3: Storing Data
Now that you have created datasets, we will walk through how the data is stored and accessed in the Domo cloud. Domo, by design, enables an iterative and adaptive approach to data storage. The essential storage structure of a dataset is something that would look like a typical Excel spreadsheet. One advantage that this simplicity offers is that dataset schemas are derived from the data as it is ingested: when data is changed at the source, the schema is also automatically updated. That is kind of a big deal because in traditional data warehousing, it was all about rigid schema building and compliance – which, honestly, was slow and failed to deliver business value at cloud speed. So, although you can enforce highly normalized schemas in Domo, there is simply not a pressing business reason to do so. In fact, many Domo customers find that a year or so into the implementation, their Domo instance has organically accumulated more tabular data than their legacy...