Skip to main content
Solved

Can we create a SQL catalog item joining two tables from two different data sources?

Star Blazer L3

I want to create a sql catalog item by joining one table from snowflake schema and other from one data file uploaded as catalog item. I don’t see the table available for selection from SCI creation screen. Is it not possible to do?

Best answer by AKislyakov

Hi ​@mp_ataccamauser,
It is possible to join data from two different data sources, however you’ll need a Virtual Catalog Item (Virtual Catalog Items :: Ataccama ONE) for that. 
 

View original

    2 replies

    Ataccamer
    Forum|alt.badge.img+2
    • AKislyakovAtaccamer
    • Ataccamer
    • Answer
    • October 13, 2025

    Hi ​@mp_ataccamauser,
    It is possible to join data from two different data sources, however you’ll need a Virtual Catalog Item (Virtual Catalog Items :: Ataccama ONE) for that. 
     

    Star Blazer L3

    Thanks ​@AKislyakov I also have a requirement of adding a slice on the catalog item which is not available on VCI. Hence I was trying to confirm the functionality here with SCI.

    Community Terms of Use & ConditionsAccessibility statement