Using the CORS proxy

Some remote datasets don't support open CORS headers, meaning eiter 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}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;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.

Back to Using local AI models