Data import from Google Drive is not working

roman · March 21, 2023, 2:25pm

Hello,
I try to import a CSV file from my Google Drive to a CrateDB Cloud cluster. I set the sharing options of the file to “anyone with the link can edit”. Still it doesn’t import the data into the cluster. I see a strange error message that I can make no sense off

Any advice would be appreciated!

Matej · March 23, 2023, 2:30pm

Hello there,

Unfortunately, the usual way of sharing documents from Google Drive is not enough as it doesn’t make the documents public, and therefore your cluster cannot access them. See their documentation here for details.

Follow these steps to import from Google Drive:

Open the document you want to import.
Navigate to File → Share → Publish to web
On the modal, choose the “Link” tab and choose either the entire document or the specific sheet you want to import. Make sure to choose a .csv format and click Publish.
You will be shown a public link to the document that can be used to import it in the Cloud Console

Hope this helps!