In Finout, besides the native cost centers we support, you can connect to any additional cost center you want! To do that, we need to access a Snowflake table containing cost data.
The following table structure in Snowflake could be used for us to ingest custom data from:
create or replace TABLE FINOUT_COST_EXPORT ( SOURCE VARCHAR(100), USAGE_DATE DATE, SERVICE_NAME VARCHAR(1000), COST FLOAT, METADATA OBJECT );
Where:
SOURCE is an indication to the source cloud or system, i.e Datadog, Azure etc
USAGE_DATE is the date you would want to add the costs to
SERVICE_NAME is a sub-service within the source, COST is the cost in USD
METADATA is a custom key-value object for tags, optional
Follow the guide for allowing Finout to access Snowflake data here, and add Finout’s role privileges to query the above table, and that’s it!
Still need help? Please feel free to reach out to our team at [email protected].