Chapter 2: Data Loading, Saving, and File Formats
Most of the data in the world is saved in files or databases, in local or remote sources. In this chapter, we will learn how to load data from multiple formats and data sources and how to save it, while looking at every method that can be used in detail.
Optimus puts a heavy focus on data sources that have been optimized for big data processing, such as Avro, Parquet, and ORC, and databases such as BigQuery and Redshift, so that users have all the tools they need at hand to cover their data processing needs.
From a developer's standpoint, Optimus follows the "batteries included" paradigm, so you don't have to worry about installing extra libraries to handle the Excel or Avro files that we use to handle this format. However, in the case of databases, every engine has their own respective driver, so including all the drivers inside a package would be problematic: it would be a package that's almost 500 MB...
