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:
| Provider | Example Dataset | Use Case |
|---|---|---|
| FactSet | Financial Markets Data | Investment analysis |
| SafeGraph | Foot Traffic and POI Data | Retail site selection |
| Weather Source | Weather Forecasts & Climate Data | Weather impact analysis |
| S&P Global | Market Intelligence Data | Credit 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!