Custom Cost Centers

You can connect to custom cost centers in addition to the native cost centers supported by Finout. This can be done in the following two ways:

• CSV - Connect custom cost centers using CSV format in a container that can be read, such as an S3 bucket.

  Note: You can send Finout support in CSV format without a bucket for an initial cost center connection.

• Snowflake - Connect custom cost centers using the Snowflake table containing cost data.

Connect Custom Cost Centers via CSV

The CSV format we support is based on three main columns:

"UsageDate","ServiceName","Cost"

• UsageDate - YYYY-MM-DD - The day the cost incurred

• ServiceName - String - The name of the cost, the way you want it to appear in Finout

• Cost - double - the cost in dollars

For example:

"UsageDate","ServiceName","Cost"

"2022-06-07","Servers","12.12"

"2022-06-07","Storage","6.22"

"2022-06-08","Network","0.05"

With this custom integration, you can make more complicated integrations and add metadata fields as well.

Connect Custom Cost Centers Via Snowflake

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 this guide to allow Finout to access Snowflake data and add Finout’s role privileges to query the above table.