Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version r091

D toc

Excerpt

This section contains information on the fie formats and compression schemes that are supported for input to and output of 

D s product
rtrue

Info

NOTE: To work with formats that are proprietary to a desktop application, such as Microsoft Excel, you do not need the supporting application installed on your desktop.

...

  • General:

    Code Block
    "/"
  • Seb browser: 

    Code Block
    "\"
  • Excel filenames:

    Code Block
    "#","{","}"
  • Spark-based running environment:

    Code Block
    "{", "*", "\"

Native Input File Formats

...

  • Excel (XLS/XLSX)

    Info

    NOTE: Other Excel-related formats, such as XLSM format, are not supported.


    Tip

    Tip: You may import multiple worksheets from a single workbook at one time. See Import Excel Data in the User Guide.

  • Google Sheets

    D s ed
    rtrue
    editionsgdpent,gdppro,gdpsta,gdppr,gdpst,awsent,awspro,awspr

    Tip

    Tip: You may import multiple sheets from a single Google Sheet at one time.

  • PDF

  • JSON v2

Notes on JSON:

There are two methods of ingesting JSON files for use in the product. 

...

D s product
 can write to these file formats:

  • CSV
  • JSON

  • Avro

  • BigQuery Table

Compression Algorithms

...

File extension

Format name

Notes

.sz

Framing2 format

See: https://github.com/google/snappy/blob/master/framing_format.txt 

.snappy

Hadoop-snappy format

See: https://code.google.com/p/hadoop-snappy/

Info

NOTE: Xerial's snappy-java format, which is also written with a .snappy file extension by default, is not supported.

...

D s also
inCQLtrue
label((label = "file") OR (label = "file"))