Update Dataset SQL server

Lo96

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

Alexandru

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.