An Azure storage account is a top-level resource that provides access to Azure Storage services and their data containers. In a Snowflake pipeline, it holds files in a container that an external stage can access through a storage integration. section 3.1.1 section 5.2
Prepare a storage account for cloud-file ingestion by:
- Creating or selecting an Azure resource group. section 5.2
- Creating a uniquely named Storage account within that resource group. section 5.2
- Creating a container, such as speedyservicefiles or orderfiles. section 3.1.1 section 5.2
- Uploading a small set of sample JSON files before adding more files for continuous ingestion. section 5.2
Restaurant order files
A restaurant uses the Azure storage account bakeryorders001 and the orderfiles container. Snowflake restricts the integration to the container path azure://bakeryorders001.blob.core.windows.net/orderfiles/. 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/');
Use the Snowflake command to register the Azure storage account and restrict access to a specific container location. section 3.1.1
describe storage integration BISTRO_INTEGRATION;
Inspect the resulting storage integration to verify its Azure provider, tenant, and allowed storage location. section 3.1.1
