Submit your inspiring success story or innovative use case to the 2022 Dataiku Frontrunner Awards! ENTER YOUR SUBMISSION

SQL Notebooks accessible via API?

Solved!
Marlan
Neuron
Neuron
SQL Notebooks accessible via API?

Hello,

I see that there is some support for interacting with Jupyter Notebooks via API in version 10 of DSS. However, I didn't see any functionality that supports SQL Notebooks. Am I missing it? 

Thanks,

Marlan


Operating system used: Linux

0 Kudos
1 Solution
fchataigner2
Dataiker
Dataiker

Hi

you're right, there is no such API (yet?). If SQL execution is what you're after, you can check https://doc.dataiku.com/dss/latest/python-api/client.html#dataikuapi.DSSClient.sql_query

View solution in original post

0 Kudos
2 Replies
fchataigner2
Dataiker
Dataiker

Hi

you're right, there is no such API (yet?). If SQL execution is what you're after, you can check https://doc.dataiku.com/dss/latest/python-api/client.html#dataikuapi.DSSClient.sql_query

0 Kudos
Marlan
Neuron
Neuron
Author

Thanks @fchataigner2.

I've been using SQL Notebooks more recently for a variety of purposes including checking queries, R & D queries, and output queries. I like that queries can be grouped into a package (notebook) and then given names/labels. I've also been using markdown cells for documenting findings. 

(What I had been doing previously is keeping the queries in separate files outside of DSS that I run in a SQL query tool. But it's harder to navigate and find what I'm looking for with that approach. )

However, now we are moving from Netezza to Snowflake and so I need to change the connections for all of these SQL Notebooks. I know this can't be done through the UI (asked that previously) but was hoping it could be done through the API. It's not going to be any fun doing it manually. Maybe I can export the project and make changes in the exported files and re-import.

Thanks,

Marlan

 

0 Kudos

Labels

?
Labels (1)

Setup info

?
A banner prompting to get Dataiku