Anavsan Explore

Home › APEX

What is APEX?

APEX is Anavsan’s workload governance agent for Snowflake and BigQuery. It names the job behind the cost, recommends where that job should run, routes the change to its owner, and proves the outcome on the next runs.

APEX reads how a workload ran and recommends one next action: Run, Optimize, Redirect, or Review. It does not stand in front of the query, and it does not apply the change. The team that owns the workload approves anything that changes production.

What a workload is

A workload is the job that spent the compute, not the account, warehouse, or reservation it landed on.

Names below are the ones teams already use. Snowflake-only tools are marked. The rest run on one or both platforms.

dbt. Models, tests, and runs.
Fivetran. Connector syncs.
Airbyte. Connector syncs.
Airflow. The DAG that starts the job. On Google Cloud that is often Composer.
Snowpark. Snowflake. DataFrame and Python jobs.
Dynamic Table. Snowflake. A refresh of a declarative pipeline.
Snowpipe. Snowflake. File loads.
Task. Snowflake Tasks.
Cortex, Cortex Analyst, Cortex Search, Cortex Agent. Snowflake AI. Not a BigQuery claim.
Streamlit. Streamlit in Snowflake.
Dataform. BigQuery pipelines.
Scheduled query and continuous query. BigQuery.
BigQuery ML. Training and prediction jobs.
Notebook. Snowflake Notebooks or BigQuery Studio.
dbt Agent. An agent on a dbt project.
Looker, Looker Studio, Tableau, Power BI, Sigma, Connected Sheets. The BI refresh.

What APEX does

It reads the run. Cost, performance, pattern, and the owner who can change it.
It picks one answer. Run keeps it. Optimize uses less compute. Redirect names a better path. Review asks a person to decide.
It measures the same workload again. After the team ships a change, the question is whether cost fell and the requirement still holds.

What APEX does not do

APEX
The query pathAPEX does not stand in front of the query. The workload runs, then APEX reads it.
ProductionAPEX does not apply the change. Your review does.
Table contentsBusiness data stays in Snowflake or BigQuery. The input is how the workload ran and what it cost.
The unitNot the warehouse, the project, or the invoice. The workload.

Questions

The job behind the cost, named the way teams already name it. Shared tools include dbt, Fivetran, Airbyte, Airflow, notebooks, and BI such as Looker, Tableau, Power BI, and Sigma. Snowflake adds Snowpark, Dynamic Tables, Snowpipe, Tasks, Cortex, and Streamlit. BigQuery adds Dataform, scheduled queries, continuous queries, BigQuery ML, Looker Studio, and Connected Sheets.
No. It recommends Run, Optimize, Redirect, or Review. Your team approves anything that changes production.
No. It reads how the workload already ran. It does not stand in front of the query.
Yes. BigQuery workloads include dbt, Dataform, Fivetran, Airbyte, Airflow, scheduled queries, continuous queries, BigQuery ML, notebooks, Looker, Looker Studio, Connected Sheets, Tableau, Power BI, and Sigma. Cortex, Snowpark, Snowpipe, and Streamlit stay on Snowflake. Depth pages: cost governance, storage intelligence, and dataset lineage.