Good question, I think pip is still considered the more stable package manager, I imagine pip will adopt some things from uv pip once it reaches version 1.0.0

Thanks! That would be great to hear what you find

That's good to know!

The Rustaceans are sweeping the nations

Thanks! The support means a lot

Pray tell why does venv make pip difficult?

its not stangie its just extra steps

I'm glad it helped. Thanks for the support!

Hi, thanks for the comment, I can have a go this weekend, I dont have QGIS installed on my computer at the moment. My only thought would be to set the Type as HTTP/HTTPS/FTP in the data source manager window and passing in a url to your files, rather than selecting Microsoft Azure blob. It looks like the authentication for vsiadls and vsaiz should be the same, so I dont imagine there would be any change needed to the environment variable. Let me know if you figure it out.

There's a provider/Protocol Type now in the the 'Add layer' dialogue: 'Microsoft Azure Data Lake Storage', try that?

Hi, which part doesnt work for you and what is the error message you get?

Thanks for the reminder! I remembered I had trouble adding the code the the description because you can add < and > signs in a video description, ill paste the code in this comment until I figure it out

--create a FIFO schema create schema EXAMPLE_DB.FIFO; --create a BUY table create or replace table EXAMPLE_DB.FIFO.BUY ("INDEX" integer, QUANTITY float, PRICE float); --create a SELL table create or replace table EXAMPLE_DB.FIFO.SELL ("INDEX" integer, QUANTITY float); --add values to the initial tables -------------------------------------------------------------- insert into EXAMPLE_DB.FIFO.BUY ("INDEX", QUANTITY, PRICE) values (1, 200, 10), (2, 150, 12), (3, 225, 16); insert into EXAMPLE_DB.FIFO.SELL ("INDEX", QUANTITY) values (1, 100), (2, 300); CREATE OR REPLACE VIEW INVENTORY ("INDEX", QUANTITY, PRICE, TOTAL_COST) as --get the total number of units sold WITH total_units_sold AS ( SELECT SUM(QUANTITY) TOTAL_UNITS_SOLD FROM EXAMPLE_DB.FIFO.SELL ), --CUMULATIVE_SUM table as: the inventory table with a CUMULATIVE SUM COST column cumulative_sum AS ( SELECT *, SUM(QUANTITY) OVER (PARTITION BY NULL ORDER BY "INDEX") CUMULATIVE_SUM FROM EXAMPLE_DB.FIFO.BUY --do a cross join to add TOTAL_UNITS_SOLD AS A NEW COLUMN cross join total_units_sold ), updated_quantity AS ( SELECT *, CUMULATIVE_SUM-TOTAL_UNITS_SOLD BUY_SELL_DIFFERENCE, --whatever is left over from the buy-sell difference needs to be subtracted IFF(BUY_SELL_DIFFERENCE > 0 AND LAG(BUY_SELL_DIFFERENCE) OVER (PARTITION BY NULL ORDER BY "INDEX") < 0, BUY_SELL_DIFFERENCE, QUANTITY) UPDATED_QUANTITY FROM cumulative_sum ) SELECT "INDEX", UPDATED_QUANTITY QUANTITY, PRICE, UPDATED_QUANTITY*PRICE TOTAL_COST FROM updated_quantity --purchases that get completely sold out with have a negative buy sell difference, so get removed from the inventory WHERE BUY_SELL_DIFFERENCE >=0 ; --Cost of Goods sold CREATE OR REPLACE VIEW cogs ("INDEX", cogs) as WITH cumulative_units_sold AS ( SELECT *, SUM(QUANTITY) OVER (PARTITION BY NULL ORDER BY "INDEX") CUMULATIVE_SELL FROM EXAMPLE_DB.FIFO.SELL ), --work out the total amount of stock sold as of the previos sale previous_sales AS ( SELECT SELL.INDEX SELL_INDEX, SELL.QUANTITY SELL_QUANTITY, BUY.INDEX BUY_INDEX, BUY.QUANTITY BUY_QUANTITY, BUY.PRICE BUY_PRICE, CUMULATIVE_SELL - SELL_QUANTITY SOLD_PREVIOSLY, --deal with the SOLD PREVIOSLY FIRST THEN SUBTRACT THE REMAINDER SUM(BUY_QUANTITY) OVER (PARTITION BY SELL_INDEX ORDER BY BUY_INDEX) CUMULATIVE_BUY, --how much is left in the st CUMULATIVE_BUY-SOLD_PREVIOSLY BUY_SELL_DIFFERENCE FROM cumulative_units_sold SELL FULL OUTER JOIN BUY ORDER BY SELL_INDEX, BUY_INDEX ), --update the stocks to what we would have after the previous sale --rows with negative (OR 0) buy-sell differences are removed in the next table updated_inv_quantity AS ( SELECT SELL_INDEX, SELL_QUANTITY, BUY_INDEX, BUY_QUANTITY, BUY_PRICE, BUY_SELL_DIFFERENCE, --remaining_stock_rank will be 1 for any partially remaining stock. Which will come after some of the prev or same rows have used up stock rank() over (partition by sell_index order by iff(buy_sell_difference <=0, NULL, buy_index)) remaining_inv_rank, --make a adjustments for any partially depleted stock. Keep non-partially depleted stock the same number as what was bought iff(remaining_inv_rank = 1, BUY_SELL_DIFFERENCE, BUY_QUANTITY) updated_inv --updated holdings after the previous sale FROM previous_sales ORDER BY SELL_INDEX, BUY_INDEX ), cogs_whole AS ( SELECT SELL_INDEX, SELL_QUANTITY, BUY_INDEX, BUY_PRICE, updated_inv, SUM(updated_inv) OVER (PARTITION BY SELL_INDEX ORDER BY BUY_INDEX) CUMULATIVE_inv, CUMULATIVE_inv-SELL_QUANTITY UPDATED_BUY_SELL_DIFFERENCE, --if a buy record has been completely depleted, that is counted as a whole cogs IFF(UPDATED_BUY_SELL_DIFFERENCE<=0, UPDATED_inv*BUY_PRICE, 0) COGS_WHOLE FROM updated_inv_quantity WHERE BUY_SELL_DIFFERENCE >0 ORDER BY SELL_INDEX, BUY_INDEX ), cogs_part as ( select *, rank() over (partition by sell_index order by iff(cogs_whole = 0,buy_index, NULL)) cogs_part_rank, IFF(cogs_part_rank = 1, (UPDATED_inv - UPDATED_BUY_SELL_DIFFERENCE)*BUY_PRICE, 0) cogs_part, cogs_whole+cogs_part cogs_all --IFF(UPDATED_BUY_SELL_DIFFERENCE>SELL_QUANTITY) --LAG(COGS_WHOLE) OVER (PARTITION BY SELL_INDEX ORDER BY BUY_INDEX) TEST from cogs_whole ORDER BY SELL_INDEX, BUY_INDEX ) select sell_index, sum(cogs_all) cogs from cogs_part group by sell_index ;

Glad it helped!

You'd probably need a VM

I'm trying to do this in an azure datafactory and a custom activity in the datafactory can execute python files that are saved on a blob. You will need an azure batch account with a pool that has python installed on it (pools are based on vm's and some vm's have python pre-installed). Another way could be azure function apps but I have not tried that enough

Thanks! Yes this took me ages to figure out, so had to share

Thanks for watching!

Thanks for watching!

Thanks so much! I really appreciate the support

Thanks for watching!

I have the same question.

Hi @investing3370, try changing line 16 to: sas_token = 'your sas token' connect_str = 'DefaultEndpointsProtocol=https;SharedAccessSignature=' + sas_token + ';EndpointSuffix=core.windows.net' you wont line lines 11 to 13 let me know if that works