Get hands-on experience with 20+ free Google Cloud products and $300 in free credit for new customers.

Dataform Javascript Operate Tags

I publish a few tables that require "execute immediate" so they're publish via "operations". I do this using the javascript api like so:

```

paramTypes.forEach(paramType => {
operate(paramType, {
hasOutput: true,
tags: ["pivot"],
}).queries(ctx =>
scriptbuilder.event_params_full_refresh.call(ctx,
paramType,
constants.EVENT_PARAMS_COLNAMES.get(paramType)))
});
```
I tried adding the config `{hasOutput: true ,tags: ["pivot"]}` but it seems to be ignored. How can I use the Javascript API "operate" method with tags?
 
0 1 331
1 REPLY 1

Hi @m-hoss,

While Google documentation does not explicitly mention Operate() with tags, you can try this code and check the following workarounds:

  • It seems that you would need another option for tags since Array [ ] need a comparison like tags: [“pivot”, “pivot1”] 
  • Add execution tags to your sqlx files
  • Trigger execution of SQL workflow

If the workarounds above don’t work, I suggest to file this as a feature request. Please note that I can't provide any details or timelines at this moment. However, you may keep an eye on the Dataform release notes for any latest updates or new features related to Dataform.

I hope the above information is helpful.