We're delighted to announce that Data Controller now supports Snowflake as a data modification target! This means you can use Data Controller's full suite of governed data editing, approval workflows, and audit trail capabilities directly against your Snowflake tables — on both SAS 9 and SAS Viya.

What This Means for You

If your organisation stores data in Snowflake, you can now:

• Edit Snowflake table data through the familiar Data Controller interface
• Submit changes for review and approval before they are applied
• Audit every change with a complete, tamper-evident history

Say goodbye to uncontrolled spreadsheet uploads and ad-hoc database edits. Every Snowflake modification now flows through the same robust approval process that governs the rest of your Data Controller tables.

Implementation Details

On SAS Viya, the library should be assigned in the autoexec. On SAS 9, Snowflake library assignments can come from the autoexec, or from SAS Metadata. Simply register your Snowflake library in SMC or SAS DI Studio as you normally would, and Data Controller will pick it up automatically.

Both the SNOW (alias) and SASIOSNF engines are supported.

Native Passthrough SQL

Under the hood, Data Controller uses native passthrough SQL to interact with Snowflake. This means:

• Modifications are pushed directly to Snowflake using its own SQL dialect
• The target table does not need to be indexed (but must unique on its primary key)
• Maximum performance and compatibility with Snowflake's architecture is assured

Getting Started

Snowflake support is available out of the box — no additional configuration is required beyond your existing Snowflake library assignment in SAS. More details on Data Controller are available in the documentation.

Ready to bring governed data modification to your Snowflake environment? We'd love to hear from you!