Striim 3.10.1 documentation

BigQuery architecture and terminology

Some of BigQuery's terminology may be confusing for users of relational databases that use different terms, or use the same terms to mean different things.

  • Project: contains one or more datasets, similar to the way an Oracle or PostgreSQL schema contains one or more databases.

  • Dataset: contains one or more tables, similar to a MySQL, Oracle, PostgreSQL, or SQL Server database.

  • Schema: defines column names and data types for a table, similar to a CREATE TABLE DDL statement in SQL.

  • Table: equivalent to a table in SQL.