[BigQuery] There are no column descriptions provided for table

When trying to import a CSV file into BigQuery from GCS using

LoadJobConfiguration.builder(table, path)
      .setAutodetect(true)
      .setIgnoreUnknownValues(false)
      .setMaxBadRecords(0)
      .setFormatOptions(FormatOptions.csv())
      .setCreateDisposition(CreateDisposition.CREATE_IF_NEEDED)
      .setWriteDisposition(WriteDisposition.WRITE_TRUNCATE)
      .build()

I get the error "There are no column descriptions provided for table [table_name]". Loading the same file via the BigQuery web UI using the same options works fine. The CSV file is available at https://storage.googleapis.com/miraisolutions/public/macbeth.csv

Hi,

I'm not able to reproduce this. I ran the following:

String tableName = "macbethtable";
TableId destinationTable = TableId.of("macbeth", tableName);
LoadJobConfiguration configuration =
    LoadJobConfiguration.newBuilder(destinationTable, "https://storage.googleapis.com/miraisolutions/public/macbeth.csv")
            .setAutodetect(true)
            .setIgnoreUnknownValues(false)
            .setMaxBadRecords(0)
            .setFormatOptions(FormatOptions.csv())
            .setCreateDisposition(JobInfo.CreateDisposition.CREATE_IF_NEEDED)
            .setWriteDisposition(JobInfo.WriteDisposition.WRITE_TRUNCATE)
            .build();
Job remoteLoadJob = bigquery.create(JobInfo.of(configuration));
remoteLoadJob = remoteLoadJob.waitFor();

This ran successfully, and I verified in the console that the resulting table is the same as when I upload the CSV using the web UI.

Are you still experiencing this issue? If so, can you show us some more of your code? I suspect maybe some other part of your configuration is causing it

Closing due to being unable to reproduce and inactivity on the issue, feel free to reopen if you're still experiencing this issue

chore(deps): update dependency com.google.cloud:google-cloud-bigtable…

deps: update dependency com.google.errorprone:error_prone_annotations…

chore(main): release 2.51.0 (#3382)

deps: update googleapis/sdk-platform-java action to v2.64.2 (#3425)

Navigation Menu

Repository navigation

[BigQuery] There are no column descriptions provided for table #3425

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

[BigQuery] There are no column descriptions provided for table #3425

Description

Activity

JesseLovelace commented on Dec 13, 2018

JesseLovelace commented on Jan 2, 2019

Metadata

Metadata

Assignees

Labels

Type

Projects

Milestone

Relationships

Development

Issue actions