Skip to main content

Snowflake Marketplace Native Apps

A Marketplace Native App in Snowflake is an application built by a third-party provider (or internal team) that runs directly inside Snowflake. It goes beyond providing raw data by delivering analytics, models, and dashboards as a managed app.

  • ✅ Key Features:

    • Runs natively in your Snowflake account, using Snowflake’s compute and security environment.
    • Includes components like stored procedures, functions, dashboards, and other features.
    • Providers manage and update the app, while you retain control over data processing.
    • Apps can securely analyze your own data inside Snowflake.
  • ✅ Example Use Cases:

    • Financial Risk Modeling: Subscribe to a risk modeling app that processes your transactional data.
    • Marketing Analytics: Use a marketing app to run attribution models on your customer data.
    • Data Enrichment: Enrich your datasets with third-party data and insights directly in Snowflake.
  • ✅ Accessing a Native App: 1️⃣ Browse and subscribe in the Snowflake Marketplace.
    2️⃣ Install the app in your Snowflake account.
    3️⃣ Interact with the app using SQL or via the Snowflake UI.

  • ✅ Example SQL Usage:

CALL third_party_app.perform_analysis('my_table');
  • ✅ Advantages:

    • No data movement outside Snowflake, maintaining compliance and performance.
    • Provider ensures updates and enhancements.
    • Pay-as-you-go pricing models keep costs flexible.
  • ✅ Best Practices:

    • Validate app security posture – Snowflake reviews apps for Marketplace.
    • Use roles and access controls to manage usage.
    • Monitor compute usage to avoid unexpected costs.

Accessing Third-party Datasets

Accessing external datasets (third-party data) in Snowflake is easy and secure using Snowflake Marketplace and Data Sharing.

  • ✅ Step 1: Browse Marketplace

    • Go to Marketplace in the Snowflake UI.
    • Search for datasets by category or provider.
  • ✅ Step 2: Request Access

    • Review dataset details (schema, pricing, update frequency).
    • Click “Get” to request access.
  • ✅ Step 3: Data Share Creation

    • Snowflake creates a read-only database with the data once approved.
  • ✅ Step 4: Query the Data

    • Example:
SELECT * FROM WEATHER_DATA.PUBLIC.WEATHER_FORECAST
WHERE CITY = 'New York';
  • ✅ Benefits:

    • Live and ready-to-query data.
    • Automatic updates – no manual ETL or data pulls.
    • No data movement – data stays in the provider’s Snowflake account.
  • ✅ Other Ways to Access Third-party Data:

    • Direct Data Sharing: Outside Marketplace, providers can share data securely with your account.
    • External Tables: Connect to cloud storage (e.g., S3, Azure Blob) for external data.
    • Data Exchange: Secure sharing within your organization or ecosystem.
  • ✅ Example Marketplace Providers:

ProviderExample DatasetUse Case
FactSetFinancial Markets DataInvestment analysis
SafeGraphFoot Traffic and POI DataRetail site selection
Weather SourceWeather Forecasts & Climate DataWeather impact analysis
S&P GlobalMarket Intelligence DataCredit risk assessment
  • ✅ Best Practices:

    • Access Control: Use roles and grants to manage data access.
    • Documentation: Keep a record of dataset usage and purpose.
    • Cost Management: Some Marketplace datasets are paid; monitor usage and budget.
  • ✅ Impact on Performance and Cost:

    • Data sharing and Marketplace datasets don’t affect your warehouse performance directly unless queried.
    • Querying third-party data uses your compute resources – monitor warehouse usage.
    • Marketplace apps process data in your environment – plan for compute costs.
  • ✅ Key Takeaways:

    • Snowflake Marketplace enables easy, secure access to external datasets and apps.
    • Native Apps extend this by bringing analytics directly into your Snowflake environment.
    • Use these tools to accelerate insights, enrich your data, and unlock new use cases!