How do we create sub-directories in Big Query?

Question

I want to copy folders and nested folders (sub-directories) from Google Cloud Storage to Big Query and retain the hierarchy in Big Query. But only appending of data happens in Big Query and no sub-folders get created. How do I do that?

Answer 1

BigQuery doesn't have the concept of sub-folders. You have datasets and tables underneath those datasets. That's all.