I’m trying to run a named query against Google Big Query (BQ).
Formatting the tablename is causing a problem.
My tables in BQ are organized thusly: Project.dataset.table
If I run a query against just the tablename i.e.( INSERT INTO tablename …) I get a nice error from Google telling me to include the dataset name as well.
When I include it ( INSERT INTO datasetname.tablename …) I get a 404 error Projectname:datasetname.tablename does not exist. notice that semi colon.
When I run a query in BQ’s online console I use the full “path” (INSERT INTO pname.dname.tname …).
On a whim I tried this as the format for my named query.
I did have some success but switched back to a testDB with a different table scheme.
On switching back to the BQ DB I can’t seem to get this query to work.
I’ve re-tried the three combinations above and haven’t been successful.
Anyone out there use BQ with there projects?
It was a capitalization error.
I ended up on (INSERT INTO pname.dname.tname …) working successfully.