Materializing Metrics using CLI

Materializations are invoked through the command line and scheduled to run at a cadence. The configuration for the materialization must already exist in your Transform configurations in order for you to run this command. For more information on Materializations, see here.

Usage

Run the following to see all options

mql materialize --help

Examples

The materialization-name should map to the one committed in your Transform directory. If you don't provide a start and end-time, the materialization will run across all available data, which can be very expensive.

mql materialize --materialization-name my_materialization 

Providing a start and end time will bound the data for the materialization.

mql materialize --materialization-name my_materialization --start-time 2020-01-01 --end-time 2020-01-31

By default, the materialization will write to the Transform schema and any other location you've specified in the destinations for your configuration. Optionally provide a specific schema and table to write the materialization to. Note this won't be managed by Transform once it's written outside of our cache.

mql materialize --materialization-name my_materialization --start-time 2020-01-01 --end-time 2020-01-31 --output-table my_schema.my_table