[BUG] - SqlDatabaseResource entity has NULL value for FederatedClientId in case of CMK scenario

[icipriand]

Library name and version

Azure.ResourceManager.Sql 1.2.1

Describe the bug

Not sure if wrong expectation from our side or just a bug. But we are trying to evaluate if a database has CMK enabled or not.
According to the field description, we thought the below will be the best field to asses this.
///

The Client id used for cross tenant per database CMK scenario.

[WirePath("properties.federatedClientId")]
public Guid? FederatedClientId { get; set; }

If that is not the case, will be nice if you can let us know what is the best way to fetch this data (identify a DB is CMK or MMK)?

.GetSqlDatabases()/GetSqlDatabase() functions return SqlDatabaseResource entity with NULL value for FederatedClientId even if CMK is enabled on the database.

Missing property value for: FederatedClientId

Expected behavior

Functions return correct/expected values for property for this field when CMK is enabled on the database

Actual behavior

Null values FederatedClientId.

Reproduction Steps

Just run below on a database that has CMK enabled.
var database= server.GetSqlDatabase(databaseName);

Environment

Prod and non-prod

Library name and version
Azure.ResourceManager.Sql 1.2.1

[jsquire]

Thank you for your feedback. Tagging and routing to the team member best able to assist.

[mcgallan]

@icipriand Thank you for your inquiry. Regarding the issue you mentioned, I recommend using the SqlServerKeyType field in the EncryptionProtectorData to verify whether your database is using a Customer-Managed Key. If the value is ServiceManaged, it indicates that the database is using a Microsoft Managed Key; if it is AzureKeyVault, it signifies the use of a CMK.

I hope this information is helpful. Should you have any further questions or require additional assistance, please don't hesitate to let me know.

[github-actions]

Hi @icipriand. Thank you for opening this issue and giving us the opportunity to assist. To help our team better understand your issue and the details of your scenario please provide a response to the question asked above or the information requested above. This will help us more accurately address your issue.