What does the at-least-once delivery principle mean while collecting hits?

OWOX BI uses the at-least-once delivery concept to ensure collecting all hits you send to our endpoint. It means in some cases it may be duplicates of hits with the same 'hitId'. Typically, the share of this hits less than 0.1%.

Best effort de-duplication

Thus, if you operate directly to hit level data in tables like 'streaming_YYYYMMDD', we recommend adding a specific condition to your SQL query to exclude duplicates.

Example:

WITH uniqueHistTable AS(
    SELECT
        *
    EXCEPT(rowNumber)
    FROM
        (
            SELECT
                *,
                ROW_NUMBER() OVER (PARTITION BY hitId) rowNumber
            FROM
                HITS_TABLE
        )
    WHERE
        rowNumber = 1
)

SELECT * FROM uniqueHistTable

Note:While running session collecting OWOX BI automatically removes all duplicates of hits.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.