Next StepĪfter connecting DataGrip to Exasol, you can start loading data into the Exasol database. If the console is not visible, right-click the Exasol datasource and select Open Console or click icon and select New Console. The result is displayed in the same window. Enter an SQL statement in the database console.If all the objects of the database are not visible after adding Exasol as a datasource, click icon in toolbar or right-click the Exasol datasource and select Synchronize. Click Test Connection to check the connection and then click OK to finish.
DataGrip is a combination of an intelligent SQL editor and collection of. If a driver is missing, you can download it by clicking the Download link at the bottom of the dialog. Choose the XML option from the Format dropdown to export the database or table. Enter the following details on Data Source and Drivers dialog:.Click icon in the Database tool window and select Data Source > Exasol.Select File > New > Data Source > Exasol.Launch DataGrip and do one of the following to create Exasol as a data source:.Network connection where Exasol database and the host with DataGrip are connected to.DataGrip should be installed and running on your system.Exasol should be installed and running on your system.The following environment is used as an example: DataGrip comes with a built-in Exasol driver.
#DATAGRIP FORMAT SQL HOW TO#
This section describes how to connect DataGrip to Exasol and run an SQL statement.
0 kommentar(er)
