Parse RDF N-Quads file and save to Redshift without programming

by

Posted on by

Want to parse RDF N-Quads file and save to Redshift?

Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can import RDF N-Quads file (.nq, .nquads) to Redshift easily and fast.

  • Can run in GUI mode, Step by Step, just a few mouse clicks.
  • Can run in Command line, for Scheduled Tasks and Streams.
  • Convert files locally and privately, avoid uploading large NQ file(s) to online services.

Download FileToDB Download FileToDB

Import RDF N-Quads file (.nq, .nquads) to Redshift

Choose Redshift and logon.

convert NQ file to Redshift table - Choose Redshift and logon

Click “Wizard – 1 File To 1 Table” at task dialog.

convert NQ file to Redshift table - task window

Select the “RDF” file type.

Import file data to database table - select file type

then show the wizard.

1. Open RDF N-Quads file.

import RDF N-Quads file (.nq) to Redshift - open RDF N-Quads file

2. Select table and config fields.

You can create new Redshift table by RDF struct, just click create Redshift table by RDF struct

Load RDF N-Quads file (.nq) to Redshift - config Redshift fields

3. Summary.

Transfer RDF N-Quads file (.nq) to Redshift - summary

4. Import data from RDF N-Quads file (.nq) to Redshift.

Convert RDF N-Quads file (.nq) to Redshift - import to Redshift

See importing results in Redshift table

Store RDF N-Quads file (.nq) to Redshift - view Redshift table

Convert RDF N-Quads to Redshift in command line

Save “RDF to Redshift” session, then you can:

Set scheduled tasks for converting RDF N-Quads to Redshift

You can schedule and automate this importing task by:

1) Save session and create .bat file.

2) Set scheduled task.

For importing other RDF formats: RDF/XML(.rdf, .owl), Turtle(.ttl, .n3), N-Triples(.nt, .ntriples), JSON-LD(.jsonld).

FAQ

More about FileToDB – RDF to Redshift converter