Back to Code Snippets
Jacob Matson
@matson-1
Read Apache Iceberg to Google SheetsSQL
Sometimes you just need to get an Apache Iceberg table into Google Sheets for further analysis. The 'gsheet_id' can be found in the URL of your Google Sheet, and writes to the sheet with gid=0.
Execute this SQL
-- get iceberg extension INSTALL iceberg; LOAD iceberg; -- get gsheets extension INSTALL gsheets FROM community; LOAD gsheets; -- authenticate to google sheets CREATE SECRET (TYPE gsheet); -- copy the iceberg data to your google sheet! COPY (from iceberg_scan('s3://my-bucket/iceberg_table')) TO ‘gsheet_id’ (FORMAT gsheet);Copy code
Jacob Matson
Expand
Share link
Query from Google SheetsSQL
Sometimes you have data over in Google Sheets and you want quickly and easily load it into DuckDB. With read_csv and the Google Sheets 'export to csv', its just one line of code.
Execute this SQL
-- you will need to create a sharelink for your sheet. -- note the tab id (gid) and sheet id (in the url) from read_csv('https://docs.google.com/spreadsheets/d/{sheet_id}/export?format=csv&gid={tab_id}')Copy code
Jacob Matson
Expand
Share link