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
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