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

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.

Solution

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.