'Unexpected error Tracking number: c904462681469709

been trying to create a table in sandbox and i'm getting an "Unexpected error Tracking number: c904462681469709". sometimes the table gets created, sometimes it doesn't. any wizards that can help me with this? cheers,

sqlgoogle-bigquerypythonpandasdataframejupyter


Solution 1:[1]

I ran into the same issue today, I do not know what causes the error, but I found that BigQuery has loaded my table. The steps I used are as follows:

  1. Click the three dot drop down to create the table.
  2. Fill out the source, destination, schema for the table.
  3. After clicking 'create table' receive the error and close out the error window.
  4. Close out of the create table window.
  5. Refresh your BigQuery page.
  6. Check the dataset you created the table under and it should be there.

I hope this method works for you as it did for me!

Solution 2:[2]

That happened to me too. So strange but yes I did the same thing Devin did. Took me forever trying to figure it out but it is what it is. Just refresh and keep going.

Solution 3:[3]

In os.listdir, "." represents current directory.

You can specify instead os.path.join('.', 'subdir', 'subsubdir') to list files in subdir/subsubdir/.

Complete code.

import pandas as pd
import os

filepaths = [f for f in os.listdir(os.path.join('.', 'subdir', 'subsubdir')) if f.endswith('.csv')]
df = pd.concat(map(pd.read_csv, filepaths)

Solution 4:[4]

Just replace os.listdir(".") with os.listdir("csvFilesPath") as indicated in the previous answer it works. I tried it

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Devin
Solution 2 Leon Hei
Solution 3 Register Sole
Solution 4 Prajwal Kulkarni

Related Questions