Pull from Parabola Table
The Pull from Parabola Table step is a source step used to pull data from a Parabola Table that you have access to. If you are an Editor or Viewer on a Flow, any Parabola Tables on that Flow will be available to be pulled in as a data source using this step.
Settings
The dropdown options for Tables to import will be located on the left-hand side. Tables that you have access to will be listed in the dropdown options. This step can access any Table in your Parabola account that you are authorized to access (whether as Viewer, Editor or owner).
Helpful Tips
This step pulls the base data in your Parabola Table. Views applied on to your table, such as filters, sorts, aggregations, groups and visual formatting will not show up in this step.
If you do not see your Parabola Table in the dropdown, check to make sure the Allow other Flows to pull data from this table option is enabled on your Send to Parabola Table step.
If you need to bring in multiple Tables, use multiple Pull from Parabola Table steps to bring in the data. Then combine the dataset using a Stack tables or Combine tables step.
Limitations: when working across multiple Flows, the Pull from Tables step will only pull from a Table that has been published on a Flow with a successful run. When working within the same Flow, you can also pull from a draft (unpublished) table.
Send to Parabola Table
The Send to Parabola Table step is a destination step that lets you store your dataset in a Parabola Table. Data sent to that table will be visible to anyone with access to that Flow (Viewer, Editor or Owner).
Viewing your data
When configured, the Send to Parabola Table step has two tabs - an "Input" tab, and an "Existing Table" tab.
- The input tab will show you what data is currently flowing into this step. That is the data that would be sent to the Table to be stored, if you ran this Flow.
- The existing Table tab will show you the data that is currently stored in the Table from prior runs of the Flow. Any downstream steps that receive input data from this step will have access to the data represented in this tab. Any steps that receive input from this step will receive the data currently stored in the Table.
Settings
- After you connect your Flow to this export step, it will show a preview of the Table data. You must give your Table a name on this step (and you can edit the name from here at any time).
- By default, the Allow other Flows to pull data from this table option will be checked. When checked, teammates with any access to this Flow will be able to use this Table as source data in other Flows (using a Pull from Parabola Tables step). To prevent other Flows from pulling this Table, disable this option. Tables will still be visible in the Flow’s Live page, and can be pulled within the same Flow.
- Choose how the data will be added to the Table. Data can be overwritten on each run, appended to the bottom or top (prepend), or updated based on certain values (upsert).
Overwrite the table
- With this option, each run of your Flow will completely replace the data in the Table
Append new data
- With this option, each run of your Flow will add new rows either below, or above, the existing rows in the Table. All rows that are sent to this step will be added to the table
- Choose to match the columns in the input data in the step to the table by matching the position or name of each column in the table
- Optional: you can include a timestamp that indicates when each row was added to the table
Update existing rows
- With this option, each run of your Flow will attempt to update matching rows within the table
- Rows will be matched based on the combination of values in all columns selected. If duplicate matches exist, the step will error when the Flow runs. All matching column name must be present in both the data in the step and the table, and must be exact matches by name
- If a match is not found for a particular row in the step, it can be appended to the bottom of the table or discarded
- Optional: you can include a timestamp that indicates when each row was last updated
Storing dataOnce you run your Flow, the Table will populate and update.Tables are useful to store data that can be accessed between Flows or to create reports when used in conjunction with the Visualize step. More info on how to visualize here.
Running another Flow after updating a Table
Use an arrow to connect this step to other steps in a sequence. For example, you can connect this step to the Run another Flow step to first send data to a Table and then run a Flow that pulls data from that Table.
Helpful Tips
Security: the data you send through this step is stored by Parabola. We store the data as a convenience, so that the next time you open the Flow, the data is loaded into it. Your data is stored securely in an Amazon S3 Bucket, and all connections are established over SSL and encrypted.
Your Table’s content is never discarded. To remove the data, you will need to delete the step from both Draft and Published versions of the flow (or delete the entire Flow).
Limitations: Parabola Tables will be limited to our current cell count limitation (described here).
At launch, you can use unlimited Parabola Tables at no extra charge to your team. After a beta period, we’ll move to a usage-based model for Parabola Tables data storage. (You will not be charged retroactively for usage during the beta period.)