Skip to main content

Singer

A Singer target that writes data to data.world

How to use it

target-datadotworld works together with any other Singer Tap to store on data.world data extracted from sources like SalesForce, HubSpot, Marketo, MySQL and more.

Install and Run

First, make sure Python 3.6 is installed on your system.

target-datadotworld can be run with any Singer Tap, but we'll use tap-fixerio which pulls currency exchange rate data - as an example.

These commands will install tap-fixerio and target-datadotworld with pip, and then run them together, piping the output of tap-fixerio to target-datadotworld:

? pip install target-datadotworld tap-fixerio
? tap-fixerio | target-datadotworld -c config.json
INFO Replicating the latest exchange rate data from fixer.io
INFO Tap exiting normally

The data will be written to the dataset specified in config.json. In this specific case, under a stream named exchange-rates.

If you're using a different Tap, substitute tap-fixerio in the final command above with the command used to run your Tap.

Configuration

target-datadotworld requires configuration file that is used to store your data.world API token and dataset information.

The following attributes are required:

  • api_token: Your data.world API token

  • dataset_id: The title of the dataset where the data is to be stored. Must only contain lowercase letters, numbers, and dashes.

Additionally, the following optional attributes can be provided.

  • dataset_owner: If not the same as the owner of the API token (e.g. if the dataset is to be accessed/created under an organization account, as opposed to the user's own)

Example:

{
    "api_token": "your_token",
    "dataset_id": "fixerio-data",
    "dataset_owner": "my-company",
}