Loading Data from Azure Blob to Snowflake Table |Container Creation | External Stage Integration

Welcome to our comprehensive guide on loading data from Azure Blob Storage into Snowflake tables! In this video, we cover everything you need to know, from setting up a container in Azure to integrating with Snowflake and loading data efficiently.

We'll start by showing you how to create a container in Azure Blob Storage, where your data will reside. Then, we'll dive into integrating Azure Blob Storage with Snowflake, setting up an external stage in Snowflake for seamless data transfer.

You'll learn step-by-step instructions on how to upload data into Azure Blob Storage, configure Snowflake integration objects, and create external stages. Finally, we'll demonstrate the process of loading data from Azure Blob Storage into a Snowflake table using these integrated components.

Whether you're new to data loading or looking to optimize your data pipeline, this video will provide practical insights and techniques to streamline your data workflows.

Don't forget to like, subscribe, and hit the notification bell for more tutorials and guides on data management and cloud integration!

Feel free to customize this description to match your video's style and tone. You can also include specific details or call-to-action elements based on your audience's preferences.

------------------------------

/*
--Loading Data from Azure Blob storage

--Creating storage account in Azure portal

--Creating container in azure storage account

--Uploading file into Azure storage account blob container

--creating Snowflake integration object

--adding Access control to give access for Snowflake stage

--Creating external Azure stage object in snowflake

--Loading data into table from Azure Blob storage to snowflake table

*/












USE DATABASE my_db;

--- create integration object

CREATE or REPLACE STORAGE INTEGRATION azure_integration
TYPE = EXTERNAL_STAGE
STORAGE_PROVIDER = AZURE
ENABLED = TRUE
AZURE_TENANT_ID = '831eda86-1ffe-4a3d-ad94-7b92817e3921' -- Microsoft Entra ID'
STORAGE_ALLOWED_LOCATIONS = ('azure://sasnowflake5645.blob.core.windows.net/snowflakecsv');


-- Describe integration object

DESC STORAGE integration azure_integration;




-- create file format
create or replace file format my_db.public.fileformat_azure
TYPE = CSV
FIELD_DELIMITER = ','
SKIP_HEADER = 1;

-- create stage object
create or replace stage my_db.public.stage_azure
STORAGE_INTEGRATION = azure_integration
URl='azure://sasnowflake5645.blob.core.windows.net/snowflakecsv'
FILE_FORMAT = fileformat_azure;


-- list files
LIST @my_db.public.stage_azure;

select
$1,
$2,
$3,
$4,
$5,
$6, metadata$filename

from @my_db.public.stage_azure;

CREATE OR REPLACE TABLE my_db.PUBLIC.ORDERS (
ORDER_ID VARCHAR(30),
AMOUNT VARCHAR(30),
PROFIT INT,
QUANTITY INT,
CATEGORY VARCHAR(30),
SUBCATEGORY VARCHAR(30));


COPY INTO ORDERS
FROM @my_db.public.stage_azure;

SELECT * FROM ORDERS;




#AzureBlobStorage #Snowflake #DataIntegration #DataPipeline #DataMigration #dataworldsolution