Copilot for SQL users
Using SQL with Prophecy's Data Transformation Copilot
32 docs tagged with "sql"
View All TagsCustom
Gems that don't fit an existing category
Data Sources
access your data
Data tests for SQL
Data tests check the validity of your SQL
Databricks SQL
Run Models on a Databricks Warehouse
Databricks SQL Connection
How to create Databricks SQL connection (over DBT) in Prophecy Managed Airflow fabric
Execution
Execution
Fabrics
Fabrics define execution engines
Location
Location of Target Models
Models
SQL models define a single target table or view
New UI for SQL
Get familiar with the new SQL user interface
Schema
Schema of Target Models
Snowflake Connection
How to create Databricks SQL connection in Prophecy Managed Airflow fabric
Snowflake SQL
Run Models on a Snowflake Warehouse
SQL onboarding
Follow along in the product to make your first SQL model
SQL Query
SQL Query of Target Models
SQL with Databricks
A tutorial on using SQL with the help of Data Transformation Copilot
SQL with Snowflake
Use this tutorial to create a project with data in Snowflake
SQLStatement
Create DataFrames based on custom SQL queries
SQLStatement
Create models based on custom SQL queries
Subgraph
Work with Subgraphs by grouping your Gems in Parent Gems
Target Models
Target Models are a sequence of data transformation steps which define a single table or view
Type and Format
Type and Format of Target Models
Upload files
Upload files to the Visual canvas
Use model and column tests
Reusable SQL query tests
Use project tests
Custom SQL query tests
Use visual expressions
Use the Expression Builder
User-defined functions
User-defined functions
Variant schema
About variant schema
Visual expression builder
About the Visual Expression Builder
Visual expressions reference
Visual Expression Builder reference
Write Options
Write Options of Target Models