Integrate Snowflake Tables to Jira Assets

[pankaj_r_dave]

I would love to hear back any suggestions or solutions you can think of exporting snowflake tables values into Jira assets like name and registration ID's into Jira's CMDB - Jira assets.

How can i do that?

Kindly Opine.

Thanks,

Pankajkumar Dave

[Martin Luethi _Mobility Stream_]

Hi @pankaj_r_dave ,

I’m with the team behind Snowflake for Jira. Today our app exports Jira, Assets, Forms, Tempo, and Xray data into Snowflake.

We recently had several customers ask about the reverse workflow, syncing data from Snowflake into Jira Assets, so you are definitely not alone. We spoke with a number of teams at Team '26 who are doing this today, and while most rely on the Assets REST API, it can become fairly complex to build and maintain, as @Gabriela mentioned.

If you are open to using an app, we would be interested in learning more about your use case. We are actively evaluating adding Snowflake to Assets synchronization, either to Snowflake for Jira or to our new Asset Manager for Jira app, which provides spreadsheet-style bulk management for Jira Assets.

I would love to hear more about what data you are trying to sync and how often you need it updated. Please reach out.

Thanks,
Martin

[Gabriela]

Hi pankaj, the blocker before anything else is the plan. Assets isn't on Free, so there's no CMDB to load into yet — it starts at Jira Service Management Standard. Get onto Standard or higher first.

After that, there's no native Snowflake connector, so it's an import job. To keep a CMDB current you'd drive it through the Assets REST API: a script or ETL reads your Snowflake tables and creates or updates objects via the Object API, mapping name and registration ID to attributes, on a schedule. On Premium or Enterprise, Assets Data Manager does the same as a managed scheduled import if you'd rather not maintain a script.

If you only need a one-off or occasional load, skip the code and use Assets' built-in CSV import — export the tables to CSV and map the columns to object attributes on the way in.