Title: I am getting a Pipe Notifications bind failure
Tags: snowflake-cloud-data-platform
Question: I am trying to create a SNOWPIPE based data ingestion on SNOWFLAKE(on Azure) to ingest data staged on AWS. When I try to create the PIPE, I get an error as below
Pipe Notifications bind failure &quot;Integration cannot be null for Azure&quot;
Can anyone please let me know why I am getting this error. I am doing the below steps
---CREATE AN EXTERNAL STAGE
CREATE OR REPLACE STAGE SNOWPIPE_SATGE URL = 'S3://MY-BUCKET/FILES';
---LIST THE FILES IN THE BUCKET
LIST @SNOWPIPE_SATGE
--- CREATE THE TABLE WHERE THE DATA FROM PIPE WILL BE LOADED
CREATE OR REPLACE SCHOOLS_TABLE(GEOID INTEGER, SCHOOL_ID VARCHAR, SCHOOL_NAME VARCHAR, LAT NUMBER(10,5), LONG NUMBER(10,5);
---CREATE THE PIPE
CREATE OR REPLACE PIPE SNOWPIPE_FOR_SCHOOL_TABLE
AUTO_INGEST=TRUE
AS COPY INTO SCHOOLS_TABLE FROM @SNOWPIPE_SATGE
FILE_FORMAT=(TYPE=CSV FIELD_DELIMITER=',' SKIP_HEADER=1);
This is where(pipe creation) the error is coming
Comment: Looks like a Storage Integration is required when creating an AUTO-INGEST pipe on Azure, even though the underlying stage is in AWS: https://docs.snowflake.com/en/sql-reference/sql/create-pipe.html#optional-parameters Suggest trying to create a Storage Integration and using that in the object definitions (stage and pipe): https://docs.snowflake.com/en/sql-reference/sql/create-stage.html#create-stage



{'source': 'StackExchangeDataset', 'subset': 'stackoverflow.com', 'metadata': {'AnswerCount': 0, 'CommentCount': 1, 'ContentLicense': 'CC BY-SA 4.0', 'CreationDate': '2020:00:09/28/20', 'FavoriteCount': None, 'PostTypeId': 1, 'Tags': '<snowflake-cloud-data-platform>', 'Title': 'I am getting a Pipe Notifications bind failure', 'ViewCount': 648, 'id': 64108853, 'user_AboutMe': '', 'user_AccountId': 19565847.0, 'user_DisplayName': 'Raju', 'user_Reputation': 89.0, 'user_Views': 11.0, 'user_id': 14318019.0}}