Видео

I didn't manage to get this working using the AZURE_STORAGE_ACCESS_KEY method but did get it working using 2 environment variables: AZURE_STORAGE_ACCOUNT and AZURE_STORAGE_ACCESS_KEY with their relevant values. Also, a shapefile didn't work but a COG raster did. Just to re-highlight also, that adding/modifying of the environment variables requires restarting of QGIS- I found that some older values I had tried were being retained if I didn't close all instances of QGIS. The best way to check is to examine the 'Current environment variables (read-only - .....) section and checking the AZURE_....values are as expected.

Thank you for this video. I hope you can assist me on a problem I am having. After I refresh the data, under queries & connections, it shows I have errors. I do not know how to check these or fix them. Can you help? Thanks!

Love the video! I'm trying to do this for my MTG collection. How would you go about inputting cards when pricecharting doesn't have the number available in the url of the specific card? Example would be the plain jane Consuming Blob.

Simpel straignt forward video, really helpful

When we do this it appears a use security integration type saml instead of account parameter

I'm lost. Why wouldn't the maintainers of pip simply apply the same optimizations as uv then if it doesn't actually need to download all that extra content?

My issue is I want to link one of those tables that are duplicated in separate databases (as you showed in the beginning). This produces an error in Access. "Cannot define field more than once." I suspect the quick and dirty solution is to create a Snowflake Role that can only see that database. Thus it will appear only once. The cleaner solution is to link the table programmatically. This will require building an odbc connection string. I'm looking into that now. If I get a chance, I'll post a solution.

It’s way faster when making venvs!

ooh. I support a SaaS app and _hate_ Azure Storage Explorer with a burning passion. if I can access logs etc from Python instead of ASE that would be a very happy rabbithole to go down. I suspect I don't have access to those keys though

how can it be faster, it's three extra keystrokes

Rust is the new programming contagion

Hi a very good tutorial. I am using SQL Server 2019 where order by command is not allowed with cte . Please suggest alternate. Also tell you are working on which environment. Regards

You're so underated

Hate using pip because of venvs. At least pipx exists when its just Python programs

Thanks a lot for this very clear video. I spent hours trying to do this until I luckily stumble across your video. I agree that this video should definitely have more views!!

Hey, do you know by any chance how to connect to Microsoft Azure Data Lake Storage Gen 2? I cant do it the same way as you are doing it. It needs vsiadls file system handler (your method uses vsiaz), but i dont know how to set it :(

Hi ,Thanks for your info.Hi, I want to display column headings without single quotes before and after in the output. You displayed 'BA', 'AB', 'CA', and I aim to dynamically achieve BA AB CA.can you explain how to achieve BA AB CA

This is not working these days. Don't waste your time.

How do you add ungraded, along with all the graded prices?

Could You put code somewhere ?

Love it!

What if you did not want to bring the files down to the local machine? How would you process the files up on Azure? And run the Python code on Azure. For instance, the files were placed in blob storage and now you wanted process them, clean them up and then save out the results out in blob storage. The Python code is not complicated , just what are the pices/configuration up on Azure.

can i create different layouts and size them in specific area without them stepping outside of the limits i gave them?

Nice Video! I completed what you did but I want to make an addition. I would like to have a column with the grade and that the power query gets the web info for that specific grade. So to have the "ungraded" between square brackets replaced with an value of a column in de source file. = Table.AddColumn(#"Added Custom", "Value", each Web.Page(Web.Contents([urls]))[Data]{0}[Ungraded]{0}) But after trying I'm not getting the desired results. only errors that the specific column cant be found in the table of the URL (understandable) Do you have an idea how to fix this?

I'm having connection problems, but this video is solving them, thank you very much!

Hi, can you write to Blob storage from ArcGIS Pro using these connections?

How do you remove the single quotes on the column headers after the pivot? Also, I am unable to retrieve in another select statement once it has the single quotes.

Just saying thanks for this. The online docs for how to authenticate with cloud providers is absolutely trash, and this was the only one that showed you needed to go to settings to add env vars. Helped me figure out how to authenticate with GCS

Thank you fo this video! It saved my time

Fantastic video. Very clear explanation and clean code for us to follow. Thank you!

Dude, thank you so much!!!

What about Snowflake Roles? How do assign them to a user?

Thank you for this video! It's exactly what I'm looking for . Thanks again!

It is very detailed and clear explanation! Great work:)

What happens to the connection when i share the workbook to colleagues? Just won't refresh, or does the data revert to errors of some sort? (Users who don't have a snowflake driver or creds)

Notice the decorator function is *returning a function*, not simply calling it. That's a key part to understand.

I need to establish a direct connection, do not want to export data to excel, my data tables are larger in size. How do I achieve that?

I had to put "dsn=my-db-name" in the "Database" field, instead of just "my-db-name". Not sure why.

I have a python script that reads an EDI file and, from there, creates unique data tags and elements (basically a CSV file with one tag and data field, per line). I need to process to load this into Azure and, for the outbound, to extract into the same tags+data. This looks close. Anyone interested in giving me a quote for this (can you show it working?). Thanks.

Thanks a lot for this ! It's working for me.

My database already has 2 columns: Lat and Long. Can I just call these two columns straight into GIS Pro and the software will identify it? Or I have to convert it using the same format as you?

Thanks! that was very helpful

thanks☺

Hi, how to download that data and store it in excel or csv? Thanks in advance.

Videos like yours should have way more views. Thank you for what you do.

thank you for this video

Do you have any suggestions for how to then write a file in a similar fashion to the storage blob?

What with happen when you have SAS token on hand, can it be replaced with account key?

Great video! I have tried to replicate this but I failed at some point. At the time stemp 13:46, you are changing the Data type of the card value to a decimal number and your value stays 1.38. When I do this my value changes from 38.00 to 3800, so it deletes the ".". Couild you maybe help me with this and explain how I can correct this?

Thanks man amazing content keep going !