This message was deleted.
# discussion
w
This message was deleted.
p
Hey @incalculable-belgium-80493, I'm not familiar with Beekeeper Studio, but looks like an interesting tool! I'm not sure about your exact application, but the lack of a primary key can be pretty common with derived business models (e.g. a date aggregate model like MRR, or daily active users, won't have a primary key) and many cloud data warehouses don't enforce the need for a primary key (BigQuery, Redshift, Snowflake for example). I would say it's a good practice to add a surrogate key to tables that lack a native primary key. This may help you get around this issue in Beekeeper. If you're using dbt to build models, dbt_utils has a nice macro called generate_surrogate_key that helps you easily create a surrogate key.