Data import from Google Drive is not working

CrateDB Cloud
1

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

image
image1356×938 181 KB

Any advice would be appreciated!

2

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:

  1. Open the document you want to import.
  2. Navigate to File → Share → Publish to web
  3. In the modal, choose the “Link” tab
  4. Choose either the entire document or the specific sheet you want to import.
  5. Choose .csv as the format
  6. Click Publish.
  7. Copy the public link to the document and use this as the import URL in the Cloud Console

image
image1920×999 136 KB

image
image1920×1012 92.3 KB

image
image2718×1564 301 KB

Hope this helps!