Hi,

I virtualized some data with the help of a snowflake connection, now I want to prepare the data without posting the data to the project. So can we prepare the virtualized data without posting it into any project or catalog.

Hi @Akshay Nirmal
​You can work with visualized snowflake data without copying data to project but you still need to register "connected" data asset or at least "connection" to snowflake in Project. This only captures metadata about where the data is, without physically moving data.

In CP4D 4.5, this is done via https://www.ibm.com/docs/en/cloud-paks/cp-data/4.5.x?topic=project-adding-data-from-connection

Once you "register" your virtual data, you can use data refinery tool to refine it.

When describing your Refinary job, you can indicate target table that is also remote https://www.ibm.com/docs/en/cloud-paks/cp-data/4.5.x?topic=data-copying-from-source-target