You can copy a data source if you need to use the same data source in another project, but have different requirements to it, such as its accessibility level (project or global), the user, database connection and schema settings, and so on. To share a data source between different projects inside your IDE, you need to move the data source to the global level. By default, a data source is available at the project level. At the global level, a data source is available for other projects. The project level means that you can access a data source only from the project where this data source was created initially.

To add comments for a database, open database settings Ctrl+Alt+S and add a database description in the Comment text field.ĭata sources in DataGrip are available at two levels: project and global.

In the Comment text field, add a table description.

To add comments for tables, select a table and press Ctrl+F6.

To enable descriptions for databases and tables, navigate to View | Appearance and select Descriptions in Tree Views.

Show comments for data sources and database objects

To select the necessary objects, use the Filter icon on the toolbar.

To have the data source color applied for query consoles and grids, select the In console editors and grids checkbox. In the Database Color Settings dialog, select the dialog and coloring options. To set a color, right-click a data source and select Color Settings…. The text data viewer can use the color of the data source.Assign a color to query consoles and grids Select the data source for which you want to assign a color.ģ.Ĝlick the circle in the Name field to select a color. O In the Database Explorer (View | Tool Windows | Database Explorer), click the Data Source Properties icon. You can open data source properties by using one of the following options: To have better differentiation between production and test databases, you can assign a color to a data source.ġ. To remove a data source from the folder, select Root folder. To create a new folder, select New Folder. If you have folders with grouped data sources, you will see the Move to Folder dialog.For example, the QA/Quick name will create the Quick folder inside the QA folder. You can use a forward slash (/) to define nesting. O If you do not have any folders, you will see the New Folder dialog. Alternatively, right-click a data source and select Move to Folder. In the Database Explorer (View | Tool Windows | Database Explorer), select the necessary data source and press F6.In the Database Explorer (View | Tool Windows | Database Explorer), the view of the data source changes instantly To group, enable, or sort data sources, click the Show Options menu icon on the title bar of the Database Explorer and select the necessary options.Customize the view of objects in the Database Explorer You can group, assign a color, and filter objects in the Database Explorer (View | Tool Windows | Database Explorer). ĝata Definition Language (DDL) files: SQL files that contain data definition language statements Configure display options for data sources.

ĝatabase data source: operational databases that contain data (see Database connection).In DataGrip, you can define the following data sources: Data source is a location of data for your application.

Datagrip mongodb connect