Live DB Compare is an Enterprise feature that allows users to compare project revisions against their existing environments that support direct connection. For the list of supported project types, see the related article at the end of this post.

Select the "Compare Revisions" panel from the left menu. Click the "+" icon next to "Live DB Connection".

Select the "Connect with [DW]" option

Enter your DW connection parameters.

Select your database and schema(s).

If using Snowflake, an additional step follows to allow for object-level filtering. By default, all schema objects are selected. Use the search bar and checkboxes to select/unselect desired objects.

Press "Apply" and review the metadata on the following screen.

Press "Import" and you will be able to perform the revision against the DDL that you've just imported.

Select the revision you wish to compare and "Live DB Connection" which now contains the corresponding DDL.

To perform a fresh Live DB Revision, clear the current "Live" DDL by pressing the "X" icon next to "Revision from uploaded DDL" and perform the steps again.

Select the "Compare Revisions" panel from the left menu. Select the revision you wish to compare and click the "+" icon next to "Live DB Connection".

Select the "Provide your DDL" option

Paste your DDL into the text box or upload a saved file.

Press "Upload script" and review the metadata on the following screen.

Press "Import" and you will be able to perform the revision against the DDL that you've just imported.

Select the revision you wish to compare and "Live DB Connection" which now contains the corresponding DDL.

To perform a fresh Live DB Revision, clear the current "Live" DDL by pressing the "X" icon next to "Revision from uploaded DDL" and perform the steps again.

See also:

Direct DW Connection

Compare Revisions