Add new columns in the datasource table to get the status, retry count, etc

[khansaad]

Describe the feature

When a datasource connection fails, we don't have a provision right now to store it's status in the database. We need to add the following columns in the Datasource table to keep track of the connection status:

Field	Description	Possible Values
status	Connection status	connected, failed
last_check_date	Timestamp of the last connection status check	timestamp
retry_count	Number of connection retry attempts	integer value
latest_result_message	Message describing the latest result if failed	string

Examples or references

Add any examples or references to understand it better

Suggest a solution

Any suggestions on how to solve this

Additional Context

Any additional context about the feature