Skip to content

How should numeric transforms be handed from tap to target?

Following from https://meltano.slack.com/archives/C01PKLU5D1R/p1645780848809499

There's a question on the proper way for taps and target to communicate types for decimal/currency values:

As a first go, here's a set of principles to kick of the convesertation:

First-order principles:

  1. Numbers should be number type, not string.
  2. Target needs to have at least a large enough field for the data to land successfully.
  3. Target should always be free to create a field larger than is needed.

Bonus / second-order principles:

  1. Should we have standard hints for precision and size requirements?
    • For example, some places we can put hints are: format, min, max, and multipleOf
    1. How does the tap communicate these?
    2. For targets which are listening to those type hints, how should they interpret those type hints?
Edited by AJ Steers