How to load a RelationalDatabase stored in the WolframCloud?

I received an answer from Wolfram Research Technical Support. They say that it is not presently possible to access a file-based relational database (like SQLite) by specifying a URL. You have to get the underlying file at the URL, copy it to a local drive, and then treat it like a file. I have requested that the developers see if this limitation can be removed or, at a minimum, the documentation for the RelationalDatabase function make that limitation more clear.


Yes, but there appears to be a work-around:

Upload the SQLite database to the cloud and make a note of its URL.

ClearAll["Global`*"]
fileSchema = RelationalDatabase[
   FindFile["ExampleData/ecommerce-database.sqlite"]];
c = CloudSave[fileSchema];
c[[1]]
(** "https://www.wolframcloud.com/obj/f799c3e1-cdf2-4eff-858c-20fa001afe11"  **)

Now the original SQLite database is accessible as

ClearAll["Global`*"]
cloudSchema = CloudGet[
  "https://www.wolframcloud.com/obj/f799c3e1-cdf2-4eff-858c-20fa001afe11"]
cloudSchema["Tables"]

(** {"employees", "customers", "payments", "orderdetails", "offices", "productlines", "products", "orders"}  **)