37 docs tagged with "sql"

Configure SQL project and model variables

A list of connections that you can configure for projects

Using SQL with Prophecy's Data Transformation Copilot

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

Execution

Power your pipelines with gems

Location of Target Models

access your 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

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

Perform SQL computations on a SQL warehouse

SQL Query of Target Models

Create DataFrames based on custom SQL queries

Target Models are a sequence of data transformation steps which define a single table or view

Type and Format of Target Models

Upload files to the visual canvas

Reusable SQL query tests

Custom SQL query tests

Use the Expression Builder

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