how do I use my local drive folder as data source in datagrip?

Question

Using Datagrip, I wanna write sql code and take some aggregated data from my csv file saved in my local drive.

How do I point my folder as datasource in datagrip and import csv to there to run sql code? I have csv files in my local drive but don't know how to set my folder as data source and import my csv files as tables to be used.

Answer 1

You can right click on the schema and click on import data from file like below. You will see a window pop up where you specify separators, headers, etc along with a preview.