Why Does the model Column in the Salesforce FIVETRAN_FORMULA_MODEL Table Have null Values?
Environment: Salesforce connections syncing to Redshift destinations
Redshift VARCHAR columns are limited to 65,535 characters. If an object with many fields or references generates a dbt* formula that exceeds this limit, we can't sync the value to Redshift.
Your values are not subject to the same limitation if you use our Formula Fields Quickstart transformation model.
* dbt Core is a trademark of dbt Labs, Inc. All rights therein are reserved to dbt Labs, Inc. Fivetran Transformations is not a product or service of or endorsed by dbt Labs, Inc.