SQL onboarding

To get started with Prophecy, you can use the in-product walkthrough for a SQL model or Spark pipeline. This page will describe the SQL onboarding option. If you have completed this walkthrough, you can always return to it again.

Get started

1. Open the Prophecy homepage.
2. Click Onboarding.
3. Select Low-code SQL.

This opens up the visual model canvas! As you begin, notice that Prophecy automatically attaches to a SQL cluster. We provide a default fabric (execution environment) for this onboarding project.

Follow the steps

In this onboarding quick start, follow the orange dot in the product interface to click through the tutorial.

You can automatically go through steps by clicking Auto-connect Gems or Auto-configure the Gem. You can also select Skip to complete the entire model design.

At a high level, this walkthrough helps you:

1. Add input data to your model with a Source gem.
2. Configure a join using the Join gem.
3. Use a Reformat gem to rename columns.
4. Understand how to use the expression editor with the help of the Data Copilot.
5. Group data using a SQL expression in an Aggregate gem.
6. Explore both the visual and code editor views.
7. Run the model and view interim datasets.

What's next?

The in-product walkthrough has helped familiarize you with the visual canvas. Next, you can create your own project and do more with your data!

To understand an entire project workflow, including connecting to execution environments and deploying pipelines, try one of our getting started tutorials.