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:
CREATE USER user1 IDENTIFIED BY 'abc123';
Grant privileges for the user:
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: