• wrote:

    jabujakan wrote:

    Hi all,

    I'm on my way to creating a new pipeline on our Azure stack that is supposed to read Excel sheets located at Google Drive partitions.

    We're using Data Factory to read those files, but they don't have a connection directly with Google Drive.

    So, I'm assuming I have basically two options

    Transfer all those files to SharePoint manually or ask clients to use it instead of Gdrive (not nice) Create an automation or pipeline at GCP that extract files from GDrive and sends to Google Cloud Storage (data factory has built-in connection with it) How would you guys handle this scenario? There are more options available? SPAM LINK REMOVED Thanks in advance!

    I got this,...

    Nope... I've got you. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)