how to connect google drive data to bigquery?
Bigquery required URI form is https://drive.google.com/open?id=[file_id]
but in Google drive, share link starts with https://drive.google.com/file/d/######
so, what’s the problem with me…?
1 Like
Get sharable link from specific doc , it should work.
1 Like
Thank you for reply.
→ so do i neet to Manually change to fit this format
share link : https://drive.google.com/file/d/aaaaaaaaaaaaaaaaaaaaaaa/view?usp=sharing
Recommend form : https://drive.google.com/open?id=[file_id]
----> https://drive.google.com/open?id=aaaaaaaaaaaaaaaaaaaaaaa
1 Like
It doesn’t. Please read the issue at hand more carefully.