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"} **)