Scribd
Upload
4 views1 page

Create Integration

The document outlines the creation of a storage integration object named 'azure_integration' for accessing Azure storage in a database called DEMO_DB. It specifies the integration type, provider, and necessary access information including the Azure tenant ID and allowed storage locations. Additionally, it includes a command to describe the integration object for access verification.

Uploaded by

shubhmt9110
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views1 page

Create Integration

The document outlines the creation of a storage integration object named 'azure_integration' for accessing Azure storage in a database called DEMO_DB. It specifies the integration type, provider, and necessary access information including the Azure tenant ID and allowed storage locations. Additionally, it includes a command to describe the integration object for access verification.

Uploaded by

shubhmt9110
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

USE DATABASE DEMO_DB;

-- create integration object that contains the access information


CREATE STORAGE INTEGRATION azure_integration
TYPE = EXTERNAL_STAGE
STORAGE_PROVIDER = AZURE
ENABLED = TRUE
AZURE_TENANT_ID = '9ecede0b-0e07-4da4-8047-e0672d6e403e'
STORAGE_ALLOWED_LOCATIONS =
('azure://[Link]/snowflakecsv',
'azure://[Link]/snowflakejson');

-- Describe integration object to provide access


DESC STORAGE integration azure_integration;

You might also like