Snowshoe logo
troubleshooting

Can we create a schema for a materialized view with a primary key and upsert functionality on collision?

I want to create a primary key in a materialized view with an upsert functionality on collision. What should I do if the materialized view is created from a source that is not a table?

ha

harshit dwivedi

Asked on Feb 12, 2024

  1. Materialized views inherit the primary key of the upstream table.

  2. Set the primary key of the upstream table to achieve the requirements.

  3. If the materialized view is created from a source that is not a table, specify the source as upsert during creation.

  4. Refer to the documentation for specific details: SQL Create Source Documentation

Feb 12, 2024Edited by