- Welcome to Panoply Documentation
- Getting Started
- Manage Data
- Data Security
- BI and ETL Tools
- Connectors Documents
- Connectors Introduction
- API Connectors
- Appsflyer
- Asana
- BigCommerce
- Bing Ads
- Delighted
- Facebook Ads
- Facebook Pages
- Facebook Posts
- Flex Connector
- Flex Connector Setup Guide
- Flex Connector Advanced Settings
- Flex Connector Authorization
- Flex Connector Variables
- Flex Connector Pagination
- Flex Connector Refresh Access Token
- Flex Connector Fetch List
- Flex Connector Async API
- Flex Connector Release Notes
- Flex Connector Templates
- Google Ads
- Google Analytics 4
- Google Universal Analytics
- Google Search Console
- Hubspot
- Instagram Business
- Intercom
- Jira
- Klaviyo
- LinkedIn Ads
- Mailchimp
- NetSuite
- Pardot
- Quickbooks
- Salesforce
- Shopify
- Square
- Stripe
- Twilio
- Twitter Ads
- WooCommerce
- Xero
- Zendesk
- Database/File Systems
- Data Recipes
- Release Notes
- September 2024 Release Notes
- August 2024 Release Notes
- July 2024 Release Notes
- June 2024 Release Notes
- May 2024 Release Notes
- April 2024 Release Notes
- March 2024 Release Notes
- February 2024 Release Notes
- January 2024 Release Notes
- December 2023 Release Notes
- November 2023 Release Notes
- October 2023 Release Notes
- September 2023 Release Notes
- August 2023 Release Notes
- July 2023 Release Notes
- June 2023 Release Notes
- May 2023 Release Notes
- April 2023 Release Notes
- March 2023 Release Notes
- February 2023 Release Notes
- January 2023 Release Notes
- December 2022 Release Notes
- November 2022 Release Notes
- October 2022 Release Notes
- September 2022 Release Notes
- August 2022 Release Notes
- July 2022 Release Notes
- June 2022 Release Notes
- February 2022 Release Notes
- April 2022 Release Notes
- January 2022 Release Notes
- December 2021 Release Notes
- November 2021 Release Notes
- October 2021 Release Notes
- September 2021 Release Notes
- July 2021 Release Notes
- June 2021 Release Notes
- May 2021 Release Notes
- April 2021 Release Notes
- March 2021 Release Notes
- January 2021 Release Notes
- November 2020 Release Notes
- October 2020 Release Notes Supplemental
- October 2020 Release Notes
- September 2020 Release Notes
- August 2020 Release Notes
- July 2020 Release Notes
- June 2020 Release Notes
- Platform FAQs
View Dependencies
Panoply on Redshift
On Redshift, queries can be saved as tables and then those views can be used like tables.
The saved views rely on tables that you’ve ingested into Panoply (using Panoply data sources or external ingestion tools) and they can also rely on other views that have been created. Saving a view that relies on another view will basically create a chain of views (chain of dependencies). Usually, in these cases, the user will query the last view in that chain (or tree if it’s a more complex configuration) but it’s definitely not a must and you can query each view separately as well.
When working with the classic ETL processes, you create the complete data flow from extraction to how the data will be saved. This entire process is usually saved in the same ingestion tool and is relatively easy to view, examine, and understand. But when you’re working with views, you can easily lose track of the view's flow and what is in charge of what and which view depends on which table/view.
To overcome this issue, the following query can be used to identify the dependencies per view and find the actual dependency tree for your specific setup, just change the view_name_or_table_name
and schema_name
to match the specific view you’re looking for:
SELECT DISTINCT c_p.oid AS tbloid,
n_p.nspname AS dependee_schema,
c_p.relname AS dependee,
n_c.nspname AS dependent_schema,
c_c.relname AS dependent,
c_c.oid AS viewoid
FROM pg_class c_p
JOIN pg_depend d_p ON c_p.relfilenode = d_p.refobjid
JOIN pg_depend d_c ON d_p.objid = d_c.objid
JOIN pg_class c_c ON d_c.refobjid = c_c.relfilenode
LEFT JOIN pg_namespace n_p ON c_p.relnamespace = n_p.oid
LEFT JOIN pg_namespace n_c ON c_c.relnamespace = n_c.oid
WHERE d_p.deptype = 'i'
AND dependee_schema + dependee <> dependent_schema + dependent
AND dependee = 'view_name_or_table_name'
AND dependee_schema = 'schema_name';
Table of contents
Related articles