Some files and folders on your Mac are hidden by default. Your Library folder within your user folder, for example, is hidden, as is the actual iCloud Drive data folder. I discovered this when trying to find a way to create a redundant backup of my iCloud data.
There are a few ways to make your hidden files visible. I’ve found the quickest method is to use a keyboard shortcut. If you type and release Command-Shift-. (that’s a dot, or period, at the end), your hidden files will become visible in the Finder. Type it again and they’ll disappear. That’s all there is to it.