Snowflake Case Study

Roles & Responsibilities

  • Snowflake Deployments in different environments like TEST, UAT & PROD.
  • Creating tasks, functions, scheduling the tasks and cloning of the objects
  • Granting access with appropriate roles to the objects .Enabling Auto-suspend and Auto-resume.
  • Granting access with appropriate roles to the objects .Enabling Auto-suspend and Auto-resume.
  • Monitoring of the failed tasks or errors in objects and update the respective to resolve the issue.

Key Solutions

  • Increase the size of the cluster to improve the performance
  • Enabling the warehouse feature auto-suspend and auto-resume for effective cost.
  • Creating the Snowflake accounts for the individuals and creating a Snowflake service accounts for the team to connect with other tools used by the business for integration and migration purpose
  • The organization maintains different types of databases
  • Removing the unused objects

Business Benefits

  • Snowflake share - Instant, live data sharing of the data from organization to business or consumer to look into data they required.
  • Enabling the warehouse feature auto-suspend and auto-resume for effective cost.
  • By maintain the Snowflake in the effective way to control the cost features and best-in-class performance even in fluctuating workload loads
  • Better Concurrency and accessibility for real-time data applications with a multi-cluster architecture
  • Snowflake's SQL and API support for Python, Java, and other languages for the better business access to the tool.

Client

Genesys

Partners

Snowflake

Tension

Snowflake is a Single place for data. The project is to maintaining or creating the Snowflake accounts, creating the objects, Data migration, creating Snowflake service accounts and the organization uses tools like AWS, Boomi, Tableau, Talend etc. for Snowflake integration