Why Does the model Column in the FIVETRAN_FORMULA_MODEL Table Have null Values?
Question
Why Does the model Column in the FIVETRAN_FORMULA_MODEL Table Have null Values?
Environment
- Connector: Salesforce
- Destination: Redshift
Answer
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.
NOTE: 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.