CosmosDBTrigger on Azure Function without Lease Collection










1















I have an Azure Function which is triggered each time that one on more items in my CosmosDb Collection is updated.



The code works correctly:



[StorageAccount("AzureWebJobsStorage")]
public static class ChangeFeedFunction
{
[FunctionName("ChangeFeedFunction")]
public static void ChangeFeedFunction(
[CosmosDBTrigger(
databaseName: "MyDataBase",
collectionName: "MyCollection",
ConnectionStringSetting = "CosmosDbConnectionString",
LeaseCollectionName = "MyCollection_Leases",
CreateLeaseCollectionIfNotExists = true
)] IReadOnlyList<Document> documents,
[Queue("collection-changes")] ICollector<Message> analystQueue,
ILogger logger
)

//Operations;



But in the case, it means I have 2 CosmosDb Collections (MyCollection and MyCollection_Leases) which is minimum 40$ per month. I would like to reduce the cost. Is there a way to observe the modification on my CosmosDb Collection without using another CosmosDb Collection?



Thanks










share|improve this question


























    1















    I have an Azure Function which is triggered each time that one on more items in my CosmosDb Collection is updated.



    The code works correctly:



    [StorageAccount("AzureWebJobsStorage")]
    public static class ChangeFeedFunction
    {
    [FunctionName("ChangeFeedFunction")]
    public static void ChangeFeedFunction(
    [CosmosDBTrigger(
    databaseName: "MyDataBase",
    collectionName: "MyCollection",
    ConnectionStringSetting = "CosmosDbConnectionString",
    LeaseCollectionName = "MyCollection_Leases",
    CreateLeaseCollectionIfNotExists = true
    )] IReadOnlyList<Document> documents,
    [Queue("collection-changes")] ICollector<Message> analystQueue,
    ILogger logger
    )

    //Operations;



    But in the case, it means I have 2 CosmosDb Collections (MyCollection and MyCollection_Leases) which is minimum 40$ per month. I would like to reduce the cost. Is there a way to observe the modification on my CosmosDb Collection without using another CosmosDb Collection?



    Thanks










    share|improve this question
























      1












      1








      1








      I have an Azure Function which is triggered each time that one on more items in my CosmosDb Collection is updated.



      The code works correctly:



      [StorageAccount("AzureWebJobsStorage")]
      public static class ChangeFeedFunction
      {
      [FunctionName("ChangeFeedFunction")]
      public static void ChangeFeedFunction(
      [CosmosDBTrigger(
      databaseName: "MyDataBase",
      collectionName: "MyCollection",
      ConnectionStringSetting = "CosmosDbConnectionString",
      LeaseCollectionName = "MyCollection_Leases",
      CreateLeaseCollectionIfNotExists = true
      )] IReadOnlyList<Document> documents,
      [Queue("collection-changes")] ICollector<Message> analystQueue,
      ILogger logger
      )

      //Operations;



      But in the case, it means I have 2 CosmosDb Collections (MyCollection and MyCollection_Leases) which is minimum 40$ per month. I would like to reduce the cost. Is there a way to observe the modification on my CosmosDb Collection without using another CosmosDb Collection?



      Thanks










      share|improve this question














      I have an Azure Function which is triggered each time that one on more items in my CosmosDb Collection is updated.



      The code works correctly:



      [StorageAccount("AzureWebJobsStorage")]
      public static class ChangeFeedFunction
      {
      [FunctionName("ChangeFeedFunction")]
      public static void ChangeFeedFunction(
      [CosmosDBTrigger(
      databaseName: "MyDataBase",
      collectionName: "MyCollection",
      ConnectionStringSetting = "CosmosDbConnectionString",
      LeaseCollectionName = "MyCollection_Leases",
      CreateLeaseCollectionIfNotExists = true
      )] IReadOnlyList<Document> documents,
      [Queue("collection-changes")] ICollector<Message> analystQueue,
      ILogger logger
      )

