async def get(
        self, db: AsyncSession, id: UUID, current_user: User
    ) -> Optional[SourceConnection]:
        """Get a source connection by ID with its ephemeral status.

        Args:
            db: The database session
            id: The ID of the source connection
            current_user: The current user

        Returns:
            The source connection with ephemeral status
        """
        # Call parent class method to get the base source connection
        source_connection = await super().get(db, id=id, current_user=current_user)

        if source_connection:
            # Attach latest sync job info and compute status
            source_connection = (await self._attach_latest_sync_job_info(db, [source_connection]))[
                0
            ]
            # Also attach schedule info
            source_connection = (await self._attach_sync_schedule_info(db, [source_connection]))[0]

        return source_connection
Get a source connection by ID with its ephemeral status.

        Args:
            db: The database session
            id: The ID of the source connection
            current_user: The current user

        Returns:
            The source connection with ephemeral status
        
backend/airweave/crud/crud_source_connection.py