Connector Improvement: Overflowing SFDC Formula Field View Definition Should Be Stored Across Multiple Rows or Columns
If the constructed view for a SFDC formula field model is greater than the max character limit (65535) of a SQL column, then the view definition shows up as NULL in the fivetran_formula_model table. Without this, there isn't a good way to get the view definition of a formula field table.
If a view definition is greater than the character limit for a single column, it should be broken up and stored across several columns in the same row or stored across multiple rows, that way the view definition can be retrieved from the fivetran_formula_model table.
Please sign in to leave a comment.
Comments
0 comments