> ## Documentation Index
> Fetch the complete documentation index at: https://docs.cube.dev/llms.txt
> Use this file to discover all available pages before exploring further.
# Jupyter
> Jupyter Notebook is a web application for creating and sharing computational documents.
Here's a short video guide on how to connect Jupyter to Cube.
## Connect from Cube Cloud
Navigate to the [Integrations](/admin/connect-to-data/visualization-tools)
page, click **Connect to Cube**, and choose **Jupyter** to get
detailed instructions.
## Connect from Cube Core
You can connect a Cube deployment to Jupyter using the [SQL API][ref-sql-api].
In Cube Core, the SQL API is disabled by default. Enable it and [configure
the credentials](/reference/core-data-apis/sql-api#configuration) to
connect to Jupyter.
## Connecting from Jupyter
Jupyter connects to Cube as to a Postgres database.
### Creating a connection
Make sure to install the `sqlalchemy` and `pandas` modules.
```bash theme={"dark"}
pip install sqlalchemy
pip install pandas
```
Then you can use `sqlalchemy.create_engine` to connect to Cube's SQL API.
```python theme={"dark"}
import sqlalchemy
import pandas
engine = sqlalchemy.create_engine(
sqlalchemy.engine.url.URL(
drivername="postgresql",
username="cube",
password="9943f670fd019692f58d66b64e375213",
host="thirsty-raccoon.sql.aws-eu-central-1.cubecloudapp.dev",
port="5432",
database="db@thirsty-raccoon",
),
echo_pool=True,
)
print("connecting with engine " + str(engine))
connection = engine.connect()
# ...
```
### Querying data
Your cubes will be exposed as tables, where both your measures and dimensions
are columns.
You can write SQL in Jupyter that will be executed in Cube. Learn more about
Cube SQL syntax on the [reference page][ref-sql-api].
```python theme={"dark"}
# ...
query = "SELECT SUM(count), status FROM orders GROUP BY status;"
df = pandas.read_sql_query(query, connection)
```
In your Jupyter notebook it'll look like this.
You can also create a visualization of the executed SQL query.
[ref-sql-api]: /reference/core-data-apis/sql-api
This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.