Wentzler, Charlotte - Thanks for the question and using MS Q&A platform.
Yes, you are correct that if you create a secret scope in Databricks and the keys are rotated after one month, they are not automatically updated in the secret scope. To work around this issue, you can use the Key Vault-backed secret scope feature in Databricks.
With Key Vault-backed secret scope, the secrets are fetched from the Key Vault at runtime, which means that the secrets are always up-to-date with the latest version in the Key Vault. This feature provides automatic rotation of secrets in the Key Vault and ensures that the secrets used by your Databricks workloads are always up-to-date.
For more details, refer to the below MS Q&A thread addressing similar issue:
https://learn.microsoft.com/en-us/answers/questions/1185280/databricks-secretscope-secret-versions
Hope this helps. Do let us know if you any further queries.