Help Shape the Future of Dataiku Join our User Research Program

Connect SQL VIEWS to a Dataiku

anamtnez
Level 1
Connect SQL VIEWS to a Dataiku

Hello everyone! 

I was wondering if its possible to connect Dataiku to a Oracle database and import SQL views (virtual tables) from this database to Dataiku as an imput dataset , instead of physical database tables. 

Thank you so much!!

0 Kudos
1 Reply
tgb417
Neuron
Neuron

@anamtnez ,

Welcome to the Dataiku community.

First, I'm not an expert on Oracle and the DSS connection to Oracle. (Others who are, please jump in here.) 

That said in all of the SQL databases I've used a view can be used very much like any table.

SELECT * FROM TABLE_NAME;

Where TABLE_NAME is the name of a table in your database.

This works much the same way as selecting from a view  

SELECT * FROM VIEW_NAME;

Where VIEW_NAME is a view defined in the database.

Here is the documentation for the Oracle Dataiku DSS Connector.  I see nothing there that says that this connector can not see a view.

If I was debugging this situation.  I'd connect to the database directly with the credentials that DSS is being used by DSS and confirm that that account has rights to the view in question.  This security issue has more often caused me problems with views.  Then I'd set up the connection.  If I can not see the view from any of the DSS dropdowns.  I'd then create a simple SQL query from within DSS to see if I can access the view.

Just my $0.02.  Hope it helps.  Let us know how you are getting on with this.

--Tom
0 Kudos
A banner prompting to get Dataiku DSS