Dataiku Documentation
  • Discussions
    • Setup & Configuration
    • Using Dataiku DSS
    • Plugins & Extending Dataiku DSS
    • General Discussion
    • Job Board
    • Community Resources
    • Product Ideas
  • Knowledge
    • Getting Started
    • Knowledge Base
    • Reference Documentation
    • Developer Guide
  • Academy
    • Quick Start Programs
    • Learning Paths
    • Certifications
    • Course Catalog
    • Academy Discussions
  • Community Programs
    • Upcoming User Events
    • Find a User Group
    • Past Events
    • Community Conundrums
    • Dataiku Neurons
    • Banana Data Podcast
  • What's New
  • User's Guide
  • DSS concepts
  • Connecting to data
    • Supported connections
    • SQL databases
    • Amazon S3
    • Azure Blob Storage
    • Google Cloud Storage
    • Upload your files
    • HDFS
    • Cassandra
    • MongoDB
    • Elasticsearch
    • File formats
      • Delimiter-separated values (CSV / TSV)
      • Fixed width
      • Parquet
      • Avro
      • Hive ORCFile
      • XML
      • JSON
      • Excel
      • ESRI Shapefiles
      • Delta Lake
    • Managed folders
    • “Files in folder” dataset
    • Metrics dataset
    • Internal stats dataset
    • “Editable” dataset
    • kdb+
    • FTP
    • SCP / SFTP (aka SSH)
    • HTTP
    • HTTP (with cache)
    • Server filesystem
    • Dataset plugins
    • Making relocatable managed datasets
    • Clearing non-managed Datasets
    • Data ordering
    • PI System / PIWebAPI server
  • Exploring your data
  • Schemas, storage types and meanings
  • Data preparation
  • Charts
  • Interactive statistics
  • Machine learning
  • The Flow
  • Visual recipes
  • Recipes based on code
  • Code notebooks
  • MLOps
  • Webapps
  • Code Studios
  • Code reports
  • Dashboards
  • Workspaces
  • Dataiku Applications
  • Working with partitions
  • DSS and SQL
  • DSS and Python
  • DSS and R
  • DSS and Spark
  • Code environments
  • Collaboration
  • Specific Data Processing
  • Time Series
  • Geographic data
  • Text
  • Images
  • Audio
  • Video
  • Automation & Deployment
  • Automation scenarios, metrics, and checks
  • Production deployments and bundles
  • API Node & API Deployer: Real-time APIs
  • Governance
  • APIs
  • Python APIs
  • R API
  • Public REST API
  • Additional APIs
  • Installation & Administration
  • Installing and setting up
  • Elastic AI computation
  • DSS in the cloud
  • DSS and Hadoop
  • Metastore catalog
  • Operating DSS
  • Security
  • User Isolation
  • Other topics
  • Plugins
  • Streaming data
  • Formula language
  • Custom variables expansion
  • Sampling methods
  • Accessibility
  • Troubleshooting
  • Release notes
  • Other Documentation
  • Third-party acknowledgements
  • Hive RCFile
  • MapR
  • Hive SequenceFile
  • Guided setup 2: Use an existing VPC
  • Impute with computed value
  • Columns selection
  • Mitigation for PwnKit (CVE-2021-4034)
  • Incorrect access control allows users to edit discussions
  • Ability to tamper with creation and ownership metadata
  • Directory traversal vulnerability in Shapefile parser
  • Incorrect access control in Jupyter notebooks
  • Stored XSS in object titles
  • Stored XSS in object titles
  • Access control issue on downloading project exports
  • Access control issue on changing dataset connections
  • Access control issue on dashboards listing
  • Access control issue on saving project permissions
  • PwnKit Linux vulnerability (CVE-2021-4034)
  • Access control issue on foreign managed folders
  • Cross-script-scripting on model reports
  • Code execution through server-side-template-injection
  • Insufficient access control on managed cluster logs and configuration
  • Multiple access control issues
  • Multiple access control issues
  • Stored XSS in dataset settings
  • Stored XSS in machine learning results
  • Insufficient access control on export to dataset
  • Remote code execution in API designer
  • Session credential disclosure
  • Insufficient access control to project variables
  • Insufficient access control to projects list and information
  • Insufficient access control in troubleshooting tools
  • Credentials disclosure through path traversal
  • Cross-site-scripting through custom metric names
  • Cross-site-scripting through imported Jupyter notebooks
  • Host blacklist bypass
  • Takeover of Jupyter notebooks
  • Missing authentication on internal API call
  • Cross-site-scripting through Jupyter notebooks
  • Race condition on UIF can lead to account takeover
  • Compatibility of DSS with CIS Benchmark Level 1 on RHEL/CentOS
  • Third-party acknowledgements (internal usage)
  • Unstructured data
Dataiku DSS
You are viewing the documentation for version 11 of DSS.
  • »
  • Connecting to data »
  • File formats

File formats¶

Datasets based on files require a file input format.

This section contains detailed information on the supported formats and options.

  • Delimiter-separated values (CSV / TSV)
    • Quoting and escaping styles
      • Excel-style
        • Example
      • Unix-style
        • Example
      • Escaping only
        • Example
      • No escaping, no quoting
    • Usage in datasets
    • Usage in recipes
  • Fixed width
  • Parquet
    • Requirements
    • Applicability
    • Limitations and issues
      • Case-sensitivity
      • Related to Hive
      • Related to Impala
      • Misc
  • Avro
    • Applicability
      • Reading Avro files
      • Reading Avro files / multiple versions
      • Writing Avro files
  • Hive ORCFile
    • Compatibility
    • Limitations
  • XML
    • Handling the structure
      • Selection of the data to load
      • JSON representation
        • Example
    • Using XPath to select data
      • Limitations
      • Selecting values explicitly
        • Example
  • JSON
    • Example
  • Excel
  • ESRI Shapefiles
    • Vecmath library
  • Delta Lake
Next Previous

© Copyright 2022, Dataiku

Built with Sphinx using a theme provided by Read the Docs.