Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The only parameter that is really important and that matters, is the “Database raw connection string”. The CSV JDBC driver must connect to a local folder (local on the machine where the job using the CSV driver will run), containing CSV files you want to crawl. So the “Database raw connection string” must be set with the absolute path of the local folder containing the CSV files to crawl, for example ‘/home/francelabs/csv’. The specified folder and all its subfiles must also have read permissions for the user running the MCF instance, which is ‘datafari’ by default on a standard Datafari installation.

2. Queries

Concerning the queries, there are some things to understand in order to build working ones.

First, the tables names correspond to the CSV files names in the folder you configured in the database connection. For example, if considering you have the following files in the folder configured in section 1:

Code Block
accounts.csv
persons.csv
projects.csv

And assuming the persons.csv file contains a column named ‘id’ and you want to build a query that selects the ‘id’ column of the CSV file named ‘persons.csv’ then this column. Then you will build the following query:

...