- It seems that DBeaver thinks I'm issuing an update statement, but this is just a select statement that returns rows and is valid. Is there a way to avoid 'smart' interpretation of the script by dbeaver and force it to think it's a select statement? (this has probably something to do with the BigQuery 'WITH' statement which confuses DBeaver).
- Follow the steps below to establish a connection to Google BigQuery in DBeaver. In the Database menu, select New Database Connection. In the Connect to database wizard, select ODBC and click Next. Enter the previously configured DSN in the Database/Schema field.
- Shows how to connect DBeaver to Google's BigQuery.NOTE: If a query takes longer than 10 secs it will time out, unlike if it were run directly in BigQuery.
Release notes:
In case it helps someone I wrote a quick blog post illustrating how to connect to BigQuery with Dbeaver using the Simba Drivers. Note: BigQuery's types aren't fully supported with this solution (Structs & Arrays are represented as json strings) but hopefully full support for BigQuery will be addressed later.
- Google BigQuery extension was added
- DBF files driver was added
- SOCKS proxy: support for proxies on localhost
- New version release checker was fixed (NPE)
- SQL editor:
- Selection occurrences highlighting was improved
- Auto-completion: fuzzy completion is now used for all database objects
- Extra formatting configuration was added
- Active query tab switch bug was fixed
- SQL joins auto-completion was fixed (quote column names)
- Results viewer:
- Filtering + ORDER BY was fixed
- All long string editors now support xml/json formatting
- Native date/time formatting support was added
- Date/time columns justify config was added
- Bit string values support was fixed
- Data transfer:
- Max string column length is respected when generating DDL
- TXT format support was fixed (column widths)
- Query/long tasks canceling was improved (configuration)
- Connection default transaction isolation level configuration was fixed
- Driver version selector was fixed (MacOS)
- Apache Hive/Spark/Impala:
- Table data edit support was added
- Table/view source reading was implemented
- Driver version was upgraded (2.6.5)
- Firebird: table columns rename/reorder/edit is now supported
- PostgreSQL:
- Indexes predicate support was added
- Domain data types (timestamp) resolve was fixed
- Oracle 11: NULL timestamp bug was fixed
- Clickhouse: driver config was fixed (catalogs)
- SQL Server: native driver version upgrade (7.0.0)
- Generic driver connection page UI was fixed (long URLs problem)
- Many minor UI fixes
Dbeaver Google Bigquery
Posted in Releases