dataform-co / dataform-scd

Common data models for creating type-2 slowly changing dimensions tables from mutable data sources in Dataform.

https://dataform.co

MIT License

19 stars 13 forks source link

Want to Add a Surrogate Key for SCD #14

Closed hiracky16 closed 3 months ago

hiracky16 commented 3 months ago

Hello,

I would like to request the addition of a feature to the dataform-scd package that allows for the automatic generation and assignment of surrogate keys when performing Slowly Changing Dimensions (SCD) operations.

This feature would greatly enhance the usability and efficiency of the package, particularly in scenarios where surrogate keys are necessary for uniquely identifying records.

Thank you for considering this request. I look forward to any updates on this feature.

hiracky16 commented 3 months ago

I have found that using the hash option achieves my request. I will close the issue. Thank you!