A container is a logical cloud-storage grouping for files or other data objects. In a Snowflake storage integration, it helps restrict the locations where external stages can be created. section 3.1.1 section 5.2
Use a container to prepare and govern cloud-storage data for ingestion:
- Create a container within an Azure storage account and give it a suitable name, such as speedyservicefiles. section 5.2
- Upload selected JSON files to the container before configuring ingestion exercises or loading additional files later. section 5.2
- Specify the container path in STORAGE_ALLOWED_LOCATIONS when creating a Snowflake storage integration. section 3.1.1
use role ACCOUNTADMIN;
create storage integration BISTRO_INTEGRATION
type = external_stage
storage_provider = 'AZURE'
enabled = true
azure_tenant_id = '1234abcd-xxx-56efgh78'
storage_allowed_locations =
('azure://bakeryorders001.blob.core.windows.net/orderfiles/');
The storage integration command shows how an Azure container path becomes an allowed location for external stages. section 3.1.1
