Dss connection has no attribute cursor.

obireddy Registered Posts: 13 ✭✭

Hi Team,

I am able to fetch Presto connection details in Jupyter notebook.

But when I try to invoke API connection using same Presto details, getting error as Dss connection has no attribute cursor.

my code as below:

import dataiku



import sqlite/

conn=(provided all details from connection_handle)

conn.cursor() #here I am getting error like Attribute error ::Dss connection has no attribute cursor.

So how can we make cursor() available for Dataiku to interact with other connections?

or can we make any changes to existing Presto connection which also enable cursor() functionality?

Please suggest.


  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,209 Dataiker

    HI @Obireddy

    Can you try to print connection_handle?
    It should return -> <dataikuapi.dss.admin.DSSConnection object at 0x7f6326340040>

    You seem to be using a cursor attribute later, which does not exist for this object.

    In this instance, you would need to retrieve the params you need dssclient.get_connection().get_info() check the connection attributes and pass these individually to your sqlite. Given the user has sufficient permission to read the connection information.

    However, DSS provides SQLExecutor2 which should work in this case where you can just pass the connection name.


    I would suggest you use SQLExecutor2 instead of sqllite .


Setup Info
      Help me…