Documentation index: llms.txt. This page is also available as markdown: append .md to this URL or send Accept: text/markdown.
Solving Git Errors
There will be times when you’ll need to fix errors before you can merge your changes. This section will help you understand and resolve frequent issues that may happen.
Deploys and refreshes
Master job monitoring and troubleshooting in Coalesce data transformation platform. Learn to analyze deployment results, understand error messages, debug failed pipeline jobs, and implement solutions for common data warehouse deployment issues to ensure reliable transformations and continuous delivery workflows.
Git errors
Comprehensive troubleshooting guide for Git errors in Coalesce data transformation platform. Learn to resolve common version control issues, merge conflicts, sync problems, and authentication failures in enterprise data warehouse development workflows.
SQL Nodes
Fix common SQL Node Type issues with columns, refs, parsing, and annotations. Review known limitations, platform scope, and FAQ on lineage, Jinja, upgrades, and SQL support.
coa
Resolve common Coalesce CLI messages and behaviors around create, validate, plan, dry-run, ref types, V2 SQL parsing, required fields, and repo metadata.
Transform MCP
Resolve authentication, connection, permission, and run guardrail errors when using the hosted Transform MCP server with AI clients.
coa deployment errors
Resolve common Coalesce deployment errors including permission requirements, Snowflake view validation, and blank column names. Links to existing troubleshooting docs and error-library entries.
Data type changes in Snowflake
Step-by-step workflow for changing column data types in Snowflake when Coalesce cannot apply the change. Covers copy-table migration, SWAP, metadata sync, and recovery from failed deployments. Essential for Type 2 SCD and tables where column order matters.
Job timeouts and run failures
Diagnose deploy and refresh timeouts, DEADLINE_EXCEEDED, stuck or queued runs, and credential-related job failures. Learn how to tell slow progress from a true timeout, reduce risk with parallelism and batching, use refresh overrides safely, and what to send Coalesce Support for triage.
Snowflake table re-creation during deployment
Interpret Snowflake deploy plans when Coalesce alters or re-creates tables. Learn what Replace Table, Create Table, and Drop Table stages mean, when re-creation is expected, how to prevent unintended drops, and how to recover with rollback and Time Travel.
Storage mapping deployment failures
Troubleshoot "No schema found" and other storage mapping deployment failures. Learn causes, fixes, and prevention for invalid mappings, orphaned locations, permissions, and version control issues.
Drop-down selectors
Can I Implement a Drop-Down Selector?
Data type and nullability mismatches
Explanation of why data types and nullability might not match between Coalesce and Snowflake, and how to resolve this.
Characters added to Node names
Ways to solve unwanted charecters being added to Node names.
Quoted identifiers in Coalesce
Learn how Coalesce handles quoted identifiers on Snowflake, Databricks, and BigQuery, the differences in formatting, and best practices for ensuring compatibility across data platforms.
Duplicates in SCD Type 2 Nodes
When using SCD Type 2 dimension nodes, you may encounter errors when business keys aren't unique enough for a new record to be inserted, instead resulting in an error.
Create a Node from an existing table
How Do I Create A Node From An Existing Table?
Multiple Workspace connections
Learn about Workspace connection limits and how to work with multiple databases and schemas through Storage Locations.
Tables dropped outside of Coalesce
Explains what happens when you drop Coalesce-managed tables in your data platform and how to remove objects correctly through Coalesce.
Refresh Jobs after a failed deploy
Refreshing jobs when deployment is in a failed status
Performance issues
If you're experiencing performance issues or slowness in Coalesce, this guide provides a structured approach to identifying and resolving common bottlenecks. We recommend starting with your local environment before investigating pipeline design and the underlying data platform configuration.
Browser login and blank screens
Fix blank or spinning screens when logging into Coalesce. Covers network restrictions, firewall configuration, CORS errors, and SSO setup validation.
EMEA terms and conditions
These Coalesce Terms and Conditions together with the order to which they are attached...
SSO errors
Diagnose and fix single sign-on (SSO) issues in Coalesce Transform, including MFA expectations, identity provider configuration, network and OAuth problems, and how Catalog SCIM differs from Transform SSO.
Exporting data
Learn ways export your Coalesce data from the individual run or data preview CSV/Excel exports, and use the Copy Unload Node to push data to external destinations like AWS.
Find your Snowflake account
Find your account information to connect to Coalesce
Frequent sign-in prompts
What to do if you're getting prompted to enter your password multiple times
General FAQ
Find answers to common questions about Coalesce.
Case sensitivity in Snowflake
How to work with case sensitivity in Coalesce and Snowflake
Supported data types
Learn what data types are supported in Coalesce and how to extend them using pre-built Packages or custom Nodes. This guide covers native compatibility and customization options for advanced data modeling in your data platform.
Trial accounts
Understand how to manage your Coalesce trial account, remove the trial banner, and access support.
Expired Git credentials
Learn how to detect expired version control tokens for GitHub, GitLab, Bitbucket, and Azure DevOps, regenerate them efficiently, and update credentials in Coalesce to avoid authentication failures.
Git sync
Resolve Git synchronization issues in Coalesce data transformation platform. Learn to handle branch out-of-sync errors, create new branches to preserve work, merge changes safely, and maintain data pipeline integrity during collaborative development workflows.
Merge aborted errors
Learn how to resolve "Merge Aborted" errors in Coalesce when merging branches with Git integration.
Merge conflicts
Resolve Git merge conflicts in Coalesce data transformation platform. Learn to identify conflict markers, choose between local and remote changes, and safely merge branches while maintaining data pipeline integrity in collaborative enterprise data warehouse development.
Parsing errors
Resolve Git parsing errors in Coalesce data transformation platform. Learn to identify and fix YAML formatting issues including indentation problems, missing commas, incorrect quotes, and syntax errors that prevent successful version control operations.
Repo format upgrade
Handle repository format upgrades in Coalesce data transformation platform. Learn about the automatic upgrade process from single data.yml files to modular components including node types, environment mappings, and metadata structures for improved version control.
Validation errors
Fix Git validation errors in Coalesce data transformation platform. Learn to resolve semantic issues, data type mismatches, and protected file violations while maintaining proper YAML structure and repository integrity in enterprise data warehouse projects.