The Details

Problem

Quick Base reached out to Archetype with the following issues that hindered them in implementing their audit migration project, as well as expanding use cases for both internal and external analytics:

  • Recommendations on data integration options including comparing custom vs. off-the-shelf solutions
  • Best practices on managing multiple environments, code promotion processes, and security
  • Guidance on fully automating deployment artifacts through integration with existing CI/CD pipelines
  • Methods to programmatically connect to Snowflake and structure warehouses/data feeds to minimize latency and cost, while maximizing performance
  • Management of expanding Snowflake use cases across teams and functions, both internal and external

Solution

Archetype worked alongside Quick Base and used the following sessions as a framework for the team to discuss best practices and concrete implementation patterns & decision for an effective implementation of the audit service (and future Snowflake use cases).

  • Data flow, tools, and a deep dive into the existing sources
  • Recommendation of database schema design and future state data flow
  • Software development lifecycle & continuous integration / continuous delivery
  • Processes and best practices around development frameworks, security, warehouse setup, and data management procedures
  • Logical entities and registry management
  • Operating expense control through Snowflake resource monitors and quotas
  • Deployment, integration and rollback processes
  • Integration/ETL assessment and recommendations

Result

The solution provided by Archetype impacted Quick Base positively in achieving their desired objective.

  • Quick Base quickly ramped up on Snowflake best practices and were able to quickly and confidently deliver a well-architected solution for the audit service
  • The team was able to apply the learnings for additional use cases (both internal and external)
  • The development & deployment frameworks are nearly no-touch, resulting in high-quality production outputs