Error on import for a SQL Query in a python recipe

Options
hrobellaz
hrobellaz Registered Posts: 1 ✭✭✭✭

Hello,

I'm trying to make some SQL query directly from a python recipe to make some work in python on the results.

I followed the advice from this page : http://doc.dataiku.com/dss/latest/api/python/sql.html

But I get the following error, as soon as I try to import SQLExecutor, any idea what's the problem ?


[2015/12/02-18:27:32.411] [Exec-30] [INFO] [dku.utils] - from dataiku.core.sql import SQLExecutor2
[2015/12/02-18:27:32.411] [Exec-30] [INFO] [dku.utils] - ImportError: cannot import name SQLExecutor2
Tagged:

Answers

  • Mattsco
    Mattsco Administrator, Dataiker Posts: 125 Administrator
    Options

    Hi hrobellaz,

    You'd better try this:


    from dataiku.core import sql<BR /><BR />sqe = sql.SQLExecutor("yourConnectionName")<BR />df = sqe.exec_query("SELECT * FROM TABLE")

    Matt

Setup Info
    Tags
      Help me…