question

Hi @Swapnilkumar-8722 ,

Thanks for bringing this to our attention. My understanding is that when you upload a file to the event trigger blob location manually, then the event trigger fires as expected and runs your pipeline. But when file is created by a script run in the event trigger blob location, the event trigger didn't fire. Please correct me if I misunderstood your requirement.
If this is the case, then it clears out that the issue is not with Synapse event trigger but the way the files are being written by the script.

Could you please share few additional details about the script run to better understand the functionality of that? What is the script language? If any version, what is the specific version of script language used? Is it regular Azure Blob Storage or ADLS Gen2? If ADLS Gen2, then the event is triggered when clients use the CreateFile and FlushWithClose operations that are available in the Azure Data Lake Storage Gen2 REST API.

Hi @KranthiPakala-MSFT
Thanks for the prompt response. the account is ADLS Gen 2.
We upload the file in a way like this:
def upload_file_to_directory():
try:

         file_system_client = service_client.get_file_system_client(file_system="my-file-system")
    
         directory_client = file_system_client.get_directory_client("my-directory")
            
         file_client = directory_client.create_file("uploaded-file.txt")
         local_file = open("C:\\file-to-upload.txt",'r')
    
         file_contents = local_file.read()
    
         file_client.append_data(data=file_contents, offset=0, length=len(file_contents))
    
         file_client.flush_data(len(file_contents))
    
     except Exception as e:
       print(e)

I tried looking online for FlushWithClose method so i could incorporate it in my code but I couldn't find much on it. it'll be great if you could guide me on the same.