Snowflake Azure Storage integration not authorized

0
votes

I want to load data via automated loading from an azure storage account to snowflake. I used this guideline to implement the integration: https://docs.snowflake.net/manuals/user-guide/data-load-snowpipe-auto-azure.html#step-2-create-an-integration-in-snowflake I can access the data in the storage after the Stage is created.

In the last step i want to create the pipa via this commad:

create or replace pipe factory_data auto_ingest = true integration = 'azure_int' as copy into SENSOR(json) from (select $1 from @azure_factory_stage) file_format=(type=json);

unfortunately i get this error:

"SQL compilation error: Integration '"azure_int"' does not exist or not authorized."

The integration exists.

Anyone got a hint?

1
azuresnowflake-cloud-data-platformazure-blob-storage

1 Answers

2
votes

Try this with all caps Integration name.

create or replace pipe factory_data 
auto_ingest = true 
integration = 'AZURE_INT' 
as copy into SENSOR(json) from (select $1 from @azure_factory_stage) file_format=(type=json);

From a completely unrelated page:

Note that the integration name is case-sensitive and must be uppercase and enclosed in single quotes.