Schema and Meta Select Tiles

b_rad · 2025-05-29T12:02:20+00:00

There was an error rendering this rich post.

Does anyone know when and how to use the Schema and MetaSelect tiles in Magic ETL?

I searched for documentation and couldn't find any.

Thanks in advance for any help with this.

Bharath.

Find more posts tagged with

Magic ETL

Schema

Use case is when you want to edit the schema of a dataset. Here are the steps to use the tile:

Drag the Schema tile onto the canvas and connect it to an input. This surfaces the schema as a table with the Column Names, Expressions, and Data Types of the input.
Connect the Schema tile to other Magic tiles like the Formula, the String Operations, and more to revise the schema. The Schema tile introduces a new data type called “Expression”. Use the in-tool documentation in the Formula tile to see details about that data type.
Once you have your schema exactly as you want it, drag out the Meta Select tile. The Meta Select tile requires two inputs – the last tile in the path of your modified schema, and the original input itself. The Meta Select tile applies the changes made to your schema to the input dynamically.

In this example below, I've added "test." in front of each column name dynamically:

This page link is all I can find.

https://www.domo.com/blog/product-innovations-announced-at-the-connections-tour

Use case is when you want to edit the schema of a dataset. Here are the steps to use the tile:

Drag the Schema tile onto the canvas and connect it to an input. This surfaces the schema as a table with the Column Names, Expressions, and Data Types of the input.
Connect the Schema tile to other Magic tiles like the Formula, the String Operations, and more to revise the schema. The Schema tile introduces a new data type called “Expression”. Use the in-tool documentation in the Formula tile to see details about that data type.
Once you have your schema exactly as you want it, drag out the Meta Select tile. The Meta Select tile requires two inputs – the last tile in the path of your modified schema, and the original input itself. The Meta Select tile applies the changes made to your schema to the input dynamically.

In this example below, I've added "test." in front of each column name dynamically:

@ColemenWilson your answer helped and I was able to test and make it work. Thank you for your detailed explanation.

Having said that, I would really like Domo to provide more documentation and examples on how to use this. Hope they do it soon.

Sorry for the delay, the Knowledge Base article is in progress and should be out soon.