Mux

Need help deploying these sources, or figuring out how to run them in your data stack?

Join our Slack community or book a call with a dltHub Solutions Engineer.

Mux.com is a video technology platform that provides infrastructure and tools for developers to build and stream high-quality video content.

This Mux dlt verified source and pipeline example loads data using “Mux API” to the destination of your choice.

Name	Description
asset	Refers to the video content that you want to upload, encode, store, and stream using their platform
video view	Represents a single instance of a video being watched or streamed

Note: The source mux_source loads all video assets, but each video view is for yesterday only!

Setup Guide

Grab credentials

1. Sign in to mux.com.

2. Click "Settings" at the bottom left, then select "Access Token".

3. Select "Generate new token".

4. Assign read permissions for Mux videos and data, and name the token.

5. Click "Generate token".

6. Copy the API access token and secret key for later configuration.

Note: The Mux UI, which is described here, might change. The full guide is available at this link.

Initialize the verified source

To get started with your data pipeline, follow these steps:

1. Enter the following command:

   dlt init mux duckdb

   This command will initialize the pipeline example with Mux as the source and duckdb as the destination.

2. If you'd like to use a different destination, simply replace duckdb with the name of your preferred destination.

3. After running this command, a new directory will be created with the necessary files and configuration settings to get started.

For more information, read the guide on how to add a verified source.

Add credentials

1. Inside the .dlt folder, you'll find a file called secrets.toml, which is where you can securely store your access tokens and other sensitive information. It's important to handle this file with care and keep it safe.

   Here's what the file looks like:

   # Put your secret values and credentials here. Do not share this file and do not push it to github
   [sources.mux]
   mux_api_access_token = "please set me up" # Mux API access token
   mux_api_secret_key = "please set me up!" # Mux API secret key

2. Replace the API access and secret key with the ones that you copied above. This will ensure that this source can access your Mux resources securely.

3. Finally, enter credentials for your chosen destination as per the docs.

For more information, read the General Usage: Credentials.

Run the pipeline

1. Before running the pipeline, ensure that you have installed all the necessary dependencies by running the command:

   pip install -r requirements.txt
2. You're now ready to run the pipeline! To get started, run the following command:

   python mux_pipeline.py
3. Once the pipeline has finished running, you can verify that everything loaded correctly by using the following command:

   dlt pipeline <pipeline_name> show
   For example, the pipeline_name for the above pipeline example is mux, you may also use any custom name instead.

For more information, read the guide on how to run a pipeline.

Sources and resources

dlt works on the principle of sources and resources.

Source mux_source

This function yields resources "asset_resource" and "views_resource" to load video assets and views.

@dlt.source
def mux_source() -> Iterable[DltResource]:
    yield assets_resource
    yield views_resource

Resource assets_resource

The assets_resource function fetches metadata about video assets from the Mux API's "assets" endpoint.

@dlt.resource(write_disposition="merge")
def assets_resource(
    mux_api_access_token: str = dlt.secrets.value,
    mux_api_secret_key: str = dlt.secrets.value,
    limit: int = DEFAULT_LIMIT,
) -> Iterable[TDataItem]:
    ...

mux_api_access_token: Mux API token for authentication, defaults to ".dlt/secrets.toml".

mux_api_secret_key: Mux API secret key for authentication, defaults to ".dlt/secrets.toml".

limit: Sets the cap on the number of video assets fetched. "DEFAULT_LIMIT" set to 100.

Resource views_resource

This function yields data about every video view from yesterday to be loaded.

@dlt.resource(write_disposition="append")
def views_resource(
    mux_api_access_token: str = dlt.secrets.value,
    mux_api_secret_key: str = dlt.secrets.value,
    limit: int = DEFAULT_LIMIT,
) -> Iterable[DltResource]:
    ...

The arguments mux_api_access_token, mux_api_secret_key and limit are the same as described above in "asset_resource".

Customization

Create your own pipeline

If you wish to create your own pipelines, you can leverage source and resource methods from this verified source.

1. Configure the pipeline by specifying the pipeline name, destination, and dataset as follows:

   pipeline = dlt.pipeline(
       pipeline_name="mux_pipeline", # Use a custom name if desired
       destination="bigquery", # Choose the appropriate destination (e.g., duckdb, redshift, post)
       dataset_name="mux_dataset" # Use a custom name if desired
   )

2. To load metadata about every asset to be loaded:

   load_info = pipeline.run(mux_source().with_resources("assets_resource"))
   print(load_info)

3. To load data for each video view from yesterday:

   load_info = pipeline.run(mux_source().with_resources("views_resource"))
   print(load_info)

4. To load both metadata about assets and video views from yesterday:

   load_info = pipeline.run(mux_source())
   print(load_info)

Additional Setup guides

• Load data from Mux to Redshift in python with dlt
• Load data from Mux to AWS Athena in python with dlt
• Load data from Mux to Google Cloud Storage in python with dlt
• Load data from Mux to Microsoft SQL Server in python with dlt
• Load data from Mux to Snowflake in python with dlt
• Load data from Mux to Neon Serverless Postgres in python with dlt
• Load data from Mux to AlloyDB in python with dlt
• Load data from Mux to CockroachDB in python with dlt
• Load data from Mux to EDB BigAnimal in python with dlt
• Load data from Mux to BigQuery in python with dlt