I have a table stored in Microsoft SQL Server, and I've defined it in 'catalog.yml' with the necessary credentials set up in 'credential.yml.'
This table gets generated by a SQL Server stored procedure (SP). My goal is to trigger this stored procedure to refresh the table so that we always have the most recent data in our Kedro environment.
Do any of you know if it's possible to connect to the underlying stored procedure responsible for generating this table when I'm pulling the data using the Kedro framework? This will help us to have a more end to end environment for the current project.