I have installed dremio hopefully that it will help me initially pull data from multiple google spreadsheets in order to compile the dataset for reporting.
Not sure if this the best use of dremio, but is there any relevant info/doc/example showing such a case ?
Many thanks,
George
Google Sheets is not directly supported as a source today. However, there are plenty of workarounds. You could always extract/download the sheet and either upload that directly into our UI or store it in some type of data storage. This could also be potentially automated using a combination of Google Sheets API + Dremio API
This may be helpful: https://docs.dremio.com/data-sources/file-upload.html
Is there any such feature or plugin now? To use GSheets as source of Dremio?
@rakinrkz No, but you can download the sheet as CSV and query via Dremio, still not optimal. IF you can add an extra step of moving the CSV file to Iceberg and then query via Dremio, that would be most performant,
To convert VSV to Iceberg use Dremio’s inbuilt command COPY INTO, doc below