Overview

Icicle simplifies the Snowflake account configuration around the world, specifies the application boundaries and privileges, and formulates the reports in regard to the cost implementations along with the defined privileges cost reports accompanied by breath-taking UIs. It also works to simplify the Snowflake setup and configuration easily. It uses virtual namespaces to define application boundaries, and integrate Snowflake with your solution ecosystem seamlessly and swiftly.

Technical Stack

  • ReactJs
  • TypeScript
  • Node.js
  • GraphQL
  • DynamoDB
  • Industry

    Information Technology

  • region
  • Region

    USA

  • project-size
  • Project Size

    Non- Disclosable

Highlights

Multiple Snowflake Account Management

Tenant-Specific Subdomain Design

Warehouse Cost Saving Policies

RBAC Implementation as per User Privileges

Challenges & Solutions

The client wanted an effective frontend to access resources as per tree level where account groups have multiple accounts and each account has multiple namespaces with global settings applicable everywhere.

  • Solution: We designed the react layout structure based on the navigation types, and topbar that indicates which context is currently accessed, along with the sidebar that contains sections which are accessible for it.

Implementing warehouse cost-saving policy was an issue as it required creating multiple schedules as per the related warehouse settings and size that include complex validations

  • Solution: To resolve this we implemented overlapping and dynamic query generation logic via cron-parser and another util library, then, we added karate test cases for it.

The client was facing some issues with access management and OAuth integration. So, each tenant can do okta integration for SSO and invite new users to cognito

  • Solution: We used Cognito IDP API to access management and Okta integration with dynamic attribute mapping for which users can provide the information.

2500+ Projects Experienced Innovation with Bacancy!

Get access to an experienced team of developers and engineers from bacancy,
handpicked to ace your goals. Kickstart within 48 hours, no-risk trial.

Talk to our Expert
12+

Years of Business
Experience

1458+

Happy
Customers

12+

Countries with
Happy Customers

1050+

Agile enabled
employees

Core Features

  • Manage the user's data based on the tenant.
  • Multiple Snowflake account management in a single place
  • Billing reports by account group and namespace
  • Access management and OAuth Integration for each tenant
  • Tenant specific okta integrations and access management for users
  • no.-of-resources
  • No. of Developer

    01

  • time-frame
  • Time Frame

    June 2022 - Ongoing

Experience With Bacancy

How Can We Help?