So ... cable is wrong cable .. you got the SMA without the pin! :/
Who ever decided to have RP-SMA and SMA is an asshole.
you want SMA male to N Male - and LMR (which you chose correctly) ...
https://www.amazon.com/dp/B07NZ1416W/ $43
https://www.amazon.com/gp/product/B00QZEQ5EA/ $44
https://www.amazon.com/XRDS-RF-SMA-Male-Connector-Extension/dp/B088STSJ5K/ $39 plus a coupon
This is everything I bought that helped out a ton.
https://www.amazon.com/dp/B01NBSLNJ6?ref=ppx_pop_mob_ap_share
https://www.amazon.com/dp/B00K5GW67O?ref=ppx_pop_mob_ap_share
Proxicast 25 ft Low-Loss Coax... https://www.amazon.com/dp/B00QZEQ5EA?ref=ppx_pop_mob_ap_share
HiLetgo 5pcs IPX IPEX U.FL to SMA... https://www.amazon.com/dp/B01HXU1PKS?ref=ppx_pop_mob_ap_share
This should be everything you need.
Just purchase LMR/KMR coax. People get bad advice from the dummies that use very terrible coax instead of spending $40 USD on LMR / KMR . Dummies don't understand RF at Ghz frequencies requires appropriate coax.
Thus ADS-B wizards tell others to run a long USB cables; those all have voltage drops which cause the SDR to be unstable. So you end up having to buy a power booster. Sure there are cases where it works. You're going to spend more money and effort building a Rube Goldberg ADS-B feeder, or you can just buy the correct coax.
LMR/KMR 195 for up to 0-25 feet.
LMR/KMR 240 for up to 50 feet.
LMR/KMR 400 for 25-100 feet.
https://www.amazon.com/Low-Loss-Extension-Connector-GEMEK-Arrester/dp/B07NZ1416W/
https://www.amazon.com/dp/B00QZEQ5EA/
DO NOT BUY SMA RP! SMA RP does not have a SMA center pin.
If you put run PoE with an outside or attic box, then you have to crawl up there to fix it if you break it. Why make more work for yourself. Run good coax and forget about it.