ETL PostgreSQL data to Google BigQuery

Represents the core data storage units in PostgreSQL, containing structured data organized in rows and columns. Each table defines a schema for storing records of a specific entity.

Virtual tables that present data from one or more tables through a predefined SQL query, enabling simplified data access and abstraction without duplicating data.

Logical containers that group related database objects such as tables, views, and functions, supporting organization, access control, and namespace management within a database.

Specialized data structures that improve query performance by enabling faster data retrieval on specified columns within tables.

Reusable routines written in SQL or procedural languages that perform operations or calculations, often used to encapsulate business logic or data transformations.

Database objects that generate unique numeric values, typically used for auto-incrementing primary keys in tables.

Procedures that are automatically executed in response to specific events on a table or view, such as insertions, updates, or deletions, enabling automation and data integrity enforcement.