Database schema name setting in dataset

Hi @Meirkhan
,

To update the schema of the dataset programmatically you can use Dataiku API. Please refer to the code snippet below (you can run it Python notebook):

import dataiku, json
from dataiku import pandasutils as pdu
import pandas as pd

client = dataiku.api_client()
proj_key = dataiku.default_project_key()
project = client.get_project(proj_key)
dataset = project.get_dataset('dataset_name')
dataset_settings = dataset.get_settings()
dataset_settings.settings["params"]["schema"] = 'new_schema'
dataset_settings.save()

Hope this helps.

Best,

Vitaliy