Survey banner
Switching to Dataiku - a new area to help users who are transitioning from other tools and diving into Dataiku! CHECK IT OUT

Table Already exist as a View

Table Already exist as a View

Hi Team,


Could you please help in resolving the attached issue?

Thanks in Advance


0 Kudos
3 Replies
Dataiker Alumni

Hi, @sj0071992, thank you for posting! Can you provide any further details on the thread to assist users in helping you find a solution (insert examples like DSS version etc.) Also, can you let us know if you’ve tried any fixes already?This should lead to a quicker response from the community.

Looking for more resources to help you use Dataiku effectively and upskill your knowledge? Check out these great resources: Dataiku Academy | Documentation | Knowledge Base

A reply answered your question? Mark as ‘Accepted Solution’ to help others like you!
0 Kudos

I am using one SQL Recipe on the snowflake data source and when I am trying to write it back to snowflake again it is giving an error like, the table already exists as a view. So I want to confirm how should I do truncate and load data instead of drop and create table again

0 Kudos


Unfortunately, it's difficult to provide further guidance without the exact use case and/or code. However, it seems like you are trying to write back to an existing table / view rather than a new table, which would go against best practices as you would essentially be introducing a loop. If that is in fact what you are trying to do, you may want to look into using a SQL "script" recipe if you aren't already (but note that you will need to handle all the create / drop / insert statements yourself):

If you continue to face issues, I would advise opening a support ticket with a job diagnosis so that we can help you investigate the matter further.



0 Kudos