Here is a quick 3-step process for querying CSV data in Holistics. CSV reporting in Holistics requires you to import data into a reporting SQL database.
You can import CSV to your Database in either 2 ways:
1, Go to Data Manager by clicking Manage:
2, Click Upload CSV and follow the instructions to import your CSV:
This requires Holistics CLI, make sure you have set up it.
Login and authenticate. You can get the token in Holistics (go to Settings, under API Key section)
To import a CSV file into database, run the following:
-f: path to your CSV file on local computer, make sure the CSV file has header row
-d: id of destination data source
-t: destination table name, e.g: