Project types
Choose the right project type for your role and workflow requirements. Your project type determines available features, collaboration models, and integration capabilities.
The project type depends on how you create a new project, based on three key selections:
- Project language: SQL, Python, or Scala
- Git storage model: Simplified publication flow or standard Git branching
- Git provider: Prophecy-managed or external Git repository
Use the following flow chart to view the different project types you can create.
Create templates to standardize project configurations for your team.
Feature matrix
The following tables provide a detailed comparison of capabilities across different project types to help you understand what each type supports.
The feature matrices below show Analytics Engineer projects using models as their primary transformation entity. This reflects the common pattern where analytics engineers work with dbt models on SQL fabrics for pure data transformations. However, analytics engineers can also use pipelines (which uses both SQL and Prophecy Automate) when they need external integrations like API calls, email notifications, or file operations.
Language
| Feature | Data Analyst | Data Analyst + Platform Engineer | Analytics Engineer | Platform Engineer |
|---|---|---|---|---|
| Primary language | SQL | SQL | SQL | Python/Scala |
| Building blocks | Pipelines | Pipelines | Models | Pipelines |
Version Control
| Feature | Data Analyst | Data Analyst + Platform Engineer | Analytics Engineer | Platform Engineer |
|---|---|---|---|---|
| Version control | Simple | Simple + External CI/CD | Normal/Fork | Normal/Fork |
| Collaboration mode | Single-player | Single-player | Git branching | Git branching |
Orchestration
| Feature | Data Analyst | Data Analyst + Platform Engineer | Analytics Engineer | Platform Engineer |
|---|---|---|---|---|
| Prophecy-native scheduling | ✔ | ✔ | ❌ | ❌ |
| External scheduling via APIs | ✔ | ✔ | ✔ | ✔ |
Platform Features
| Feature | Data Analyst | Data Analyst + Platform Engineer | Analytics Engineer | Platform Engineer |
|---|---|---|---|---|
| Prophecy Apps | ✔ | ✔ | ❌ | ❌ |
| Interactive examples | ✔ | ✔ | ✔ | ❌ |
| AI Agents | ✔ | ✔ | ✔ | ❌ |
Execution & Data
| Feature | Data Analyst | Data Analyst + Platform Engineer | Analytics Engineer | Platform Engineer |
|---|---|---|---|---|
| Fabric type | Prophecy | Prophecy | SQL | Spark |
| Execution engine | SQL Warehouse + Prophecy Automate | SQL Warehouse + Prophecy Automate | SQL Warehouse | Spark cluster |
| Data connections | Fabric-level | Fabric-level | None (in-database only) | Gem-level |