Book Image

Essential PySpark for Scalable Data Analytics

By : Sreeram Nudurupati
Book Image

Essential PySpark for Scalable Data Analytics

By: Sreeram Nudurupati

Overview of this book

Apache Spark is a unified data analytics engine designed to process huge volumes of data quickly and efficiently. PySpark is Apache Spark's Python language API, which offers Python developers an easy-to-use scalable data analytics framework. Essential PySpark for Scalable Data Analytics starts by exploring the distributed computing paradigm and provides a high-level overview of Apache Spark. You'll begin your analytics journey with the data engineering process, learning how to perform data ingestion, cleansing, and integration at scale. This book helps you build real-time analytics pipelines that help you gain insights faster. You'll then discover methods for building cloud-based data lakes, and explore Delta Lake, which brings reliability to data lakes. The book also covers Data Lakehouse, an emerging paradigm, which combines the structure and performance of a data warehouse with the scalability of cloud-based data lakes. Later, you'll perform scalable data science and machine learning tasks using PySpark, such as data preparation, feature engineering, and model training and productionization. Finally, you'll learn ways to scale out standard Python ML libraries along with a new pandas API on top of PySpark called Koalas. By the end of this PySpark book, you'll be able to harness the power of PySpark to solve business problems.
Table of Contents (19 chapters)
1
Section 1: Data Engineering
6
Section 2: Data Science
13
Section 3: Data Analysis

Spark connectivity to SQL analysis tools

SQL analysis tools, as the same suggests, are tools with interfaces suited for quick and easy SQL analysis. They let you connect to an RDBMS, sometimes even multiple RDBMSes, at the same time, and browse through various databases, schemas, tables, and columns. They even help you visually analyze tables and their structure. They also have interfaces designed to perform SQL analysis quickly with multiple windows that let you browse tables and columns on one side, compose a SQL query in another window, and look at the results in another window. Once such SQL analysis tool, called SQL Workbench/J, is shown in the following screenshot:

Figure 13.2 – SQL Workbench/J interface

The previous screenshot depicts the interface of SQL Workbench/J, which represents a typical SQL editor interface with a database, schema, table, and column browser on the left-hand side pane. The top pane has a text interface for composing actual...