Thanks, Really appreciate the reply. 

I have read that in the documentation which I assumed meant that for every micro batch processed in the stream, the static table would be updated and the new latest version would be used.

I have just tested this in a notebook, created a table, started my stream, updated my static table, processed a new microbatch and it was still using the snapshot of the table when i initialised the job not the new version after the new microbatch.

Now im even more confused