DataGrip
 
Get DataGrip

DDL mappings

Last modified: 04 December 2024

DDL mapping functionality sets the relation between the regular data source and the DDL data source. By using mapping, you can explicitly select schemas in the real data source to synchronize objects with the DDL data source. And, alternatively, any changes in the DDL data source can be applied to a regular data source.

For more information about using DDL data source and DDL mapping to keep your regular data source under VCS, refer to the Databases in the Version Control System tutorial.

For example, you can create the actor_1 table in your PostgreSQL data source, and later by using the DDL Mapping | Update from PostgreSQL action in the context menu, add the actor_1.sql file to your DDL data source folder with SQL files. Or, add actor_1.sql file to the DDL data source, select DDL Mapping | Apply to PostgreSQL in the context menu, and the actor_1 table will appear in the PostgreSQL data source.

DDL Mappings tab in the Data Sources and Drivers dialog