- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-09-2024 06:17 AM - edited 09-09-2024 06:19 AM
Hi @prad18 ,
I'm glad the previous response was helpful! Let's address your remaining questions:
Cost Differences Between Single vs. Multiple Azure Storage Accounts: The cost difference between using a single Azure storage account for both Unity Catalog and your data versus multiple storage accounts is generally negligible. The primary cost driver is the amount of data stored. For example, whether you store 100 GB in a single storage account or split it across multiple storage accounts, you will still be paying for 100 GB of storage.
Specifying Storage When Creating a Catalog: When creating a catalog, you do not need to specify storage if you want to use the default metastore storage. However, if you prefer to store data in a different location from where your metastore is, you need to specify the MANAGED LOCATION. For example:
CREATE CATALOG sample_catalog
MANAGED LOCATION '<azure storage location>';
This approach allows you to organize your data storage more effectively, keeping metadata in one storage account (for the metastore) and your actual data in another.