Advanced visual expressions
Create complex visual expressions that include logical operators, comparisons, and parameters
Create complex visual expressions that include logical operators, comparisons, and parameters
Configure SQL project and model variables
A list of connections that you can configure for projects
Use this tutorial to create a project with data in Snowflake
Data tests check the validity of your SQL
Learn how to connect with Databricks
Run models on a Databricks SQL warehouse
How to create Databricks SQL connection (over DBT) in Prophecy Managed Airflow fabric
Power your pipelines with gems
Location of Target Models
SQL models define a single target table or view
Get familiar with the new SQL user interface
Add variables to your pipelines
Use pipelines in SQL projects
Explore the SQL Project Editor interface
Getting started with a SQL project
Use Prophecy and SQL to run pipelines
Create a pipeline with Prophecy for Analysts
Schema of Target Models
Learn how to connect with Snowflake
How to create Databricks SQL connection in Prophecy Managed Airflow fabric
Run models on a Snowflake warehouse
Use models to read and write data
Perform SQL computations on a SQL warehouse
SQL Query of Target Models
Create DataFrames based on custom SQL queries
Type and Format of Target Models
Upload files to the visual canvas
Reusable SQL query tests
Custom SQL query tests
User-defined functions
About variant data types and how to update their schema
About the visual expression builder
visual expression builder reference
Write Options of Target Models