The Coralogix JDBC driver allows you to investigate your log data with your favorite database tool using SQL queries.
While using the Kibana querying language syntax would usually be the quickest way to search your logs, using SQL allows you to express queries and aggregations that would sometimes be more difficult to write using Kibana visualizations. With the Coralogix JDBC driver, you can quickly get started on performing SQL queries against the data already stored in your Coralogix account.
JDBC, which stands for “Java Database Connectivity”, is a common standard for database drivers, and many popular querying tools support it. In this tutorial, you’ll find instructions on using the Coralogix JDBC driver with Tableau.
OS | Path |
---|---|
Windows | C:\Program Files\Tableau\Drivers |
Mac | ~/Library/Tableau/Drivers |
Linux | /opt/tableau/tableau_driver/jdbc |
~/Documents/My Tableau Repository/Datasources
For more details consult Tableau documentationcoralogix.properties
and add an entry with your apiKey
. You will get it from Coralogix dashboard Data Flow -> API Keys -> Logs Query Key
apiKey=<Logs Query Key>
To a Server
section choose Other Databases (JDBC)
URL
to
Team URL | Region | URLs |
---|---|---|
team-name.coralogix.com | Ireland | jdbc:coralogix://grpc-api.coralogix.com |
team-name.coralogix.us | US | jdbc:coralogix://grpc-api.coralogix.us |
team-name.app.coralogix.in | India | jdbc:coralogix://grpc-api.app.coralogix.in |
team-name.app.eu2.coralogix.com | Sweden | jdbc:coralogix://grpc-api.app.eu2.coralogix.com |
team-name.app.coralogixsg.com | Singapore | jdbc:coralogix://grpc-api.app.coralogixsg.com |
Dialect
to MySQL
and Leave Username
and Password
blank. Click on Browse
next Properties file
and choose coralogix.properties
you createdSign In
The Coralogix SQL support is based on the OpenDistro SQL interface. Refer to its documentation for further references on supported SQL features.