Live DB Compare is an Enterprise feature that allows users to compare project revisions against their existing environments.
Note that Snowflake, Azure Synapse, Databricks, and BigQuery can be added as direct connections in the "Environments" pane. All database types are supported with static DDL comparisons. See the related article below for more info on Direct Connect.
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).
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 dynamic connection (Databricks)
Select the "Compare Revisions" panel from the left menu. Click the "+" icon next to "Live DB Connection".
Select the "Connect with Databricks" option
Enter your Databricks connection parameters.
Server (ex. xxx-myAccount-xxxx.cloud.databricks.com)
HTTP path (ex. sql/protocolv1/o/12345/123-xyz)
Personal access token (ex. asdf1234fd12s3412d3412dfa341234dsa)
Select a catalog and one or multiple schema(s).
The rest of the steps are the same as Snowflake and Azure explained above.
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.
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: