Snowflake

Integrating your Snowflake account with Resmo allows you to gain valuable insights into your organization's cloud-based data warehouse configurations and usage. Snowflake is a powerful cloud data platform that enables organizations to store, process, and analyze vast amounts of structured and semi-structured data. By collecting and analyzing Snowflake configuration data, Resmo can help identify potential performance bottlenecks, ensure adherence to best practices, and optimize configurations for efficiency and effectiveness.

Using Resmo's SQL query capabilities, users can ask complex questions about their Snowflake configuration data, such as:

  • What are the details of users, including their default roles, warehouses, namespaces, and authentication settings?

  • What are the configurations of warehouses, including their auto-resume and auto-suspend settings, cluster count, scaling policies, and resource monitors?

  • What are the details of schemas, databases, and tables, including their retention times, ownership, options, and search optimization settings?

Setting up change alerts in Resmo for your Snowflake account can also be beneficial for monitoring critical configuration changes, such as:

  • Notifications when users are created, modified, or deleted, and when their default settings or authentication configurations change.

  • Alerts when warehouses are created, modified, or deleted, and when their scaling policies, cluster counts, or resource monitors change.

  • Updates when schemas, databases, or tables are created, modified, or deleted, and when their ownership, options, or retention times change.

In conclusion, integrating your Snowflake account with Resmo provides valuable insights into your organization's cloud data warehouse configurations and usage. By leveraging Resmo's SQL query capabilities and change alerting, you can stay on top of important changes and ensure that your Snowflake configurations are optimized for maximum efficiency and effectiveness.

Resources

Key

Supports Events

Database

Schema

Table

User

Warehouse

Last updated