SQL recipe

• If you run several time a SQL recipe/notebook, the output table is not automatically replaced, so you obtain an error message because you try to create a dataset that already exist. You have to specify manually to delete the dataset if exist.
  
  
  • IF OBJECT_ID('my_table', 'U') IS NOT NULL DROP TABLE [my_table];

• The SQL syntax is different than usual:
  • do NOT use:
    CREATE my_table as
    SELECT ...
    FROM ...
    
    
  • use:
    SELECT ...
    INTO my_table
    FROM ...

• All data sources used as input, and the output of a SQL recipe should be located on the same connection by defaut
  • You can "SYNC" datasets to relocated them before the SQL Recipe.
  • Or you can allow SQL accross connections
    

The best way to get IT support is to use the new Service One Platform.