Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>There are a few questions here:</p> <ul> <li><p><strong>Why did my load job fail?</strong> Just to check, was that the entire request you sent? If so, it looks like there's no data to be loaded, i.e. <code>sourceUris</code> is empty. If so, that's the problem, and we're apparently returning the world's worst error message.</p></li> <li><p><strong>Why the numeric project ID?</strong> BigQuery uses the project name and the associated numeric ID interchangeably, so all you're seeing is that we tend to convert project names to IDs on the way in. Just to confirm, if you visit the <a href="https://code.google.com/apis/console/" rel="nofollow">Google APIs Console</a> and look up your project, do you see that same numeric ID in the url?</p></li> <li><p><strong>Why does the project ID get specified in multiple places?</strong> First, it seems that you specified the project ID as a top-level attribute in the job; that shouldn't be necessary. (I suspect that it simply overrides whatever project ID you specify in the job reference itself.) That leaves two locations -- once as part of the job reference and the other as part of the table reference. These actually signify two different things -- the one in the job specifies what project you're inserting a job into, i.e. who's paying for the job, and the one in the table specifies what project the resulting table lives in, i.e. who owns the resulting data. In general, these will be the same, but the API allows them to be distinct. (This could be useful if, for example, you built a service that needed to insert data into tables ultimately owned by customers.)</p></li> </ul>
    singulars
    1. This table or related slice is empty.
    1. POBigQuery: Dataset "Not Found" on table load with REST API
      singulars
      1. PTQuestion
    1. PTAnswer
    1. This table or related slice is empty.
    1. USCraig Citro
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. COI am appending a csv file to the MIME data. I was able to upload the same CSV file manually via the browser tool, and in the returned result, the dataset is listed as "firespotter.com:firespotter:telephony_logs". This appears to be the difference between the two.
      singulars
      1. PO
      1. USCorey Burke
    2. COAlos, yes, when I visit the Google APIs Console, I do see the 385479794093 (the project number) in the URL. And if I list the datasets for either the project number or the string ID, I see the dataset for firespotter.com:firespotter:telephony_logs.
      singulars
      1. PO
      1. USCorey Burke
    3. COI think this is a bug in BigQuery. To confirm, I created another project, but did not name it. I then entered the project number ('725870756519') as the projectId in the same script. And it worked.
      singulars
      1. PO
      1. USCorey Burke
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload