I am trying to load CSV file from local to snowflake by using QLIK replicate and I have created source point connection and under tables section gave table name and location to fetch file and added table metadata.
When I ran the task it is giving error like unable to locate the path or file doesn't exist in the path error I am getting please let me know what is the process to load file.
I am trying to load CSV file from local to snowflake by using QLIK replicate and I have created source point connection and under tables section gave table name and location to fetch file and added table metadata.
When I ran the task it is giving error like unable to locate the path or file doesn't exist in the path error I am getting please let me know what is the process to load file.
Hello,
You're encountering an error message stating "unable to locate the path" or "file doesn't exist" when trying to load a CSV file from your local machine to Snowflake using Qlik Replicate. Here's how to troubleshoot and fix the issue:
Verify File Path:
Double-check the path: Ensure the path you provided in the "Location" field under the table section in Qlik Replicate is accurate. Pay attention to typos, case sensitivity, and backslashes (use double backslashes for paths within Windows).
Relative vs. Absolute Path: Consider if the path is relative or absolute. An absolute path specifies the complete location from the root directory (e.g., "C:\data\mydata.csv"). A relative path is relative to the working directory where Qlik Replicate is running (e.g., "..\data\mydata.csv").
Qlik Replicate File Access:
Permissions: Make sure the Qlik Replicate service account (user running the service) has read permissions for the directory containing the CSV file. Firewall: If your local machine has a firewall, ensure it's not blocking Qlik Replicate from accessing the file location.
Alternative Methods (if applicable):
Stage to Cloud Storage: Consider uploading the CSV file to a cloud storage service like Amazon S3 or Microsoft Azure Blob Storage. Then, configure Qlik Replicate to access the file from that location. This approach might be more reliable and avoids local file access issues.
By following these steps and considering alternative methods if applicable, you should be able to resolve the file path issue and successfully load your CSV file from local storage to Snowflake using Qlik Replicate.
Not sure if you get any progress? Feel free to open a support ticket and share the task Diag Packages with log files, Our support team will be more than happy to assist you.
Regards,
John.
Help users find answers! Do not forget to mark a solution that worked for you! If already marked, give it a thumbs up!
