To prevent SQL injection, where you can pass values seperately from the query.

AAries To prevent SQL injection, where you can pass values seperately from the query.

Yeah, then no, it's a REST api, there is no direct binding for querying it.
https://developers.cloudflare.com/analytics/analytics-engine/worker-querying/#worker-script

AriesOP•9/4/23, 8:05 AM

It would be nice if the REST API accepted a body like

{sql: string, values: string}

{sql: string, values: string}

so that wouldn't be an issue.

AriesOP•9/4/23, 8:09 AM

https://files.aries.fyi/2023/09/04/Code_6e32d17f8bd23031.png

AriesOP•9/4/23, 8:10 AM

https://files.aries.fyi/2023/09/04/Code_3490596e08bdb62c.png

riskiidrus•9/5/23, 5:03 AM

Hi, can I know how long my and my customers' analytics data is stored?

I just want to make sure that the data can still be accessed for a long time.

Erisa•9/5/23, 5:34 AM

3 months at the moment https://developers.cloudflare.com/analytics/analytics-engine/get-started/#data-retention

AriesOP•9/6/23, 12:23 AM

why does

(intDiv(toUInt32(timestamp), 120) * 120) * 1000 as x

(intDiv(toUInt32(timestamp), 120) * 120) * 1000 as x

end up as a string?

AriesOP•9/6/23, 12:23 AM

https://files.aries.fyi/2023/09/05/Code_f04483f7b576c9d4.png

AriesOP•9/6/23, 12:41 AM

same with

toUnixTimestamp(timestamp) * 1000

toUnixTimestamp(timestamp) * 1000

AriesOP•9/6/23, 12:42 AM

I assume because it doesn't fit in a 32int but still, pretty weird.

Original message was deleted

AriesOP•9/6/23, 12:47 AM

1693800900000

1693800900000

is a perfectly valid js number.

Unsmart•9/6/23, 12:48 AM

A Uint64 can contain more precise numbers than js numbers can though so all the Uint64 will be string and you can look at meta for the type

AriesOP•9/6/23, 12:57 AM

I suppose that's true.

Mmiki / 46bit We discussed a few times what to do in our SQL API - it's safest to pass through...

AriesOP•9/6/23, 9:09 PM

It looks like it's configurable in Clickhouse? https://github.com/ClickHouse/ClickHouse/issues/114#issuecomment-251463427

GitHub

JSON UInt64 as string · Issue #114 · ClickHouse/ClickHouse

Is there a reason why Int64 and UInt64 are output as string in JSON? :) select toUInt64(1) as n format JSONEachRow; {"n":"1"} :) select toUInt32(1) as n format JSONEachRow; {&qu...

AriesOP•9/11/23, 1:09 AM

Are these functions planned to be supported?
https://clickhouse.com/docs/en/sql-reference/functions/rounding-functions

Rounding Functions | ClickHouse Docs

floor(x[, N])

vikasaditya•10/3/23, 1:56 PM

I am getting error

 Input was invalid: cannot combine the DateTime and String types with the >= operator: "timestamp" >= '2023-03-01 00:00:00'

 Input was invalid: cannot combine the DateTime and String types with the >= operator: "timestamp" >= '2023-03-01 00:00:00'

when trying the billing query given at https://developers.cloudflare.com/analytics/analytics-engine/recipes/usage-based-billing-for-your-saas-product/

Usage-based billing for your SaaS product · Cloudflare Analytics docs

Many Cloudflare customers run software-as-a-service products with multiple customers. A big concern for such companies is understanding the cost of …

vikasaditya•10/3/23, 1:57 PM

while

WHERE timestamp > NOW() - INTERVAL '7' DAY

WHERE timestamp > NOW() - INTERVAL '7' DAY

works

vikasaditya•10/4/23, 5:48 AM

yes, that worked. Also docs don't say that table name is CASE sensitive and show that in lower case where as upper case in bindings. And the query doesn't give any error, actually returns a response with meta filled but data blank with row 0.

zegevlier•10/11/23, 1:43 PM

analytics-engine This is the latest news we have afaik

MarkB•10/12/23, 7:15 AM

hi, I added site and transferred domain to cloudflare successfully, but overview page is empty, please let me know how I can see analytics on overview tab

Jjimh They should appear once you have some traffic on your site. It might take a few ...

MarkB•10/12/23, 11:01 AM

it needs 24 hours to show it? I transferred domain to cloudflare almost 12 hours ago

Bbour Hi. How to delete data? I tried DELETE sql statement, but it is not supported

John Spurlock•10/22/23, 3:16 PM

you can't - it will expire after 93 days

Bbour Any plans to support it?

John Spurlock•10/22/23, 3:30 PM

from what they've said, I don't think so - although I would personally think they would have to before going GA/charging for it etc - also a TTL or auto-thinning would be nice!

analytics-engine

Cezar Sampao•10/24/23, 2:30 PM

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

waitUntil

waitUntil

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

waitUntil

waitUntil

and wrap writeDataPointwriteDataPoint into a

Promise

Promise

.

Does writeDataPointwriteDataPoint 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() 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 Sampao•10/24/23, 2:45 PM

Alright, thank you @chaika.me

Cezar Sampao•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 :/