Update Dataset SQL server

Lo96
Lo96 Registered Posts: 15

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

Answers

  • Alexandru
    Alexandru Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 1,215 Dataiker

    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.


Setup Info
    Tags
      Help me…