Also something weird is happening, so I wasn't able to setup on my local machine. I tried to do that on GCP and after trying to setup a connection, it failed. But weird enough, I decided to peek at my dataset created on BigQuery. Lo and behold I could see airbyte has written to the warehouse. Quite buggy for my first experience.