Skill UI

A comprehensive checklist for deploying Shopify apps to production or submitting to the App Store. It covers critical areas including API versioning, mandatory GDPR compliance webhooks, webhook security best practices, rate limit resilience, and App Store listing requirements. Use this guide when preparing for a major launch or auditing existing compliance gaps to ensure maximum stability and security.

Master the art of building fault-tolerant e-commerce applications for Shopify. This guide covers essential reliability patterns, including implementing circuit breakers for API outages, ensuring webhook idempotency to handle retries, and utilizing queue systems and cached fallbacks for graceful degradation. Essential for building highly resilient integrations that withstand API failures and webhook storms.

A comprehensive guide to production-ready patterns for the Shopify API SDK. Covers advanced topics like typed GraphQL clients, multi-tenant architecture, cursor-based pagination, bulk operations, and robust error handling. Use this when developing scalable and maintainable e-commerce integrations for Shopify.

This skill provides comprehensive guidance on implementing security best practices for Shopify applications. It covers critical topics such as secure API credential storage, verifying incoming webhooks using HMAC signatures, enforcing least-privilege access scopes, and setting Content Security Policies (CSP). Use this guide when building, auditing, or scaling a secure e-commerce integration.

Master the deployment of applications connected to Snowflake across various cloud environments, including serverless functions (AWS Lambda, Cloud Run) and containers. This guide covers best practices for secure connection management, connection pooling, handling secrets (like private keys), and ensuring application reliability in production settings.

This guide provides comprehensive steps to install and configure Snowflake SDKs for Node.js and Python. It covers various authentication methods, including password, secure Key Pair authentication (ideal for CI/CD), and enterprise-grade SSO/OAuth integration. Use this when setting up data pipelines or applications that require reliable and secure connectivity to the Snowflake data warehouse.

This comprehensive guide details how to set up robust, isolated, and secure development, staging, and production environments within Snowflake. It utilizes best practices like zero-copy cloning for efficient data replication, implements granular Role-Based Access Control (RBAC), and defines environment-specific compute resources (warehouses) and data masking policies. This ensures data integrity, compliance, and cost optimization across all stages of the data lifecycle.

This skill provides comprehensive guidance on implementing robust data governance and security guardrails within Snowflake. It covers advanced features such as network rules, mandatory authentication policies (MFA, Key Pair), session timeouts, and statement-level controls. Use this when enforcing strict security policies, achieving regulatory compliance, or structuring robust data access controls for a Snowflake environment.

This guide outlines the implementation of a production-ready Snowflake data platform using the industry-standard Medallion Pattern (Bronze, Silver, Gold). It provides comprehensive, step-by-step SQL examples covering raw data ingestion (Bronze), data cleansing and typing (Silver), and business-level aggregation (Gold). Use this when designing new data warehouses or establishing robust, layered data architecture standards on Snowflake.

This guide details essential security best practices for Snowflake data warehouses. It covers implementing network policies, managing key rotation, enabling Multi-Factor Authentication (MFA), and securing credentials using secret managers. Use this comprehensive resource to audit security configurations, restrict network access, and enforce least-privilege access within your Snowflake environment.

This comprehensive guide provides step-by-step instructions for upgrading Snowflake drivers (Node.js and Python) and managing complex data warehouse migrations. It covers prerequisite checks, reviewing release notes, handling common API breaking changes (e.g., cursor types, async connections), and performing post-migration validation to ensure application stability during platform or edition upgrades.

Master event-driven patterns within Snowflake using native alerts, email integrations, external functions, and cloud notification services (S3/GCS). This skill is essential for building robust, reactive pipelines that trigger actions (like sending alerts, calling external APIs, or ingesting data) in response to data changes or specific system events. Use cases include data quality checks, real-time monitoring, and automated notifications.