[Bug]: `snowflake_warehouses` data resource has issues when 'SYSTEM$STREAMLIT_NOTEBOOK_WH' is included and `with_describe = true` about terraform-provider-snowflake HOT 1 OPEN

Hi, @AaronCoquet-Easypark 👋 Thanks for reporting this issue. Currently, we call DESCRIBE without checking for appropriate privileges in all the datasources, and users are responsible for granting proper privileges.

For now, please continue with the granted MONITOR privilege, or with with_describe = false, or with the like filter.

According to docs, the PUBLIC role is granted USAGE privilege. I think that by default, it could also be granted MONITOR for PUBLIC/SYSADMIN. I'll ask the warehouse team.

In the future, we'll consider checking for appropriate grants in the provider, or not failing the whole operation where information from DESCRIBE is not crucial for handling data sources/resources correctly.

from terraform-provider-snowflake.