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
Use a dynamic location for your target model
Power your pipelines with gems
Run models on a Google BigQuery warehouse
Review different use cases for write options and merge approaches
Use models to read and write data
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
Learn how to connect with Snowflake
How to create Databricks SQL connection in Prophecy Managed Airflow fabric
Run models on a Snowflake warehouse
Perform SQL computations on a SQL warehouse
Create DataFrames based on custom SQL queries
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