Tutorial | In-database charts (SQL part 5)

When we create charts on database datasets, the summary statistics used to build the charts can be computed in-database.

Objectives

In this tutorial, you will:

  • build a chart with the in-database engine.

Starting here?

This tutorial requires having the output dataset from part 4 in order to reproduce the steps here.

Create a chart

  • In the customers_enriched dataset, click the Charts tab.

  • Drag pages_visited_avg to the X axis and Count of records to the Y axis in the default bar chart.

Build a chart with the in-database engine

At the moment, the chart is based on a sample of the data.

  • Navigate to the Sampling & Engine tab of the left pane.

  • Select In-database as the execution engine and click Save.


Note

In this case, the shape of the bar chart is essentially unchanged, but when the sample is not representative of the full data, using the full dataset can be illuminating, and using the in-database engine can speed your results.

What’s next?

Being able to natively build charts using the in-database engine makes data visualization much more efficient. SQL users will also want the ability to run their own queries in a SQL notebook.

See the tutorial on SQL notebooks to learn how!

Note

Learn more in the reference documentation about sampling and engines for charts.