Synopsis

Quick Base is an organization that provides a low code application development platform for functional and technical users to build business applications safely and securely. Over 180 companies globally use their development platform for their business application needs.

As a part of their platform, Quick Base offers detailed audit reporting to provide customers visibility into how they were leveraging the platform. Originally, Quick Base was using an AWS Athena-based solution, but due to increased customer workloads began to run into latency, performance, and downtime issues.

After a proof of concept with Snowflake, Quick Base quickly realized that replacing AWS Athena would resolve numerous business and technical problems and significantly reduce processing costs. To implement Snowflake for their audit service, Quick Base brought in Archetype Consulting to provide best practices and guidance on proper Snowflake setup, dev ops, and implementation architecture. Quick Base engineers and developers confidently implemented the solution with Archetype’s guidance.

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

Results

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