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!
Hi,
I want to update a sql server table (dataset) . I understand that there are scenarios option that triggers update sql querry . As this feature is not included in my licence, what are the other options I may use?
Thanks
Operating system used: win
Hi @Lo96 ,
The SQL triggers are indeed licenses-based and typically require Bussiness or Enterprise.
https://doc.dataiku.com/dss/latest/scenarios/triggers.html#sql-triggers
However, SQL triggers are not for updating SQL datasets; instead, they trigger a build/scenario when an SQL query changes.
If you want to update a SQL server table, you can just build a dataset /run a recipe that does the update.
You can trigger time-based scenarios with a Discover license as well.