Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Apache Superset Quick Start Guide

You're reading from   Apache Superset Quick Start Guide Develop interactive visualizations by creating user-friendly dashboards

Arrow left icon
Product type Paperback
Published in Dec 2018
Publisher
ISBN-13 9781788992244
Length 188 pages
Edition 1st Edition
Languages
Arrow right icon
Author (1):
Arrow left icon
Shashank Shekhar Shashank Shekhar
Author Profile Icon Shashank Shekhar
Shashank Shekhar
Arrow right icon
View More author details
Toc

Table of Contents (10) Chapters Close

Preface 1. Getting Started with Data Exploration 2. Configuring Superset and Using SQL Lab FREE CHAPTER 3. User Authentication and Permissions 4. Visualizing Data in a Column 5. Comparing Feature Values 6. Drawing Connections between Entity Columns 7. Mapping Data That Has Location Information 8. Building Dashboards 9. Other Books You May Enjoy

SQL Lab

SQL Lab is a powerful SQL IDE inside Superset. It works with any database that has a SQLAlchemy Python connector. It is great for data exploration. It can query any data sources in the Superset, including the metadata database.

It is a solid playground from which we can slice and dice the dataset in many ways to arrive at a form that needs to be visualized to solve the analytical question that the chart was created to answer.

First, we need to enable SQL Lab use on the superset-bigquery data source. We will explore and visualize the data in the table using SQL queries.

After clicking on the Sources | Databases option on the navigation bar, select the Edit record option for the superset-bigquery data source:

The overview chart of the list of databases

Then, make sure the following three options are enabled. Allow Run Sync should be enabled by default. We are doing this...

You have been reading a chapter from
Apache Superset Quick Start Guide
Published in: Dec 2018
Publisher:
ISBN-13: 9781788992244
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at ₹800/month. Cancel anytime