title: Is it possible for Flink to run continuous query over non-dynamic tables?
body: <p>I'm hoping to use Flink SQL as a materialized view over multiple different services. For example, reading data from MySQL &amp; Redis &amp; RPC services, join them together, then updates result table stored in PostgreSQL</p>
  <p>All of these services above have notification writes to Kafka regarding what has changed.</p>
  <p>If the &quot;notification&quot; contains all the information in the source tables, then I can just use dynamic tables. However, data in source tables are too large that will be such a waste to store all of them in dynamic tables.</p>
  <p>So the best way to do this would be:</p>
  <ol>
  <li>Flink reads the notifications in the input kafka topic</li>
  <li>Instead of updating &amp; querying dynamic tables from memory, Flink queries external services for the data needed to re-compute the result of the SQL.</li>
  <li>Write the result to a sink (like PostgreSQL).</li>
  </ol>
  <p>Is it possible to do this with some tricks?</p>