Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Section


Column
width76px


Column

This icon performs an ODB/SQL query on an ODB database (ODB-1) or file (ODB-2). The result is always an ODB file (in ODB-2 format)removes removes padding or unwanted data transmission headers from the beginning of BINARY file so that Metview could recognise it as a GRIB or BUFR file.

Info

From Macro/Python the icon can be called as odb_filter().

Tip

A tutorial about using ODB in Metview can be found here.

What is ODB?

ODB is a database developed at ECMWF to store and retrieve large volumes of meteorological observational and feedback data efficiently for use within the IFS.

Currently, ODB comes in two flavours:

  • ODB-1 (the original hierarchical table format capable of running in a parallel environment within IFS)
  • ODB-2 (a new flat format with a modern API used for archiving in MARS

    cleanfile().




    The

    ...

    Clean File Editor

    ...

    Path

    Specifies the path to the input ODBdata.

    ...

    Data

    Specifies the input ODB as an icon. If both an icon (inODB Data) and a filename (in ODB Filename Path) are specified the icon takes precedence.

    ODB Query

    Specifies the ODB/SQL query to run.

    ODB NB Rows

    Specifies the maximum number of rows in the result. If -1 is given here the number of rows is not limited in the output. The default value is -1.

    Fail On Empty Output

    Skip Hirlam Custom Record

    The possible values are yes and no. The default is noWhen it is set to Yes the icon will not fail if the resulting ODB is empty (in Macro the return value is nil while in Python it is None). Otherwise when it is set to No the icon will fail on empty output. The default value is Yes.