none
How to eliminate partition from Blob Storage RRS feed

  • Question

  • We have a Blob Storage with over 2 TB of files. How can <g class="gr_ gr_77 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="77" id="77">i</g> create an external table where <g class="gr_ gr_78 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="78" id="78">i</g> can eliminate loading entire set of 2TB o files when running Query. How can <g class="gr_ gr_333 gr-alert gr_tiny gr_spell gr_inline_cards gr_run_anim ContextualSpelling multiReplace" data-gr-id="333" id="333">i</g> only load certain files out of those 2TB worth of files? Looking for something similar to partition elimination.
    Wednesday, October 4, 2017 3:08 AM

All replies

  • HI NSS,

    To achieve this you will need to use the External Table definitions location parameter to specify the specific file path location that you want to read from. 

     

    Wednesday, October 4, 2017 4:33 PM