All posts

Vizzly Integrates with Snowflake for Analytics

May 1, 2023

You May Be Here Because:

  • You’re exploring powerful data solutions to build scalable and performant customer-facing analytics.
  • You’re excited about the new capabilities offered by the integration between Vizzly and Snowflake.
  • You need a robust backend to handle large data volumes and complex queries efficiently.
  • You want to learn how to leverage Vizzly and Snowflake to create high-performance data apps for your customers.

We are thrilled to announce our new integration with Snowflake! This powerful combination allows you to build highly functional customer-facing data applications with a scalable and efficient backend setup. With Snowflake's cloud-based data warehousing capabilities and Vizzly's intuitive analytics platform, you can deliver top-notch data experiences to your users seamlessly.

Why Should You Consider Snowflake?

Snowflake stands out as a leading cloud data platform, offering numerous advantages that enhance your data processing and analytics capabilities:

  1. Highly Performant:
    • Snowflake leverages the elasticity of the cloud to provide exceptional query performance. You can dynamically scale your virtual warehouse to accommodate larger data loads or increased query volumes and then scale it back down once the load decreases. This flexibility ensures that you only pay for the resources you use, optimizing both performance and cost.
    • Example: When running a large-scale data analysis during peak hours, you can scale up your compute resources to handle the load and ensure fast query processing, then scale down during off-peak hours to save costs.
  2. Concurrency:
    • Traditional data warehouses often struggle with concurrent data access, leading to delays or failures. Snowflake's unique multi-cluster architecture addresses this issue by allowing multiple users or tasks to operate simultaneously without interference. Each group of users can have its own virtual warehouse, scaling independently to meet their needs.
    • Example: A sales team can run complex reports while a marketing team performs data analysis without affecting each other’s performance, ensuring smooth operations for all departments.
  3. Support for Structured & Semi-Structured Data:
    • Snowflake supports the analysis of both structured (like tables) and semi-structured data (like JSON or XML) without requiring upfront data transformation. You can directly load diverse data types into Snowflake, and it optimizes storage and querying automatically, simplifying your data workflows.
    • Example: You can load customer transaction data (structured) and website clickstream data (semi-structured) into Snowflake and analyze them together to gain comprehensive insights into customer behavior.
  4. Availability & Security:
    • Snowflake is designed to ensure continuous data availability, even during component or network failures. It distributes your data across multiple availability zones within AWS or Azure, guaranteeing that your data remains accessible and reliable. Additionally, Snowflake is SOC 2 Type II certified and offers robust security features, including support for PHI data for HIPAA-compliant applications.
    • Example: In the event of a network outage in one availability zone, your data remains accessible from other zones, maintaining seamless operations and data access.
  5. Run Vizzly:
    • With Snowflake, you can now leverage Vizzly to build visually appealing and functional customer-facing analytics dashboards. The integration process is straightforward:
      • Sign Up: Create your account and get started with Vizzly.
      • Setup: Use the Vizzly CLI to define your datasets.
      • Deploy: Deploy Vizzly to your chosen cloud provider.
      • Code: Implement identity logic with support from our SDKs.
    • Example: You can go from signup to a fully operational dashboard within a day, enabling rapid deployment and immediate data insights for your users.
“Vizzly allowed us to embed a top quality customizable and whitelabled analytics dashboard right into our product. This saved us so much time and engineering resources and allowed us to get the solution provided by the analytics experts.” - Ali Avci, Co-Founder & CTO @ Ariglad

Results

The Ariglad team were able to get up and running with the first iteration of their dashboard in less than 2 days. Not only that, they now possess a dashboard embed solution capable of seamlessly adapting to the evolving requirements of their valued customers, ensuring scalability and long-term satisfaction. In summary:

  • Lightening quick integration
  • Huge annual cost saving when compared to building in-house
  • Maximises deal closure with new product capability

What’s Next for Vizzly?

At Vizzly, we are committed to continuous innovation and rapid delivery of new features. Here’s a glimpse of what’s coming soon:

  • Multi-Select Filters: Enhance your dashboard interactivity by allowing users to filter data across multiple dimensions simultaneously.
  • MongoDB Integration: Extend Vizzly's capabilities to support MongoDB, providing more options for data sources.
  • Exciting Announcements: Stay tuned for a major announcement that will further enhance our platform’s capabilities and your data experience.

If you’re ready to elevate your data analytics with Vizzly and Snowflake, Book your demo here. Our team will guide you through setting up your account, and within half a day, you'll have your first dashboard up and running.

Thank you for reading this.