From dataiku API how to access to SQL Probe code

[oscieux]

Hi all,

My question is in the subject 🙂

Do anyone have a solution please?

[AlexT · Accepted solution]

Hi @oscieux ,

You can use the get_dataset() get_settings() get_raw() to retrieve SQL Probe code:

import dataiku
import pprint
pp = pprint.PrettyPrinter(indent=4)
client = dataiku.api_client()
project = client.get_default_project()

dataset = project.get_dataset("IMPORT_FROM_V5_sql_bad")
settings = dataset.get_settings()
params = settings.get_raw()['metrics']['probes']
for i in params:
    if i['type'] == 'sql_query':
        pp.pprint(i['configuration']['code'])

 Let me know if that's what you were looking for!

[oscieux]

U are the best 🙂
Thxs a lot !