Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
You can create a "SQL query" recipe with the public API using the `SQLQueryRecipeCreator` object. However, there isn't an equivalent object for a "SQL script" recipe. How can I create a SQL script recipe using the public API?
There is no specific API to create an SQL Script recipe, but you can use the generic SingleOutputRecipeCreator to do it.
Here is an example to create such a recipe:
from dataikuapi.dss.recipe import SingleOutputRecipeCreator
# Create an SQL script recipe
builder = SingleOutputRecipeCreator('sql_script', "my_sql_script_recipe_name", project)
builder = builder.with_input("my_input_ds")
builder = builder.with_output("my_output_ds")
recipe = builder.build()
# Update the SQL script recipe to set its script
recipe_def = recipe.get_definition_and_payload()
recipe_def.set_payload('CREATE TABLE ...')
recipe.set_definition_and_payload(recipe_def)
There is no specific API to create an SQL Script recipe, but you can use the generic SingleOutputRecipeCreator to do it.
Here is an example to create such a recipe:
from dataikuapi.dss.recipe import SingleOutputRecipeCreator
# Create an SQL script recipe
builder = SingleOutputRecipeCreator('sql_script', "my_sql_script_recipe_name", project)
builder = builder.with_input("my_input_ds")
builder = builder.with_output("my_output_ds")
recipe = builder.build()
# Update the SQL script recipe to set its script
recipe_def = recipe.get_definition_and_payload()
recipe_def.set_payload('CREATE TABLE ...')
recipe.set_definition_and_payload(recipe_def)