-
|
Suppose I write a JS file for some complex processing (which is, as far as I understand, the precise use case). Where can I find the results of a |
Beta Was this translation helpful? Give feedback.
Replies: 1 comment 5 replies
-
|
Console output is indeed not available. However, just to avoid confusion: Dataform JS code is not executed at workflow execution time - it is executed at compile time, i.e. turning the JS into pure SQL (which can then be executed at some later date). So it's not as though you could e.g. have a console.log outputting some text as a result of running some SQL. |
Beta Was this translation helpful? Give feedback.
-
|
Oh ok ... this limits the features that Javascript can provide to some query templating mechanism, if I understand correctly ... |
Beta Was this translation helpful? Give feedback.
-
|
That's more or less correct, yes. JavaScript can be used to dynamically generate the SQL (templating included) and also dynamically generate the workflow graph. If something dynamic needs to happen at workflow execution time, we would recommend use of BQ scripting. |
Beta Was this translation helpful? Give feedback.
-
|
I'll have another question about that ;-) |
Beta Was this translation helpful? Give feedback.
-
|
You talk about BQ scripting, but is it available in GCP Dataform? |
Beta Was this translation helpful? Give feedback.
-
|
All BQ SQL is available in Dataform. |
Beta Was this translation helpful? Give feedback.
Console output is indeed not available.
However, just to avoid confusion: Dataform JS code is not executed at workflow execution time - it is executed at compile time, i.e. turning the JS into pure SQL (which can then be executed at some later date). So it's not as though you could e.g. have a console.log outputting some text as a result of running some SQL.