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!!
Answers
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,601 NeuronWelcome 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.