34 docs tagged with "sql"

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

Learn how to connect with BigQuery

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 your data warehouse from 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