Reader small image

You're reading from  Essential PySpark for Scalable Data Analytics

Product typeBook
Published inOct 2021
Reading LevelBeginner
PublisherPackt
ISBN-139781800568877
Edition1st Edition
Languages
Tools
Concepts
Right arrow
Author (1)
Sreeram Nudurupati
Sreeram Nudurupati
author image
Sreeram Nudurupati

Sreeram Nudurupati is a data analytics professional with years of experience in designing and optimizing data analytics pipelines at scale. He has a history of helping enterprises, as well as digital natives, build optimized analytics pipelines by using the knowledge of the organization, infrastructure environment, and current technologies.
Read more about Sreeram Nudurupati

Right arrow

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...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Essential PySpark for Scalable Data Analytics
Published in: Oct 2021Publisher: PacktISBN-13: 9781800568877

Author (1)

author image
Sreeram Nudurupati

Sreeram Nudurupati is a data analytics professional with years of experience in designing and optimizing data analytics pipelines at scale. He has a history of helping enterprises, as well as digital natives, build optimized analytics pipelines by using the knowledge of the organization, infrastructure environment, and current technologies.
Read more about Sreeram Nudurupati