Current external documentation details are very low level and abstractly describe the file handling mechanics of external storage. While the various implications for differing usecases can be extrapolated from this, it take a bit of heavy thinking for the uninitiated. It would be good to also outline the use cases and break down what happens when. For example:
Use N: S3 External
Paragraph r.e. overall usecases when this makes sense
Paragraph r.e. configuration
Paragraph showing insert & impact to location/stage storage
Paragraph showing fetch & impact to location/stage storage
Paragraph showing delete & impact to location/stage storage
Use N: Filesystem External with Direct Access
... (same substructure)
Use N: Filesytem External with Local 'stage' caching
Current external documentation details are very low level and abstractly describe the file handling mechanics of external storage. While the various implications for differing usecases can be extrapolated from this, it take a bit of heavy thinking for the uninitiated. It would be good to also outline the use cases and break down what happens when. For example: