SnowConvert AI - Informatica PowerCenter - Snowflake Scripting output¶

This page describes the Snowflake Scripting output format for Informatica PowerCenter. In this format, SnowConvert AI converts each Mapping into a Snowflake stored procedure and each Workflow into a Task graph that calls those procedures, instead of running dbt projects.

Important

The Snowflake Scripting output format is in active development. This page is a placeholder; detailed conversion references are coming soon. For the generally available output, see Informatica to dbt.

What this format produces¶

In a Workflow, a Session that runs a Mapping is converted to a procedure call rather than an EXECUTE DBT PROJECT statement:

CALL public.m_load_customers(:scope);

Current status¶

SnowConvert AI is rolling out the Snowflake Scripting output format incrementally. Today it converts the Source, Source Qualifier, Expression, and Target transformations in this format; other transformations are converted in the dbt format. Workflow orchestration (Sessions, Worklets, and the Decision, Assignment, and Email tasks) is supported in both formats.

For the shared references that apply to both formats, see the Informatica PowerCenter overview and the Data types reference.