U-SQL Custom reducer could not find file
<p>I'm writing a custom reducer in U-SQL that requires a lookup file as an argument into the constructor of the reducer. The problem is when I do the local run, it can not locate the lookup file that's included in the project under /data/ directory. Here is the code snippet:</p>

<pre><code>DECLARE @EventType string = @"/data/EventType.csv"; 
...
@red =
REDUCE @filtered
ON id
PRODUCE 
...
USING new USQLApplication1.MyReducer(@EventType);
</code></pre>

<p>And here is the error message I'm getting. Whatever the solution, I'd like it to work not just in the local run, but also in the azure cloud. Thanks.</p>

<blockquote>
  <p>Running step 1 of 1</p>
  
  <p>Unhandled Exception: System.Exception: {"diagnosticCode":195887132,"severity":"E
  rror","component":"RUNTIME","source":"User","errorId":"E_RUNTIME_USER_UNHANDLED_
  EXCEPTION_FROM_USER_CODE","message":"An unhandled exception from user code has b
  een reported when invoking the method 'Constructor' on the user type 'USQLApplic
  ation1.MyReducer'","description":"Unhandled exception from user code: \"Could not find file 'D:\Users\jbfp\Documents\Visual Studio 2015\Projects\USQL
  Application1\USQLApplication1\bin\Debug\ECB1C361139EE2D8\Script2_2E96CB20AE
  368E7B\EventType.csv'.\"</p>
</blockquote>