Coming soon: We’re working on a brand new, revamped Community experience. Want to receive updates? Sign up now!

0 votes

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
by

1 Answer

0 votes

Hi hrobellaz, 

You'd better try this: 

from dataiku.core import sql

sqe = sql.SQLExecutor("yourConnectionName")
df = sqe.exec_query("SELECT * FROM TABLE")

 

Matt

by
1,339 questions
1,365 answers
1,557 comments
11,916 users

©Dataiku 2012-2018 - Privacy Policy