CODEWITHSUNDEEP
jdbcgoogle-bigqueryddl
Ido Shichor
Ido Shichor

Reputation: 43

JDBC connection to BigQuery with DDL statements

I'm looking for a JDBC driver for Google Bigquery that also has DDL capabilities such as drop/create table.

I see that the Simba and Star-schema drivers don't have such a capability. Is anyone aware of drivers that do?

Upvotes: 2

Views: 735

Answers (1)

Daniel Kasak
Daniel Kasak

Reputation: 46

BigQuery doesn't support DDL at all. The options that are available to you will depend on what's generating your DDL. If it's totally under your control, you can implement these operations using the REST API directly, or using an existing client that wraps the API. You could in theory write your own JDBC driver that parses all queries, intercepts DDL, and implements it using the REST API ... but that would be painful and error-prone. It's not clear whether Google plan on supporting DDL at some point.

Upvotes: 2

Related Questions