Notebooks

​

Jupyter Notebook

​

Requirements

• The latest e6data Python package.
• Jupyter Notebook v7.0.7 (recommended).
• The connection details from the cluster’s Connection Information tab - host, port, username, password (a personal access token), cluster name, and the secure flag.

​

Connect

1. Create a new Python 3 notebook.
2. Install the connector:
   pip install e6data-python-connector
   
3. Open a connection:
   from e6data_python_connector import Connection
   
   username = '<username>'      # Your e6data email
   password = '<password>'      # Access token from the e6data Console
   host = '<host>'
   database = '<database>'
   port = <port>
   catalog_name = '<catalog_name>'
   cluster_name = '<cluster_name>'
   secure = True                # Use a secure channel (default False)
   
   conn = Connection(
       host=host, port=port, username=username, database=database,
       password=password, cluster_name=cluster_name, secure=secure,
   )
   
4. Run a query:
   query = """select * from <table>"""
   cursor = conn.cursor(catalog_name=catalog_name)
   query_id = cursor.execute(query)   # returns a query ID you can use to abort
   for row in cursor.fetchall():
       print(row)
   

​

Apache Zeppelin

​

Requirements

• Apache Zeppelin 0.8.2 or newer.
• The latest e6data JDBC driver.
• A Direct or TLS connection on your cluster.
• The connection details from the cluster’s Connection Information tab - JDBC URL, username, password (a personal access token), driver class, and AUTO_RESUME.

​

Connect

1. Go to the profile menu (top right) and select Interpreter.
2. Click Create to set up a new JDBC interpreter:
   • Interpreter Name - a name for the interpreter.
   • Interpreter group - select jdbc.
   • Set the connection properties (JDBC URL, username, password).
3. In the Dependencies → Artifact section, provide the file path of the e6data JDBC JAR.
4. Click Save.

​

TLS/HTTPS

​

See also

• Python connector
• JDBC
• Access tokens