This feature may not be available by default and might need to be enabled upon request. Please contact your account manager for more information.

Live DB Compare 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.

Live DB Revision with Direct Connection

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.

Live DB Revision with static DDL (all DWs)

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.