I need to schedule a query to run automatically daily. The Query is:
set SortOrder = (InventoryLevel * -1)
and it's to a BigCommerce connection.
How would I do this?
To perform the update operation against the target field, you can use Skyvia Control Flow Simply add the Action component to the flow, select your BigCommerce connection, select the Execute Command action and paste your query to the command field. Then you can set the schedule and the Control Flow will run according to it. More details on Control Flow is available here https://docs.skyvia.com/data-integration/control-flow/how-to-design-control-flow.html
Please revert to us if any further assistanse is needed.