Hello,
Can we create nested sql catalog items. Meaning, can I use a SQL catalog item in the query as a source to another sql catalog item?
Question
Nested SQL Catalog Items
+4- Rocket Pioneer L1
Hi
When creating a SQL catalog item, to my knowledge you always refer to a physical data source. So to achieve what you describe, the following suggestions may be of help.
- In the data source create a view that matches the logic of the intended nested catalog item (so a view that contains common table expressions or subqueries)
- Define the nested logic in the SQL catalog item itself.
Kind regards,
Albert
Login to the Ataccama Community
No account yet? Create an account
For Ataccama Customers and Partners
or
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.