Ataccama ONE Agentic Cloud Portal ONE Desktop ONE DQ&C ONE MDM ONE RDM ONE Runtime Server
latest (17.0.0) 16.3.0 16.2.0 16.1.0 16.0.0 15.4.0 15.3.0 15.2.0 15.1.0 14.5.x 13.9.x 13.8.x 13.7.x 13.6.x 13.5.0 13.4.x 13.3.x 13.2.x
User Community Service Desk Downloads

Synchronize Snowflake UDFs with ONE

This page explains how to keep deployed Snowflake UDFs synchronized with the DQ firewalls defined in Ataccama ONE.

How synchronization works

The UDF synchronization flow is:

  1. Update the firewall logic in Ataccama ONE.

  2. Rerun the Snowflake deployment notebook.

  3. Redeploy the affected UDFs in Snowflake according to the selected conflict strategy.

  4. Remove obsolete UDFs manually if needed.

For the initial rollout, see Install Data Quality Gates for Snowflake UDFs.

Update firewall UDFs

To synchronize Snowflake UDFs with the current firewall definitions in Ataccama ONE, rerun the deployment notebook used during installation.

This process:

  • Downloads the updated firewall definitions from ONE.

  • Attempts to register the current set of UDFs in Snowflake.

  • Creates UDFs for newly added firewalls.

How existing UDFs are handled depends on the conflict strategy configured in the deployment notebook. See Conflict strategies.

The synchronization flow does not automatically remove UDFs whose source firewalls were deleted or deactivated in ONE.

Delete obsolete UDFs manually

If you need to remove a UDF from Snowflake without changing the firewall in ONE, use the Snowflake DROP FUNCTION command:

DROP FUNCTION <udf_name>

Manual deletion removes the UDF only from Snowflake. If the firewall still exists in Ataccama ONE, it can be redeployed the next time you rerun the synchronization flow.

Was this page useful?