cancel
Showing results for 
Search instead for 
Did you mean: 
suxinji
Employee
Employee

 

Introduction

Incorta Materialized Views are created based on the parquet data from Incorta data storage. We can access the data loaded into Incorta using Spark SQL.

Incorta Notebook provides an interactive environment and can be used to perform ad hoc analysis.

What you need to know before reading this article

Incorta Spark Architecture

Concepts - Materialized View

Getting Started with Incorta Notebook

Steps

Navigation 

Go to MV -> Make sure Spark SQL is selected -> Click on Notebook

suxinji_1-1659564399051.gif

Incorta Notebook for SparkSQL

Incorta's notebook includes multiple paragraphs.  

When you are creating SparkSQL-based MV from Incorta Notebook, we assume that one of the paragraphs will be used. 

suxinji_0-1659564366856.png

There are several features in the Incorta Notebook including shortcuts, markdown cells for documentation, and much more.

Autocomplete for SparkSQL

When you type the schema name partially in the FROM clause, Incorta prompts the schema names for you to select.

suxinji_2-1659564782131.gif

Use the DESC command to get the list of columns

DESC describes the table statement in Incorta Spark SQL. The metadata information includes column name, column type, and column comment. 

Syntax: 

 

DESC Schema_Name.Table_Name 

 

Here is an example: 

suxinji_0-1651700616193.png

Use Incorta Notebook Visualization

You can visualize your data using built-in data visualization within Incorta Notebook by changing the icon to change the different charts. 

suxinji_0-1659566393855.png

 

Best Practices Index
Best Practices

Just here to browse knowledge? This might help!

Version history
Last update:
‎08-05-2022 02:58 PM
Updated by: