Openflow Connector for Salesforce Bulk API: Salesforce formula fields¶

How formula views work¶

When Enable Views Creation is set to true, the connector performs the following for each object that has formula fields:

1. Retrieves the formula expressions from the Salesforce object metadata via the Describe API.

2. Parses each formula expression and translates it into equivalent Snowflake SQL.

3. Generates a CREATE OR REPLACE VIEW statement that combines non-formula columns from the base table with the translated formula expressions as computed columns.

4. Runs the DDL against Snowflake to create or update the view.

The resulting view is named <Object Type>_FORMULA_VW. For example, the Account object produces a view named ACCOUNT_FORMULA_VW. You can query this view to obtain formula field values alongside the replicated data.

The view is automatically updated whenever the connector detects schema changes in the source object, ensuring that formula definitions stay in sync with Salesforce.

Cross-object formula fields¶

Salesforce formulas can reference fields from related objects using relationship traversal (for example, Account.Owner.Name). The connector supports these cross-object references by generating LEFT JOIN clauses in the view definition. Each relationship traversal produces a join to the corresponding related table in Snowflake.

For cross-object formulas to work correctly, the related objects must also be replicated by the connector. The connector does not check whether the referenced tables exist in Snowflake at translation time. If a related object is not being synced, the generated CREATE OR REPLACE VIEW statement references a table that does not exist in Snowflake, and the view creation fails. To resolve this, ensure that all related objects referenced by formula fields are included in the Filter parameter. The view is automatically recreated on the next connector run after the referenced tables exist.

Formula view column comments¶

Each formula column in the generated view includes a SQL COMMENT annotation:

• For successfully translated formulas, the comment contains the original Salesforce formula expression.

• For formulas that could not be translated, the comment contains the failure reason code.

You can inspect these comments by running DESCRIBE VIEW <view_name> in Snowflake.

Supported formula functions¶

The following Salesforce formula functions are translated into equivalent Snowflake SQL:

In addition to functions, the following operators are supported:

• Arithmetic: +, -, *, /, ^ (exponentiation, translated to POWER)

• Comparison: =, ==, !=, <>, <, <=, >, >=

• Logical: AND, OR, &&, ||

• String concatenation: & (translated to || with COALESCE null handling)

• Unary: - (negation), NOT

Unsupported formula constructs¶

The following formula constructs are not yet supported. Support for additional functions and constructs will be added in future releases. When a formula uses any of these, the corresponding column in the view returns NULL and the column comment indicates the failure reason.