Wanted to get started with Big Query today...7 hours later and wow am I still struggling. Nothing works or behaves like its documented
Input
Got the simba drivers (2.4.6.1015) , but creating the simba DSN couldn't be validated by user sign in, as google seems to have abandoned this method.
Finally got it working by getting the service account key file and using the service auth method instead.
The DCM let me create a big query connection using simba, and which actually let me see my table in the input tool,
but it wouldnt work because it was missing 'a refresh token'??? Couldnt find any support on that.
So then tried creating a normal big query connection in the dcm using reg ODBC option whcih looks like it finally works... but takes ages.
Is this ok, or am I doing this sub standard. I always worry when the documented steps dont work and you try something hackish and it does.
Output
Then went to create a bulk export connection to big query, and none of the options work.
Got my project and bucket details right but after that...
...tried using the sign-in mthods, but they dont work.
so then tried the keyfile approach with file location of service account key I registered in the DSN, and that didnt work either.
Just keeps coming up with missing credential when i try to link.
I've tried using the same odbc in the export, but it takes 5 minutes to write 100 rows, so really wnat to make th bulk process work.
Nothing in the documentation is staright forward or works with this. Tools are deprecated, documentation out of date, google moving the goal posts on what will and wont work.
What gives? Anyone had more success with this.
