Grid variables are here!

DesignerNew features 🎉

Use Grid Variables? Yes please! With the exciting addition of grid variables, the Data Productivity Cloud now has a new type of pipeline variable. A grid variable is a two-dimensional array that holds multiple values in named columns. With grid variables, you can pass lists of data as dynamic values into a component's properties.

In query components, you can select Use Grid Variable when selecting the columns you want from your data source. You'll also want to use grid variables for passing arrays of data for use in Python scripts.

Default values are set or changed dynamically at runtime, so grid variables enable you to populate table metadata and pass variables between pipelines, from the parent pipeline to the child pipeline it is running.

With this new support for grid variables in pipelines, use our new Grid Iterator component to loop over the rows of your grid variables.

Azure features

We've added the Azure SQL component, so now you can run an SQL query on an Azure SQL database and copy the results to a table. You can also now search your Azure Blob Storage, as this new data input type has been added for the File Iterator component.

New Mailchimp component and Flex connector for Mixpanel

Our new Mailchimp component lets you query the Mailchimp API to retrieve data and load it into a table. You can then use transformation components to enrich and manage the data in permanent tables. And you'll now find the Mixpanel Flex connector in Designer.