      //Operations;



      But in the case, it means I have 2 CosmosDb Collections (MyCollection and MyCollection_Leases) which is minimum 40$ per month. I would like to reduce the cost. Is there a way to observe the modification on my CosmosDb Collection without using another CosmosDb Collection?



      Thanks







      azure-functions azure-cosmosdb






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 14 '18 at 19:14









      Cedric ArnouldCedric Arnould

      401317




      401317






















          2 Answers
          2






          active

          oldest

          votes


















          1














          Following the cosmos db trigger function document, the lease collection can't be avoid so far because it bears important responsibility.



          We need one lease collection when using the Trigger to store the checkpoints for each Function. Let me say that if there are 10 documents were inserted into cosmos db, the trigger function was triggered one by one and the checkpoint moved with the process and stored into lease collection. Suddently, the trigger shut down resulted from some reasons. During this time, 5 more documents inserted into db. After the trigger function restarting, it knows from which node to continue the execution function with the checkpoint in lease collection.(I wish I had made it clear...)



          BTW,you could share one single lease collection for all of your collection for a more cost-effective approach. Please refer to this article.



          As for the cost,you could create the minimum configured lease collection. And the cost on the portal is estimated value. The price based on the consumption of RUs. Please refer to this document.






          share|improve this answer























          • Thanks for your answer!

            – Cedric Arnould
            Nov 15 '18 at 19:27











          • @CedricArnould You're welcome!

            – Jay Gong
            Nov 16 '18 at 1:27


















          0














          I would suggest scaling the database rather than the collection. If you scaled the database at 400 RU/s you can share that across collections.






          share|improve this answer























          • Thanks for your comment

            – Cedric Arnould
            Jan 4 at 21:06










          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53307280%2fcosmosdbtrigger-on-azure-function-without-lease-collection%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          2 Answers
          2






          active

          oldest

          votes








          2 Answers
          2






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          1














          Following the cosmos db trigger function document, the lease collection can't be avoid so far because it bears important responsibility.



          We need one lease collection when using the Trigger to store the checkpoints for each Function. Let me say that if there are 10 documents were inserted into cosmos db, the trigger function was triggered one by one and the checkpoint moved with the process and stored into lease collection. Suddently, the trigger shut down resulted from some reasons. During this time, 5 more documents inserted into db. After the trigger function restarting, it knows from which node to continue the execution function with the checkpoint in lease collection.(I wish I had made it clear...)



          BTW,you could share one single lease collection for all of your collection for a more cost-effective approach. Please refer to this article.



          As for the cost,you could create the minimum configured lease collection. And the cost on the portal is estimated value. The price based on the consumption of RUs. Please refer to this document.






          share|improve this answer























          • Thanks for your answer!

            – Cedric Arnould
            Nov 15 '18 at 19:27











          • @CedricArnould You're welcome!

            – Jay Gong
            Nov 16 '18 at 1:27















          1














          Following the cosmos db trigger function document, the lease collection can't be avoid so far because it bears important responsibility.



          We need one lease collection when using the Trigger to store the checkpoints for each Function. Let me say that if there are 10 documents were inserted into cosmos db, the trigger function was triggered one by one and the checkpoint moved with the process and stored into lease collection. Suddently, the trigger shut down resulted from some reasons. During this time, 5 more documents inserted into db. After the trigger function restarting, it knows from which node to continue the execution function with the checkpoint in lease collection.(I wish I had made it clear...)



          BTW,you could share one single lease collection for all of your collection for a more cost-effective approach. Please refer to this article.



          As for the cost,you could create the minimum configured lease collection. And the cost on the portal is estimated value. The price based on the consumption of RUs. Please refer to this document.






          share|improve this answer























          • Thanks for your answer!

            – Cedric Arnould
            Nov 15 '18 at 19:27











          • @CedricArnould You're welcome!

            – Jay Gong
            Nov 16 '18 at 1:27













          1












          1








          1







