Home - Ayush810/NYC-TAXI-Yellow GitHub Wiki

Welcome to the NYC-TAXI-Yellow

Create Pipeline to bring the data from the landing Zone to Staging (Pipeline name = pl_stg_lookup)

Once the pipeline created Click on -> Add Pipeline Activity -> and Select Copy Data Activity

Now an activity will be created in your pipeline Go to General -> Rename the activity as (Copy Lookup Table)

Now go to Source and inside connection select your Lakehouse (Project Lakehouse)

Now GO TO **Root ** --> and cheque the Files option Go To filepath and Browse and select your file

Go to File format - > Select Delimeted Text

Now Go To- Destination -> Inside Connections Select your Warehouse where you want to put that data in my case i am putting it into project warehouse

And in Table options select Auto create Table

just below that go to - Table - > Write schema Name - stg & Table name - taxi_zone_lookup

Validate the Activity once you are done with it and then (save + Run) the Activity