how to connect google drive data to bigquery?

[jayden_khr]

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

[VishalBulbule]

Get sharable link from specific doc , it should work.

[nope_nuuh]

It doesn't. Please read the issue at hand more carefully.

[jayden_khr]

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