Hey how to I pull intune data out of my tenant and into snowflake?

Question

I need to write reports using a data pool in snowflake with data from intune. how do I get the intune data out to SNOWFLAKE DB?

I am not a database administrator so I don't even know where to start to do an API call. can anyone provide help or step by step guide?

I need support on how to grant access to API calls.

Answer 1

@Jorge Maltes, Thanks for posting in Q&A. For your question about where to do API call when put data into snowflake, I am not sure. But if you want to know how to query Intune data from API, I would like to say we can create app registration and grant the required API permission, use this registration app to access the API you want to get Intune data.

Here are links about creating app registration. You can read them as a reference.

https://learn.microsoft.com/en-us/mem/intune/developer/intune-graph-apis

https://msendpointmgr.com/2017/08/03/create-an-azure-ad-app-registration-for-accessing-microsoft-intune-graph-api-with-powershell/

Note: None-Microsoft link, just for the reference.

After that, you can use application or script to get the data via APi. Here are some script examples you can refer:

https://github.com/microsoftgraph/powershell-intune-samples

Note: None-Microsoft link, just for the reference.

Hope the above information can help.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.