Google BigQuery

Google BigQuery object type support.

The following table shows the database specific support in DbVisualizer for Google BigQuery organized per database object type.

  • Object Type - show what object types are listed in the Databases tab
  • Actions - show what actions are available for the object type
  • Viewers - show what viewers are available for the object type
Object TypeActionsViewers
Catalog
  References
Datasets
Create Dataset Datasets
Schema
Export Dataset[1], Drop Dataset References, Tables
Tables
Create Table[1], Import Table Data[1] References, Tables
Table
Alter Table[1], Export Table[1], Import Table Data[1], Copy Table, Create Search Index, Create Snapshot Table, Create Table Clone, Drop Table, Empty Table, Rename Table, Script: Script Table Data, Columns, DDL, Info, Row Count
Columns
  Columns
Column
  Column
Table Clones
  Tables
Table Clone
Export Table Clone[1], Import Table Data[1], Copy Table Clone, Create Snapshot Table, Create Table Clone, Drop Table Clone, Empty Table Clone, Script: Script Table Clone Data, Columns, DDL[1], Info, Row Count
Columns
  Columns
Column
  Column
Snapshot Tables
  Tables
Snapshot Table
Export Snapshot Table[1], Create Snapshot Table, Create Table, Drop Snapshot Table, Script: Script Snapshot Table Data, Columns, DDL, Info, Row Count
Columns
  Columns
Column
  Column
Search Indexes
  Indexes
Index
Drop Search Index DDL, Index
Table Clones
  Tables
Table Clone
Export Table Clone[1], Import Table Data[1], Copy Table Clone, Create Snapshot Table, Create Table Clone, Drop Table Clone, Empty Table Clone, Script: Script Table Clone Data, Columns, DDL[1], Info, Row Count
Columns
  Columns
Column
  Column
Table Clones
  Tables
Table Clone
Export Table Clone[1], Import Table Data[1], Copy Table Clone, Create Snapshot Table, Create Table Clone, Drop Table Clone, Empty Table Clone, Script: Script Table Clone Data, Columns, DDL[1], Info, Row Count
Columns
  Columns
Column
  Column
Snapshot Tables
  Tables
Snapshot Table
Export Snapshot Table[1], Create Snapshot Table, Create Table, Drop Snapshot Table, Script: Script Snapshot Table Data, Columns, DDL, Info, Row Count
Columns
  Columns
Column
  Column
Snapshot Tables
  Tables
Snapshot Table
Export Snapshot Table[1], Create Snapshot Table, Create Table, Drop Snapshot Table, Script: Script Snapshot Table Data, Columns, DDL, Info, Row Count
Columns
  Columns
Column
  Column
External Tables
Create External Table Tables
External Table
Export External Table[1], Drop External Table, Script: Script External Table Data, Columns, DDL, Info, Row Count
Columns
  Columns
Column
  Column
Views
Create View Views
View
Drop View Data, DDL, Info, Row Count
Columns
  Columns
Column
  Column
Materialized Views
Create Materialized View Materialized Views
Materialized View
Drop Materialized View Data, DDL, Info, Row Count
Columns
  Columns
Column
  Column
Search Indexes
  Indexes
Index
Drop Search Index DDL, Index
Procedures
Create Procedure Procedures
Procedure
Drop Procedure Procedure Editor[1], Info, Procedure Columns
Functions
Create Function Functions
Function
Drop Function Function Editor[1], Function Columns, Info
Table Functions
Create Table Function Table Functions
Table Function
Drop Table Function Function Editor[1], Function Columns, Info
[1] DbVisualizer Pro