The Data Prep (Paxata) documentation is now available on the DataRobot public documentation site. See the Data Prep section for user documentation and connector information. After the 2021.2 SP1 release, the content on this site will be removed and replaced with a link to the DataRobot public documentation site.
This article will help you learn how to export your datasets and AnswerSets™out of Paxata®to a connected data source.
Datasets and AnswerSets can be exported out of Paxata to a file on your computer or to a connected data source. Exporting your data gives you the flexibility to share your data with other people or other systems.
Export a dataset
Follow these steps to export a dataset or AnswerSet.
On theLibraryscreen, hover the cursor over the dataset you want to export.
Result:The dataset actions appear.
Click theExportbutton that displays
Result:TheExporting Datasetpage appears.
Select the location to export the file to:
To export to ...
A connected data source
Select the data source from theSelect Data Sourcedrop-down.
Result:TheExport Settingspanel appears.
Adjust the settings as needed.
Result:The dataset is exported to the location you specified.
Adjust the export settings
The export settings allow you to define the structure of your dataset for export. The settings available for a dataset depend on the format you’ve chosen for the export. For specific information about a setting, hover your cursor over the help tip.
The following are a few of the frequent and more basic settings you can adjust:
To change the ...
Format of the dataset
Select the format you want to apply to the dataset from theFormatdrop-down.
Name of the dataset
Type the new name in theNamefield.
Character set used
Note:From an English character set to Japanese character set
Select a different character encoding from theCharacter Encodingdrop-down.
Note:The byte order mark (BOM), also known as the unicode signature BOM, particularly applies to extended character sets like UTF-16 and UTF-32.
The following definitions for terms used in this document.
Like adatasetexcept that it is the published result of your data prep
The data on which all other action in the Project will be performed
The source of your dataset
Data that is imported into the Data Library is called adataset
The combination of the functionality of filters with the power of histograms