Stage replication in a cloud data lake

A system, comprising:

• a memory;
• and
• a processing device;
• instructions stored in the memory, the instructions executed by the processing device to:
• define a storage integration with a set of storage locations, wherein the storage integration comprises a base URL for each of the set of storage locations and wherein each storage location identifies a remote deployment where a cloud platform is hosted;
• create a replicated external stage object on a second storage location based on an external stage object from a first storage location bound to the storage integration;
• and
• transition a data loading operation from the first storage location to the second storage location via the replicated external stage object based on a detected outage or interruption of the data loading operation at the first storage location, wherein the storage integration further comprises a relative URL for each of a set of files that is part of the data loading operation so as to synchronize the data loading operation across the first storage location and the second storage location.

A non-transitory computer-readable medium having instructions stored thereon which, when executed by a processing device, cause the processing device to:

• define, by the processing device, a storage integration with a set of storage locations, wherein the storage integration comprises a base URL for each of the set of storage locations and wherein each storage location identifies a remote deployment where a cloud platform is hosted;
• create a replicated external stage object on a second storage location based on an external stage object from a first storage location bound to the storage integration;
• and
• transition a data loading operation from the first storage location to the second storage location via the replicated external stage object based on a detected outage or interruption of the data loading operation at the first storage location, wherein the storage integration further comprises a relative URL for each of a set of files that is part of the data loading operation so as to synchronize the data loading operation across the first storage location and the second storage location.