Loading Data into DW: Direct Insert from PreProcessing vs PreProcess and then loading from CSV files












-1












$begingroup$


I have a preprocessing script (google cloud function) that generates files (stored in Google Drive). I want to load those files in my DW (Big Query).



What are the pros and cons of:



1) Running the preprocessing script, generate the files and then loadthose files



vs



2) Loading data directly from the preprocessing script (skip the file generation, just do a direct insert in the DW from the preprocessing script)



?



I am interested in focusing the question not only in terms of technical stuff and costs, but also in terms of data processing methodology.



I think the question could lead to the dilemma loading online or more in a batch process.



I have added some conclusions of mine as answers.
Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



Thanks!






bigdata preprocessing







share|improve this question











$endgroup$

















    -1












    $begingroup$


    I have a preprocessing script (google cloud function) that generates files (stored in Google Drive). I want to load those files in my DW (Big Query).



    What are the pros and cons of:



    1) Running the preprocessing script, generate the files and then loadthose files



    vs



    2) Loading data directly from the preprocessing script (skip the file generation, just do a direct insert in the DW from the preprocessing script)



    ?



    I am interested in focusing the question not only in terms of technical stuff and costs, but also in terms of data processing methodology.



    I think the question could lead to the dilemma loading online or more in a batch process.



    I have added some conclusions of mine as answers.
    Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



    Thanks!






    bigdata preprocessing







    share|improve this question











    $endgroup$















      -1












      -1








      -1





      $begingroup$


      I have a preprocessing script (google cloud function) that generates files (stored in Google Drive). I want to load those files in my DW (Big Query).



      What are the pros and cons of:



      1) Running the preprocessing script, generate the files and then loadthose files



      vs



      2) Loading data directly from the preprocessing script (skip the file generation, just do a direct insert in the DW from the preprocessing script)



      ?



      I am interested in focusing the question not only in terms of technical stuff and costs, but also in terms of data processing methodology.



      I think the question could lead to the dilemma loading online or more in a batch process.



      I have added some conclusions of mine as answers.
      Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



      Thanks!






      bigdata preprocessing







      share|improve this question











      $endgroup$




      I have a preprocessing script (google cloud function) that generates files (stored in Google Drive). I want to load those files in my DW (Big Query).



      What are the pros and cons of:



      1) Running the preprocessing script, generate the files and then loadthose files



      vs



      2) Loading data directly from the preprocessing script (skip the file generation, just do a direct insert in the DW from the preprocessing script)



      ?



      I am interested in focusing the question not only in terms of technical stuff and costs, but also in terms of data processing methodology.



      I think the question could lead to the dilemma loading online or more in a batch process.



      I have added some conclusions of mine as answers.
      Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



      Thanks!






      bigdata preprocessing




      bigdata preprocessing






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 1 hour ago







      Gabriel

















      asked Jan 11 at 22:16









      GabrielGabriel

      1065




      1065






















          1 Answer
          1






          active

          oldest

          votes


















          0












          $begingroup$

          Loading the data directly from the preprocessing script to the DW means not storing the results of your processing on storage.



          Not storing those results on storage may imply:




          • Needing to do the processing again if for some reason the data is needed again, for a new DW or for a new research.

          • Not saving the data as a data sink and so not contributing to a data lake architecture, where data sinks are just saved for future reusing on "unpredicted" situations.


          From a technical perspective, some tradeoffs are mentioned on the Google BigQuery docs on Streaming data, from which the following could be highlighted:




          • Consistency management, as for errors or duplicates.

          • Waiting time until data is available for copy and export operations


          Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



          Thanks






          share|improve this answer









          $endgroup$













            Your Answer





            StackExchange.ifUsing("editor", function () {
            return StackExchange.using("mathjaxEditing", function () {
            StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
            StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
            });
            });
            }, "mathjax-editing");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "557"
            };
            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: false,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: null,
            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%2fdatascience.stackexchange.com%2fquestions%2f43873%2floading-data-into-dw-direct-insert-from-preprocessing-vs-preprocess-and-then-lo%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0












            $begingroup$

            Loading the data directly from the preprocessing script to the DW means not storing the results of your processing on storage.



            Not storing those results on storage may imply:




            • Needing to do the processing again if for some reason the data is needed again, for a new DW or for a new research.

            • Not saving the data as a data sink and so not contributing to a data lake architecture, where data sinks are just saved for future reusing on "unpredicted" situations.


            From a technical perspective, some tradeoffs are mentioned on the Google BigQuery docs on Streaming data, from which the following could be highlighted:




            • Consistency management, as for errors or duplicates.

            • Waiting time until data is available for copy and export operations


            Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



            Thanks






            share|improve this answer









            $endgroup$


















              0












              $begingroup$

              Loading the data directly from the preprocessing script to the DW means not storing the results of your processing on storage.



              Not storing those results on storage may imply:




              • Needing to do the processing again if for some reason the data is needed again, for a new DW or for a new research.

              • Not saving the data as a data sink and so not contributing to a data lake architecture, where data sinks are just saved for future reusing on "unpredicted" situations.


              From a technical perspective, some tradeoffs are mentioned on the Google BigQuery docs on Streaming data, from which the following could be highlighted:




              • Consistency management, as for errors or duplicates.

              • Waiting time until data is available for copy and export operations


              Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



              Thanks






              share|improve this answer









              $endgroup$
















                0












                0








                0





                $begingroup$

                Loading the data directly from the preprocessing script to the DW means not storing the results of your processing on storage.



                Not storing those results on storage may imply:




                • Needing to do the processing again if for some reason the data is needed again, for a new DW or for a new research.

                • Not saving the data as a data sink and so not contributing to a data lake architecture, where data sinks are just saved for future reusing on "unpredicted" situations.


                From a technical perspective, some tradeoffs are mentioned on the Google BigQuery docs on Streaming data, from which the following could be highlighted:




                • Consistency management, as for errors or duplicates.

                • Waiting time until data is available for copy and export operations


                Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



                Thanks






                share|improve this answer









                $endgroup$



                Loading the data directly from the preprocessing script to the DW means not storing the results of your processing on storage.



                Not storing those results on storage may imply:




                • Needing to do the processing again if for some reason the data is needed again, for a new DW or for a new research.

                • Not saving the data as a data sink and so not contributing to a data lake architecture, where data sinks are just saved for future reusing on "unpredicted" situations.


                From a technical perspective, some tradeoffs are mentioned on the Google BigQuery docs on Streaming data, from which the following could be highlighted:




                • Consistency management, as for errors or duplicates.

                • Waiting time until data is available for copy and export operations


                Still, it would be great to have more comments about the technical perspective on when to use direct transfer and when to use a file for staging preprocessing results.



                Thanks







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 1 hour ago









                GabrielGabriel

                1065




                1065






























                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Data Science Stack Exchange!


                    • 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.


                    Use MathJax to format equations. MathJax reference.


                    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%2fdatascience.stackexchange.com%2fquestions%2f43873%2floading-data-into-dw-direct-insert-from-preprocessing-vs-preprocess-and-then-lo%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







                    -

                    Popular posts from this blog

                    How to label and detect the document text images

                    Image
                    1 $begingroup$ This is what I mean as document text image: I want to label the texts in image as separate blocks and my model should detect these labels as classes. NOTE: This is how the end result should be like: The labels like Block 1, Block 2, Block 3,.. should be Logo, Title, Date,.. Others, etc. Work done: First approach : I tried to implement this method via Object Detection, it didn't work. It didn't even detect any text. Second approach : Then I tried it using PixelLink. As this model is build for scene text detection, it detected each and every text in the image. But this method can detect multiple lines of text if the threshold values are increased. But I have no idea how do I add labels to the text blocks. PIXEL_CLS_WEIGHT_all_ones = 'PIXEL_CLS_WEIGHT_all_ones' PIXEL_C...
                    Read more

                    Vallis Paradisi

                    Image
                    Coordinata: .mw-parser-output .geo-default,.mw-parser-output .geo-dms,.mw-parser-output .geo-dec{display:inline}.mw-parser-output .geo-nondefault,.mw-parser-output .geo-multi-punct{display:none}.mw-parser-output .longitude,.mw-parser-output .latitude{white-space:nowrap} 33°03′S 71°37′W  /  33.05°S 71.617°W  / -33.05; -71.617 Vallis Paradisi Res apud Vicidata repertae: Civitas : Chilia Numerus incolarum : 296 655 Zona horaria : UTC-4 Situs interretialis Nomen officiale : Valparaíso Gubernium Consilium : municipal council of Valparaíso Geographia Superficies : 401 600 000 Metrum quadratum Coniunctiones urbium Urbes gemellae : Ovetum , Badalona , Santa Fe , Ora longa , Sciamhaevum , Quantunia , Callao , Bat Yam , Melaka , Novorossiysk , Busan , Corduba , Odessa , Rosario , Malacca , Barcino , Soteropolis , Franciscopolis (California) , Guanajuato, Silao Tabula aut despectus Despectus in portum sinumque et urbem Vallis Paradisi Vallis Para...
                    Read more

                    Tabula Rosettana

                    Image
                    Tabula multilinguis Rosettana in Museo Britannico ostenditur. Tabula Rosettana, [1] etiam titulo OGIS 90 agnita, est stela decreto de rebus sacris in Aegypto anno 196 a.C.n. lato inscripta. Tabula iuxta Rosettam Aegypti, urbem in delta Nili et ad oram maris Mediterranei iacentem, anno 1799 a milite Francico reperta est. Inventio stelae, linguis duabus scripturisque tribus inscriptae, eruditis Instituti Aegypti statim nuntiata est; ibi enim iussu imperatoris Napoleonis eruditi omnium scientiarum (sub aegide Commissionis Scientiarum et Artium) properaverant cum expeditione Francica. Qua a Britannis mox debellata, tabula Rosettana Londinium missa hodie apud Museum Britannicum iacet. Textus Graecus cito lectus interpretationi textuum Aegyptiorum (in formis hieroglyphica et demotica expressorum) gradatim adiuvit. Denique textum plene interpretatus est Ioannes Franciscus Champollion. Ab opere eruditorum cumulativo coepit hodiernus scripturae hieroglyphicae linguaeque Aegyptiae a...
                    Read more