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 "Integration cannot be null for Azure"
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
Set the AUTO_INGEST to False and it will work.