          Following the cosmos db trigger function document, the lease collection can't be avoid so far because it bears important responsibility.



          We need one lease collection when using the Trigger to store the checkpoints for each Function. Let me say that if there are 10 documents were inserted into cosmos db, the trigger function was triggered one by one and the checkpoint moved with the process and stored into lease collection. Suddently, the trigger shut down resulted from some reasons. During this time, 5 more documents inserted into db. After the trigger function restarting, it knows from which node to continue the execution function with the checkpoint in lease collection.(I wish I had made it clear...)



          BTW,you could share one single lease collection for all of your collection for a more cost-effective approach. Please refer to this article.



          As for the cost,you could create the minimum configured lease collection. And the cost on the portal is estimated value. The price based on the consumption of RUs. Please refer to this document.






          share|improve this answer













          Following the cosmos db trigger function document, the lease collection can't be avoid so far because it bears important responsibility.



          We need one lease collection when using the Trigger to store the checkpoints for each Function. Let me say that if there are 10 documents were inserted into cosmos db, the trigger function was triggered one by one and the checkpoint moved with the process and stored into lease collection. Suddently, the trigger shut down resulted from some reasons. During this time, 5 more documents inserted into db. After the trigger function restarting, it knows from which node to continue the execution function with the checkpoint in lease collection.(I wish I had made it clear...)



          BTW,you could share one single lease collection for all of your collection for a more cost-effective approach. Please refer to this article.



          As for the cost,you could create the minimum configured lease collection. And the cost on the portal is estimated value. The price based on the consumption of RUs. Please refer to this document.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 15 '18 at 2:01









          Jay GongJay Gong

          8,9401512




          8,9401512












          • Thanks for your answer!

            – Cedric Arnould
            Nov 15 '18 at 19:27











          • @CedricArnould You're welcome!

            – Jay Gong
            Nov 16 '18 at 1:27

















          • Thanks for your answer!

            – Cedric Arnould
            Nov 15 '18 at 19:27











          • @CedricArnould You're welcome!

            – Jay Gong
            Nov 16 '18 at 1:27
















          Thanks for your answer!

          – Cedric Arnould
          Nov 15 '18 at 19:27





          Thanks for your answer!

          – Cedric Arnould
          Nov 15 '18 at 19:27













          @CedricArnould You're welcome!

          – Jay Gong
          Nov 16 '18 at 1:27





          @CedricArnould You're welcome!

          – Jay Gong
          Nov 16 '18 at 1:27













          0














          I would suggest scaling the database rather than the collection. If you scaled the database at 400 RU/s you can share that across collections.






          share|improve this answer























          • Thanks for your comment

            – Cedric Arnould
            Jan 4 at 21:06















          0














          I would suggest scaling the database rather than the collection. If you scaled the database at 400 RU/s you can share that across collections.






          share|improve this answer























          • Thanks for your comment

            – Cedric Arnould
            Jan 4 at 21:06













          0












          0








          0







          I would suggest scaling the database rather than the collection. If you scaled the database at 400 RU/s you can share that across collections.






          share|improve this answer













          I would suggest scaling the database rather than the collection. If you scaled the database at 400 RU/s you can share that across collections.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Jan 3 at 21:26









          DillorscroftDillorscroft

          143129




          143129












          • Thanks for your comment

            – Cedric Arnould
            Jan 4 at 21:06

















          • Thanks for your comment

            – Cedric Arnould
            Jan 4 at 21:06
















          Thanks for your comment

          – Cedric Arnould
          Jan 4 at 21:06





          Thanks for your comment

          – Cedric Arnould
          Jan 4 at 21:06

















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53307280%2fcosmosdbtrigger-on-azure-function-without-lease-collection%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          這個網誌中的熱門文章

          How to read a connectionString WITH PROVIDER in .NET Core?

          In R, how to develop a multiplot heatmap.2 figure showing key labels successfully

          Museum of Modern and Contemporary Art of Trento and Rovereto