Has anyone able to ingest cost data of Snowflake to  Apptio TBM Studio? Can you let us know the process on how you did it?

Hello @Paula Abracosa,

We're prototyping this. For now, we received an Excel file from the Snowflake admins.

The provider's documentation mentions a RESTful API: Snowflake SQL API | Snowflake Documentation You may be able to create a connector to execute the queries, once you get the credentials set up.
If that doesn't work, you may be able to request the admins set up a job that extracts the data periodically (say, daily) and you pick up the file with a local Datalink agent. This blog post might be useful, although it's not specifically about Snowflake (link). We use this technique all the time.

For all these data imports, the tricky bit is mapping the costs to objects in the model. We always try to do that to Applications, but it will depend on the granularity of the accounts in the source system (Snowflake, in this case). In our TBM Office, we have no control over that: sometimes they map an account to a whole Business Unit, sometimes to individual products or applications.

I would sketch the process as follows:

1. Get a sample file with the consumption data
2. Load it in TBM Studio
3. Figure out how to map the accounts to applications (or whatever). The admins will know who/what organization requested the account, so you can talk to both parties about apps/products
4. Define the allocation strategy
5. See how to automate the load process via the API
6. Implement the Datalink connector