Repository navigation
BigQuery: Can't create a table with a expirationtime #2274
Description
Hello,
I am trying to create a table using the bigquery API in the following way:
final Long expirationTime = getExpirationTimeMillis(dateString);
final TableInfo tableInfo = TableInfo.newBuilder(TableId.of(project, dataset, tableId), NEW_TABLE_DEF)
.setExpirationTime(expirationTime)
.build();
LOG.info(String.format("Creating table: %s.%s.%s", project, dataset, tableId));
return bigQuery.create(tableInfo);
This gives me the following message:
com.google.cloud.bigquery.BigQueryException: Not found: Table entity-dev:joel_daily.user_daily_20170718
Doing the same without .setExpirationTime(expirationTime) works fine. I don't see why I should get an issue Not found when setting the ExpirationTime.
Can you please help me with this issue?
Activity
tcoffee-google commentedon Jul 27, 2017
@joelostlund can you check to make sure the expiration time you're passing is not in the past?
joelostlund commentedon Jul 28, 2017
@tcoffee-google yeah it worked, thanks. Must say that this is a little bit confusing this you specify the days from now when you create a dataset and now+the days from now when creating a table.
tcoffee-google commentedon Jul 28, 2017
@joelostlund I agree that in the context of an "expiration time" that is a bit confusing. I'll pass this along to the API team.
deps: update dependency com.google.cloud:google-cloud-bigquery to v2.…
chore(main): release 2.44.1 (#2286)
feat: Adding CDC sample (#2263)
chore(deps): update dependency com.google.cloud:google-cloud-spanner-…
chore: make library generation required (#2274)
chore: make library generation required (#2274)
chore(main): release 3.34.0 (#2274)
fix: adapt `toString` tests to introduction of java.time in gax (goog…