Hacker News Reader

Comment by tobilg | Hacker News Reader

I'm sorry, I think I fixed this. Can you check? Thanks for letting me know!

Sorry, it seems to still be happening, running:

    SELECT count(*) FROM 'https://data.quacking.cloud/nyc-taxi-data/yellow_tripdata_2023-01.parquet';

Shows the error:

Cross-Origin Request Blocked: The Same Origin Policy disallows reading the remote resource at https://data.quacking.cloud/nyc-taxi-data/yellow_tripdata_20.... (Reason: CORS header ‘Access-Control-Allow-Origin’ missing). Status code: 200.

I get the same issue in both firefox and brave

edit: actually accessing that file directly gets a Access Denied error for me

Sorry, can you please check again?

https://sql-workbench.com/#queries=v0,SELECT-count(*)-FROM-'...

Thanks!

Yep, looking good now, thanks! Other datasets that don't have CORS headers still don't work ie. https://sql-workbench.com/#config=%7B%22plugin%22%3A%22Datag... but I'm guessing that's inherent limitation of running this without a backend

Yes, unfortunately if the "foreign" sources don't support CORS, you'd have to use a CORS proxy... If you want to self-host, there's one at https://github.com/Zibri/cloudflare-cors-anywhere that can be deployed to CloudFlare Workers (the code is a bit messy though).

GitHub supports CORS for raw data for example, that's why I put it in the sample queries.

Reply on news.ycombinator.com