Forum Discussion
Formula.Firewall - Query references other queries...
I see that this error crops up quite regularly on these fora but I haven't found a scenario that matches my experience. A former team member (who has left the organisation) created quite a comple...
Thank you for the suggestion. I have had a look at the scripts and I cannot see any external links. The R scripts appear to be within the query. I'm assuming, from what you suggest, that I should see a file path reference to an external script? This is not evident in the queries.
However, you have given me an idea! Maybe I should move the scripts out of the queries and onto a network share? Would that work?
However, you have given me an idea! Maybe I should move the scripts out of the queries and onto a network share? Would that work?
Have you tried to separate your R script from directly referencing your data source script by using a function? You can create a staging query for your data source and then create a function on it to output a new query, and then you use the new query to do all the R transformations. Here is a post about that: Formula.Firewall Error Referencing Queries – R & Python Scripts