'Such … that' - takes a noun or modified noun in a noun phrase. 'That' can be used following the noun phrase but is not required.
such + adjective + noun + (that)
The recording was such a disappointment that I didn't buy any more from that artist.
It was such an expensive car that the didn't buy it.
So + adjective + (that)
The game was so fascinating (that) he played for hours.
Our vacation apartment was so luxurious (that) we didn't want to leave.
'So' can also be used to express a result. In this case 'so' is followed by a full clause:
I had a lot of time so I visited the museum.
She wasn't happy in her current position so she looked for a new job.