Ok, so I made a post about this noise before.

Basically I got a new engine from mazda, and I had this noise. After 300 miles, that motor broke and now I got another new one.

Mazda told me the reason why those two motors broke is because the coils were bad so we replaced them (Typical dealership excuses, but whatever I paid for it anyways)

So today I got the car back again, and its making that same noise again!

I found a video on youtube that resembles the exact noise. From what i gathered after researching it, its a wheel bearing issue? But I only heard it twice today for about 3 seconds each.

But HONESTLY, it does sound like its coming from my front left wheel.

Heres a video, its the same sound, but mine just doesn't sound that long.

Edit: Would a transmission fluid change help? After researching further, im hearing its a transmission issue and it needs to be lubricated. Idk.