Hey!
I'm trying to import data from google sheets into a big query table. I used the URL method and I was able to get the data. But it looks like I'm not able to store the metadata and because of this, I can't use this table with any analytical tool like ThoughtSpot. Is there a workaround for this? How can I get data from Google Sheets onto big query and then use that table elsewhere?
Basically, I think I need to enable metadata caching, how do I do that?
Thank you in advance 😄
LinkedIn
Twitter
