I assume by "microsoft sql" you mean Microsoft's Transact SQL (or T-SQL) language, not Microsoft SQL Server?Databricks SQL and T-SQL are both based on ANSI SQL with some platform-specific language extensions. This means most of the basics of SQL are...
> Unity Catalog is not just catalogs, schemas, and tables, right?It kind of is, but also not. Unity Catalog is mainly metadata (table structures, column types, etc.) and user permissions. Unity Catalog is not data, unless you've done something unus...
The external locations Walter mentioned are configured as the "storage location" at either the catalog or schema level. We set these for each schema in our lakehouse, it makes for a very clean physical implementation.
@nicobuko I see what you mean, I just registered for CE using a different email address and I was not prompted for a password, it's OTP all the way. That's a change in the last few months, I apologize I didn't realize how much that signup changed.@A...
@nicobuko You actually do have a password, you created the password when you signed up for CE. The newer browser login experience uses your userid and an e-mailed OTP when you are using a recognized machine, but your password still exists. Try logg...