Parse RDF JSON-LD file and save to Redshift without programming

by

Posted on by

Want to parse RDF JSON-LD (JSON for Linking Data) file and save to Redshift?

Using File To DB, a native GUI tool for Windows, MacOS, and Linux, you can import RDF JSON-LD file (.jsonld) 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 JSON-LD file(s) to online services.

Download FileToDB Download FileToDB

Import RDF JSON-LD file (.jsonld) to Redshift

Choose Redshift and logon.

convert JSON-LD file to Redshift table - Choose Redshift and logon

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

convert JSON-LD 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 JSON-LD file.

import RDF JSON-LD file (.jsonld) to Redshift - open RDF JSON-LD 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 JSON-LD file (.jsonld) to Redshift - config Redshift fields

3. Summary.

Transfer RDF JSON-LD file (.jsonld) to Redshift - summary

4. Import data from RDF JSON-LD file (.jsonld) to Redshift.

Convert RDF JSON-LD file (.jsonld) to Redshift - import to Redshift

See importing results in Redshift table

Store RDF JSON-LD file (.jsonld) to Redshift - view Redshift table

Convert RDF JSON-LD to Redshift in command line

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

Set scheduled tasks for converting RDF JSON-LD 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), N-Quads(.nq, .nq).

FAQ

More about FileToDB – RDF to Redshift converter