terraform-provider-snowflake
terraform-provider-snowflake copied to clipboard
Snowflake-Labs
[Feature]: Support for dashboards
Company Name
Storio
Use Cases or Problem Statement
We would like to start using the Dashboards functionality in Snowflake for showing operational aspects that are going on within our accounts.
Currently, this is only possible to be done manually by users through the Snowsight UI. It would be nice if we could manage these dashboards, panels and underlying queries as code through Terraform. This would also allow us to test queries on one account and automatically have them be applied on our other accounts without needing any manual intervention.
Category
category:resource
Object type(s)
No response
Proposal
No response
How much impact is this issue causing?
Low
Additional Information
No response
Would you like to implement a fix?
- [ ] Yeah, I'll take it 😎
Hey @dverheijden. Thanks for reaching out to us.
Currently, the provider is limited only to objects that can be managed through SQL statements in Snowsight. If there is no underlying SQL to run, we can't currently implement it on the provider's side.
Please reach out to your Snowflake account manager to request such a feature in Snowflake first.
Any updates on this? We have some teams that heavily leverage Snowflake-native dashboards for production day-to-day use and we would like to version control these via Terraform.
Unfortunately, I don't think it's possible to manage dashboards through SQL still, which limits our capabilities to support it. As Artur mentioned, we are operating only on the public Snowflake SQL API (available in Snowflake documentation), and the Snowflake feature request is a first step for us to support it (it has to be added to Snowflake SQL first).
The SnowflakeCli also doesn't provide a way to manage dashboards programatically. That's kind of surprising. I wonder if there is anything on the roadmap.
That's because SnowflakeCLI operates the same way we do; both tools are just abstractions over SQL. No dashboard support through SQL limits the TF provider and Snowflake CLI capabilities. It has to be added to Snowflake first. As I mentioned above, you have to first file a feature request directly to Snowflake so that it's supported through SQL API.