API-Football integration

API-Football data, in your warehouse.

A built-in ingestr connector: add credentials, pick tables, schedule it.

name: raw.teams
type: ingestr
parameters:
  source_connection: api_football
  source_table: 'teams'
  destination: snowflake
  incremental_strategy: merge

$ bruin run assets/raw/api_football.asset.yml

  1. extract · API-Football teamsincremental
  2. load · snowflake raw.teamsmerged
  3. checks · not_null, unique

Loaded and checked. Downstream models can run.

How it connects

Connected in three steps.

API-Football provides soccer data from API-SPORTS, including World Cup teams, fixtures, standings, players, venues, and match events. The default configuration targets World Cup 2026 with league=1 and season=2026.

  1. 01

    Add a API-Football connection with its credentials.

  2. 02

    Pick the tables to load and how: replace, append or merge.

  3. 03

    Bruin runs it on your schedule and checks every load.

Connection parameters

apikey
API-Football API key. Required.
league
API-Football league ID. Defaults to 1 for FIFA World Cup.
season
Season year. Defaults to 2026.
timezone
Optional timezone passed to fixture requests.
baseurl
Overrides the API base URL. Defaults to https://v3.football.api-sports.io.

Tables

6 tables, ready to load.

  • teams
  • stadiums
  • groupstandings
  • matches
  • players
  • matchevents

The platform

Part of the Bruin platform.

Data in, ready for everything downstream: the models, the checks, the lineage and the AI layer.

01 · Move

Data Ingestion

02 · Model & govern

SQL & Python
Data Quality
Data Governance

03 · Use

AI Data Analyst
AI Dashboards
Data Apps
Self-Healing Pipelines
Bruin Cloudorchestration · governance · observability

Frequently asked

Questions about API-Football.

Does Bruin have a built-in API-Football integration?

Yes. Built-in ingestr source.

Which API-Football tables can Bruin load?

teams, stadiums, groupstandings, matches, players, matchevents.

Where can API-Football data go?

Snowflake, BigQuery, Databricks, Redshift, ClickHouse, Postgres, DuckDB, MotherDuck, Microsoft Fabric and more, plus files on S3 and GCS.

How fresh is the data?

As fresh as your schedule. Incremental loads append, merge or replace a time window, every few minutes if you like.

Do we need Bruin Cloud?

No. The Bruin CLI and ingestr run locally, in CI or in your own orchestrator. Bruin Cloud adds scheduling, lineage, alerts and the AI data analyst on top.

Ready to connect API-Football?

$100 in credits and 50 AI tasks. No credit card.

A demo walks through your own data.

Sign up to our newsletter

Practical updates on open-source data pipelines, AI analysts, governance, and what we are shipping at Bruin.

The signup form is hosted by Brevo. Allow marketing cookies to load it.