Hey guys, I was going through some past conversation here regarding `writeDataPoint` and `waitUntil`

Hey guys, I was going through some past conversation here regarding

writeDataPoint

writeDataPoint

writeDataPoint

writeDataPoint and

waitUntil

waitUntil

. It's not clear to me if I need to call

waitUntil

waitUntil

and wrap

writeDataPoint

writeDataPoint

writeDataPoint

writeDataPoint into a

Promise

Promise

Promise

Promise.

Does

writeDataPoint

writeDataPoint

writeDataPoint

writeDataPoint affect or add latency to my worker response? My team is afraid we need to wrap it and use

waitUntil

waitUntil

but I'd need to do some hacks with

performance.now()

performance.now()

performance.now()

performance.now() because it would return a different value if it's executed inside

waitUntil

waitUntil

.

Could somebody clarify? Thanks!

CCezar Sampao Hey guys, I was going through some past conversation here regarding `writeDataPo...

Chaika•10/24/23, 2:42 PM

You don't need to await it or worry about it, it returns instantly and pushes data after the event, shouldn't effect latency at all

Chaika•10/24/23, 2:42 PM

Calls to writeDataPoint will return immediately while processing of the data point continues in the background.

https://developers.cloudflare.com/analytics/analytics-engine/get-started/

Cezar SampaoOP•10/24/23, 2:45 PM

Alright, thank you @chaika.me

Cezar SampaoOP•10/24/23, 2:49 PM

plans to integrate WAE with Datadog?

Elliot Hesp•10/26/23, 10:45 AM

Hey,

Is it expected we'll get longer data retention times in the future, longer than 3 months?

AAlCalzone Can I pass a timestamp to `writeDataPoint`? I'm considering migrating analytics ...

John Spurlock•10/26/23, 3:00 PM

while not an exact replacement, you can write your timestamp as a double, then use toDateTimetoDateTime and friends to query - works almost just as well

https://developers.cloudflare.com/analytics/analytics-engine/sql-reference/#todatetime

Unsmart•10/28/23, 4:06 AM

For anyone who uses grafana do you know if it is possible to set the "Graph styles -> Disconnect values -> Threshold" option to be exactly the query interval?

Causes a lot of annoyance when it is not set exactly to the interval :/

Advany•11/2/23, 11:51 AM

Seems that analytics is not working (getting errors when fetching data that authentication failed)

zegevlier•11/2/23, 11:56 AM

Status page: https://www.cloudflarestatus.com/incidents/hm7491k53ppg

Cloudflare Dashboard and Cloudflare API service issues

thomas_sc•11/3/23, 7:09 AM

Worker Analytics ist down for almost 24 hours now.

Tthomas_sc Worker Analytics ist down for almost 24 hours now.

Niek•11/3/23, 11:25 AM

it's really a big problem for us, i hope the ingested data from workers in the last 24h is not lost...

Niek•11/4/23, 6:10 AM

Looks sort of back now

Niek•11/4/23, 7:56 AM

And no data missing (for us at least), great

thanks @46bit

Advany•11/6/23, 9:52 AM

also no data missing here!

juri•11/7/23, 3:31 PM

Can someone tell me how to filter out

null

null

-values in queries?

juri•11/7/23, 3:31 PM

This issue is preventing me from calculating an AVGAVG as well as the function can not calculate a proper AVGAVG when the source data contains

null

null

values

juri•11/7/23, 4:00 PM

And also, as I'm reading up messages about the incident last week, we also lost about 5 hours worth of data. This is pretty concerning, especially as this product is recommended for usage-based billing. :/

Jjimh I'm a little bit confused by this. Analytics Engine doesn't support null values ...

juri•11/7/23, 4:14 PM

Yes, that is the exact query — happy to provide you with more details as well.

juri•11/7/23, 4:15 PM

Perhaps a "broken" value is stored inside the column and the database/gateway returns

null

null

instead?

juri•11/7/23, 4:21 PM

Thanks, I appreciate it!

juri•11/7/23, 4:36 PM

Oh, I will give this a try right away — let me verify.

Jjimh My theory is that these are NaN values. Which are of course perfectly valid, non...

juri•11/7/23, 4:37 PM

Yes, this totally works!

juri•11/7/23, 4:38 PM

I really appreciate it. I was really confused since IS NOT NULLIS NOT NULL still returned these values as

null

null

juri•11/7/23, 4:38 PM

Is there a way I can manually prune these incorrect values somehow?

juri•11/22/23, 4:58 PM

Does WAE support sub-queries?

juri•11/22/23, 4:59 PM

I can't get them to work properly, I keep getting the following response:

Sorry, we were unable to evaluate your query

Sorry, we were unable to evaluate your query

juri•11/22/23, 5:03 PM

Essentially, I am storing multiple metrics (individual rows) per each request (identified via a request id column). I am currently unable to generate averages for the individual rows by grouping/making the request ids distinct.

juri•11/22/23, 5:08 PM

Update: Got it working with the following query:

SELECT 
    AVG(avg_invocations) AS invocations
FROM
(
    SELECT
        blob6,
        AVG(double9) AS avg_invocations
    FROM 
        $table
    WHERE
        $timeFilter
        AND double9 <> 0
    GROUP BY 
        blob6
)

SELECT 
    AVG(avg_invocations) AS invocations
FROM
(
    SELECT
        blob6,
        AVG(double9) AS avg_invocations
    FROM 
        $table
    WHERE
        $timeFilter
        AND double9 <> 0
    GROUP BY 
        blob6
)

Though, I have to say, it's really hard to build proper queries when often times you get returned the error message highlighted above.

TTonyB Is there a way to toggle analytics engine via the API? Or at least get a status?

Rob M.•11/24/23, 11:49 PM

What do you mean by "toggle"?

Vikash•11/25/23, 9:05 AM

Any open source project/blog for worker analytics.

I just want to store and fetch {date, url, ip, location } and SQL query with group by

TTonyB As in "enable" or "disable" the feature

Rob M.•11/27/23, 12:01 AM

What is your use case? Usually, you work with WAE in your worker. So it's up to you, how to implement "enable"/"disable" logic.

TTonyB I have a WordPress plugin that allows site owners to use Cloudflare Images on th...

Rob M.•11/27/23, 11:11 PM

If every processed image is important to you, WAE may not be the best option due to data sampling.

Rob M.•11/27/23, 11:13 PM

On the other hand, "Usage-based billing for your Software-as-a-Service product" topic is listed as a common use case.

Rob M.•11/27/23, 11:24 PM

Is it really impossible to track everything inside your own worker? Or you just want to cut down the costs?

Hey guys, I was going through some past conversation here regarding `writeDataPoint` and `waitUntil`

Similar Threads

Similar Threads

Similar Threads