Panoply on BigQuery
panoply schema is the default for Panoply on BigQuery. This schema is reserved for use by Panoply, however we also provide a
public schema, which serves as a sort of sandbox for users to create custom tables.
What creates tables in the
When Panoply ingests data through a Panoply data source connector, the tables that are created are all in the
What creates tables in schemas other than the
For data warehouses built on BigQuery, Panoply provides a
public schema which allows users with adequate permissions to create tables. The
public schema allows users to explore their data without breaking the integration through the
Functionality related to the
By default, every user in every user group (admins/editors/viewers) has the usage privilege in this schema. Users who have the admin and editor permissions also have the create privilege. Users tab groups apply to the tables and views in this schema. Users can select/insert/delete based on their group.