What is the best way to store files metadata in DB? I have a task to create somethig like corporate data catalogue. Starting from the idea of data catalogue seems a little bit vague to me, but the question is  what is a good way to store files metadata like member_id, version etc? Usual row-wise format or JSON? I guess that json is not atomic and might be prone to  corruption, but db rows might be slightly more difficult to migrate to different instances due to the quanity of rows.
What is approx. size of the data? Your no. of rows being a concern here
How often does this data get updated? Consider data access and ACID transactions computation costs in your architecture.
Files metadata will have directories and subdirectories - which are dynamic in nature. Hence schematic representation(RDBMS table) may not be suitable. My initial impression says NoSQL may be a better candidate.
Choose the NoSQL database that suits best - Document DB, Key-Value pair, or Graph database if the files are interlinked (refer to each other) and you need to retrieve that relation
If you need to use RDBMS unless it is too old, many of them offer JSON capabilities inbuilt, please consider the same.