There do not seem to be SFP DAC cables, only SFP+. At least that is all I found in a quick search. So, my best option would be getting RJ45 1G adapters and a CAT6 cable to connect the switches?
As for setting up the port speed of the switch, that may take some tinkering. My controller is on a cloud key gen 2 connected to the 24 port switch. That only has 1G on it, so connecting it to the 10G switch directly may not work. I might have to play with it if things do not just work when I fire it up the first time.