I had the same issue and apparently the problem was not with the table's catalog, but the function's. When you define it, don't forget to use the 3-level namespace (catalog.schema.function), otherwise it will not work with Unity Catalog. Link