Getting started
Log in, add data sources, create Projects, and more
01.
Logging in to your account
Learn what to expect when logging in to your new Coalesce account for the first time, including the default Project and Workspace setup.
0:47 Sec
02.
Adding data sources
Learn to use the build interface to add source nodes representing tables, external tables, and raw data views.
0:39 Sec
03.
Creating Projects
Learn how Coalesce Projects provide the flexibility to organize your projects for a specific purpose or goal.
2:00 Min
04.
Creating Workspaces
Learn how to set up a Coalesce Workspace, where you will spend time developing your data transformations.
1:10 Min
05.
Creating storage locations
Learn how to configure storage locations to use any data source in Snowflake.
0:54 Sec
06.
Creating storage mappings
Map the physical locations of your database and schemas in Snowflake to your configured storage locations.
1:26 Min
07.
Setting up OAuth
Learn how to set up OAuth in your Coalesce account.
1:12 Min
08.
Adding new users
Learn to add new users to your Coalesce account via the org settings.
1:01 Min
Building data pipelines
Create Nodes, migrate existing code, use column-level lineage, and more
09.
Creating Stage Nodes
Learn how to create Stage Nodes to prepare data for transformation using any Snowflake-supported function and apply business logic to your data.
1:35 Min
10.
Creating Dimension Nodes
Learn how to easily create type 1 or type 2 slowly changing dimension Nodes with just a few clicks.
2:02 Min
11.
Lifting and shifting existing code
Learn the common pattern used to move data models from code-first solutions to Coalesce.
7:02 Min
12.
Working with custom Node Types
Learn how to create a custom Node Type to solve specific use cases or data modeling scenarios, such as streams, dynamic tables, and external tables.
8:03 Min
13.
Using column-level lineage
Learn how to select and view the column-level lineage of any Node across your DAG.
2:05 Min
14.
Working with ML Forecasting Nodes
Learn how to take advantage of powerful machine learning capabilities using Snowflake Cortex functions configured as Nodes within your Coalesce Workspace.
4:15 Min
Setting up version control
Set up Git, commit and push code, merge changes, and more
15.
Setting up Git
Learn how to set up version control for each new Project you create.
2:13 Min
16.
Git best practices in Coalesce
Discover best practices for developing pipelines leveraging Git with Coalesce.
3:09 Min
17.
Performing a commit and push
Learn how to easily commit and push changes to your data pipelines using Coalesce.
0:42 Sec
18.
Merging using the Git modal
Learn how to merge changes from one branch to another as you develop data pipelines in Coalesce.
0:55 Sec
19.
Resolving merge conflicts
Learn how to resolve merge conflicts in Coalesce when two commits can’t be merged due to conflicting changes.
0:50 Sec
Deploying and refreshing data pipelines
Deploy work, refresh pipelines, schedule Jobs, and more
20.
Deploying in Coalesce Environments
Learn how to deploy your work to a Snowflake higher environment using Coalesce.
1:00 Min
21.
Deploying and refreshing data pipelines with Azure DevOps
Learn how to use Azure DevOps to deploy and refresh your Coalesce data pipelines.
5:50 Min
22.
Scheduling Coalesce Jobs with Airflow
Learn how to configure Airflow to execute Coalesce Jobs and set up DAGs to run your Coalesce pipelines.
2:52 Min
23.
Automating Jobs with Snowflake Scheduler
Learn how to schedule and automate Coalesce Jobs within Snowflake, without using another system.
1:07 Min
Troubleshooting
Mitigate common errors that arise in Snowflake and Coalesce while building data pipelines
24.
Troubleshooting Coalesce errors
Learn ways to understand common errors you may encounter while building data pipelines using Coalesce.
1:52 Min
25.
Troubleshooting Snowflake SQL errors
Learn how to resolve common errors you may encounter while creating, running, or configuring Nodes resulting from Snowflake SQL or compilation errors.
3:29 Min
