I think this is probably a bug. At the very least, if it's a limitation and there's a workaround, it should be in the docs. File an issue here: https://github.com/pulumi/pulumi-snowflake
No matter how you like to participate in developer communities, Pulumi wants to meet you there. If you want to meet other Pulumi users to share use-cases and best practices, contribute code or documentation, see us at an event, or just tell a story about something cool you did with Pulumi, you are part of our community.