For this reason, it is important to create the table on CrateDB with camelcase column names between quotes to import the csv data successfully. CrateDB is case-sensitive when attributes are declared between quotes, else not.
I download CrateDB (version 4.6.1) and unpack it. In this tutorial, I use the Ad-hoc method to install CrateDB, following this step-by-step tutorial.
#Datagrip install how to#
In this post, I will show you how to get set up with CrateDB and DataGrip as a desktop client for macOS, but these instructions should be adaptable for Linux or Windows. With the help of the PostgreSQL JDBC Driver, you can use DataGrip with CrateDB. This blog post has originally been posted on September 25 th, 2018 by Naomi Rose and has been updated by Rafaela Sant'ana.ĭataGrip is a cross-platform database IDE (Integrated Development Environment) that is tailored to suit the specific needs of professional SQL developers.