[BigQuery] There are no column descriptions provided for table

[martinstuder]

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

[JesseLovelace]

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

[JesseLovelace]

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