How can I merge two sources into one table?

One method that makes this possible is to ingest both sources into the same table by stating the same destination for both sources. However, this not a recommended solution as you may end up with duplication.

Instead, create a view based on a join between the two tables. After the view is ready, we can materialize it for you to provide optimal performance.

Are we able to materialize our own views or must that be done by Support?

Currently the ability to materialize your own views is in closed beta stage. I suggest contacting support@panoply.io with this request and some explanations on what is the exact use case you are looking to utilize with this option and we’ll see how we can help.

1 Like