Using the CORS proxy
How to use the CORS proxy to access remote datasets that don't support open CORS headers
Some remote datasets don't support open CORS headers, meaning either having no CORS headers at all, or having them but not allowing other origins to access them.
Therefore, SQL Workbench provides a CORS proxy service that you can use to access these datasets.
The CORS proxy service is available at https://cors.sqlqry.run.
To use the CORS proxy, you can simply prepend the target URL with the CORS proxy URL and the respective parameter:
https://cors.sqlqry.run/?url={TARGET_URL}
An example query would be the following:
SELECT
*
FROM
read_csv_auto(
'https://cors.sqlqry.run/?url=https://www.italiadomani.gov.it/content/dam/sogei-ng/opendata/PNRR_Pagamenti_di_Progetto.csv'
)
LIMIT 5;
If you'd try to access the dataset without the CORS proxy, you'd get a CORS error in your browser's console.