I think that you need to use one of the

ResourceType.Get()

method variations to look up your resource by name. Maybe this: https://www.pulumi.com/docs/reference/pkg/azure/sql/database/#look-up But it requires a known resource ID. The more generic Get works with a name IIRC.