GEN AI

 

Stay Tuned....

SNOWFLAKE- SCHEDULING TASK

 After a long time, I am writing something. Just thought of writing as I spend so much time in this.

Issue in scheduling task; data updating; not inserting.

Solution: Make sure you are reading data from table not from a view. if its from view, only updations will happen; no insertions.

Check SP and make sure you are executing as a caller.

SSIS Deployments-Package Configurations

 

Click Project->Convert to Project Deployment Model

Then Click on SSIS->Package Configurations

Click Enable package configurations->Add->

Save this configuration with some name.

Can Add connection managers([Source, Destination]). Instead of checking everything, we can set specific fields as well.

config file will look like below. Properties can be changed accordingly.