Dear @sardarabdullahkhawar ,
Qlik Compose is a data warehouse automation tool that allows you to create, manage, and optimize data warehouses and data marts. It supports various data sources and targets, including SQL databases.
To schedule a SQL script using bash/python script in Qlik Compose, you can follow these steps:
Create a SQL script file that contains the queries you want to run. Save it in a location that is accessible by Qlik Compose.
Create a bash/python script file that executes the SQL script file using the appropriate command or library. For example, you can use the sqlcmd utility for SQL Server or the psycopg module for PostgreSQL.
In Qlik Compose, create a new task or edit an existing one. In the task editor, go to the Pre/Post Actions tab and click on the + button to add a new action.
In the action editor, select the Execute Command option from the drop-down menu. In the Command field, enter the full path to the bash/python script file. Optionally, you can also enter any arguments or parameters for the script in the Arguments field.
Click on OK to save the action and the task. You can then schedule the task to run at a specific time or frequency using the Schedule tab in the task editor.
If our response has been helpful, please consider clicking "Accept as Solution". This will assist other users in easily finding the answer
Regards,
Deepak
