https://community.databricks.com/t5/data-engineering/can-i-have-multiple-queries-in-a-pipeline-writing-to-the-same/m-p/18598#M12371 Fri, 25 Jun 2021 22:06:13 GMT Ryan_Chynoweth 2021-06-25T22:06:13Z https://community.databricks.com/t5/data-engineering/can-i-have-multiple-queries-in-a-pipeline-writing-to-the-same/m-p/18598#M12371 Fri, 25 Jun 2021 22:06:13 GMT https://community.databricks.com/t5/data-engineering/can-i-have-multiple-queries-in-a-pipeline-writing-to-the-same/m-p/18598#M12371 Ryan_Chynoweth 2021-06-25T22:06:13Z https://community.databricks.com/t5/data-engineering/can-i-have-multiple-queries-in-a-pipeline-writing-to-the-same/m-p/18599#M12372 <P>No, each table must be defined once. You can Use&nbsp;<A href="https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-qry-select-setops.html#union" alt="https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-qry-select-setops.html#union" target="_blank">UNION</A>&nbsp;If you need to combine multiple inputs to create a table. Adding or removing UNION from an incremental table is a breaking operation that requires a full-refresh.</P> Fri, 25 Jun 2021 22:06:35 GMT https://community.databricks.com/t5/data-engineering/can-i-have-multiple-queries-in-a-pipeline-writing-to-the-same/m-p/18599#M12372 Ryan_Chynoweth 2021-06-25T22:06:35Z