Bring Your Own Data (BYOD)

Ternary’s Bring Your Own Data (BYOD) feature allows ingestion of custom time series datasets into the platform. This enables analysis of business metrics such as KPIs, non cloud costs, and other financial or operational data alongside existing multi cloud billing data.

Typical use cases include data center spend, private cloud costs, SaaS spend, and revenue data.

The BYOD integration supports the following data sources:

• Amazon S3 for CSV files stored in S3 buckets
• Azure Blob Storage for CSV files stored in containers
• Google Cloud Storage for CSV files stored in GCS buckets
• Google BigQuery for direct ingestion from tables

Ternary checks for updates every four hours and ingests changes automatically. A manual refresh can also be triggered from the integration settings.

Requirements and prerequisites

The following conditions must be met before configuring the BYOD Ternary integration:

Data requirements

The dataset must include at least one date or timestamp column representing the start of the billing or usage period. This field is mandatory and required for normalization and ingestion scheduling. Without it, the dataset cannot be processed.

Additional date or timestamp fields can be included to support more granular analysis.

Supported formats:

• CSV files for Amazon S3, Azure Blob Storage, and Google Cloud Storage
• Native BigQuery tables

Data can be stored in the same location as billing exports or in a separate bucket or container. If a separate location is used, additional IAM permissions are required.

Supported tag formats

• Column based tags: Each column represents a tag key, with row values representing tag values. For example, a column named environment with values such as prod or dev.
• JSON tag column: A single column containing a JSON object or list of key value pairs. Ternary automatically flattens this into individual tags and dimensions.

Access and configuration requirements

IAM permissions must allow the Ternary service account to read the data source

• For Amazon S3, ensure the role used for Cost and Usage Reports also has access to the BYOD bucket or folder
• For Azure Blob Storage, assign Storage Blob Data Reader on the container
• For Google Cloud Storage, grant permissions such as storage.objects.get, storage.objects.list, and resourcemanager.projects.get
• For BigQuery, grant bigquery.tables.getData on the target table

The integration name cannot contain spaces. Use underscores or similar formats, for example BYOD_test.

How to configure Bring Your Own Data (BYOD) integration in Ternary?

Step 1: Navigate to BYOD configuration

Sign in to Ternary as an Admin and navigate to Admin → Integrations. Click New Integration and select Bring Your Own to start the setup.

Step 2: Configure the data source

The configuration flow consists of three stages: selecting the data source, assigning the table schema, and submitting the integration.

1. Start by selecting your data source. Choose from Amazon S3, Azure Blob Storage, Google Cloud Storage, or Google BigQuery, depending on where your dataset is stored.
2. Next, enter the required connection details. The fields vary by provider.

Google Cloud Storage

• Enter a name for the data source
• Provide the storage URI (for example, gs://bucket/path)
• Ensure the required IAM permissions are granted

Amazon S3

• Enter the S3 bucket path
• Provide the required access configuration, such as a Role ARN
• Ensure appropriate permissions are in place

Azure Blob Storage

• Enter the storage path
• Provide the connection string or required access credentials

Google BigQuery

• Provide the table path in project.dataset.table format
• Ensure the required permissions are granted for access

After entering the details, validate the connection by clicking Preview under Data Source Validation. Ternary loads a sample of your dataset, detects available columns, and displays a preview. A successful validation confirms that the data source is accessible and correctly formatted. This step must be completed before proceeding.

Step 3: Assign table schema

Map your CSV/BigQuery dataset columns to Ternary fields or define new dimensions and measures.

Start by selecting the Charge Period Start column, which represents the start of each billing or usage period. This field is required for normalization. Ternary detects available date columns and presents them for selection.

Next, review each column in the assignment table. Columns can be mapped in three ways.

• Assigned to an existing Multi-Cloud field such as BillingPeriodEnd or ServiceName, ensuring consistency with Ternary’s standard schema.
• Defined as new dimensions, which represent categorical data. Dimension types include string groupings, JSON-based tags that are automatically flattened, or additional timestamp fields for time-based analysis. New dimensions inherit the column header as their name in Ternary. To change the name, edit the header in your source file before re‑ingesting.
• Columns can also be defined as measures, which represent numeric values such as effectivecost, discount_amount, usage_units. Measures are aggregated using sum, so non-additive values should be treated as dimensions instead.

Ternary provides options to auto-map columns based on detected patterns or reset mappings if needed. All required fields must be assigned before continuing.

Click Next once mapping is complete.

Step 4: Review and submit

Review the configuration before finalizing the integration. This includes the integration name, data source location, and a summary of all column mappings, including existing fields, new dimensions, and measures.

The ingestion schedule is set to run every four hours. A manual refresh can also be triggered using the Request Billing Update option.

Click Submit to create the integration. Ternary will begin ingesting the dataset based on the configured schedule.

Using BYOD data in reports

Once ingested, BYOD data appears as a separate provider in the Reporting Engine, typically under Custom Data.

• Combine BYOD metrics with other cloud providers in the same report
• Group by custom dimensions or tags defined during mapping
• Build dashboards to analyze business metrics alongside cloud spend

Troubleshooting and common errors

FAQ

1. Can I load non cost metrics such as headcount or usage units? Yes. BYOD supports any time series numeric data. New measures can be created during the assignment step and analyzed alongside cost data.
2. Can BYOD data be combined with cloud billing data? Yes. BYOD appears as an additional provider and can be used in the same reports with other providers.
3. How often is BYOD data refreshed? Data is refreshed every four hours by default. A manual refresh can be triggered from the integration settings.
4. Do I need separate IAM permissions if I use the same bucket as billing data? If the file is in the same bucket or container, the existing role can be reused. If it is stored elsewhere, additional read permissions are required.
5. What happens if the schema changes? New columns must be mapped again in Table Assignment. Removed columns will no longer be ingested. Changes to the date column require reconfiguration.
6. Can a BYOD dataset be deleted? Yes. Deleting the integration from Admin → Integrations stops ingestion and removes the dataset from reporting.
7. What tag formats are supported? Tags can be provided as individual key value columns or as a JSON column. JSON tags are automatically flattened into dimensions.
8. Is there a limit on the number of columns? There is no strict limit, but very wide tables may be harder to manage. Only mapped columns are ingested.