How to create a view of a table containing a timestamp column?

Question

This question is an extension of the previous one I asked for .

I have a table (2014_05_31_transformed.Video) with a schema that looks like this. I included JSON, returned by the BigQuery API, describing its schema in that sense .

I am trying to create a view against this table with an API call that looks like this:

{
    'view': {
        'query': u 'SELECT deleted_mod_time FROM [2014_05_31_transformed.Video]'
    },
    'tableReference': {
        'datasetId': 'latest_transformed',
        'tableId': u 'Video',
        'projectId': 'redacted'
    }
}

But, the BigQuery API returns this error:

HttpError: https://www.googleapis.com/bigquery/v2/projects/124072386181/datasets/latest_transformed/tables?alt=json " " deleted_mod_time.usec ". , , , 128 .

, API BigQuery TIMESTAMP INTEGER, . -, , BigQuery?

Answer 1

:

SELECT utm.campaign as utm_campaign ...

:

select FORMAT_UTC_USEC(timestamp) as timestamp ...

/ , . BQ , , , .