Skip to main content

Visualization Databend data in Jupyter Notebook

What is Jupyter Notebook?​

The Jupyter Notebook is the original web application for creating and sharing computational documents. It offers a simple, streamlined, document-centric experience.

Jupyter​

Create a Databend User​

Connect to Databend server with MySQL client:

mysql -h127.0.0.1 -uroot -P3307

Create a user:

mysql>
create user user1 identified by 'abc123';

Grant privileges for the user:

mysql>
grant all on *.* to user1;

See also How To Create User.

Install Jupyter Python Package​

Jupyter:

pip install jupyterlab
pip install notebook

Dependencies:

pip install sqlalchemy
pip install pandas

Run Jupyter Notebook​

Download databend.ipynb, start the notebook:

jupyter notebook

Run databend.ipynb step by step, the demo show: