Workflow

class Workflow

Workflows on Redivis are where analytical pipelines are built and executed. All workflows are owned by a user, and are made up of transforms, notebooks, and their output tables.

Workflows were previously referred to as "Projects" on Redivis. Existing code that utilized the "project" terminology will continue to work (e.g., User.list_projects()).

However, we encourage users to migrate their code to prevent future issues and confusion.

Constructors

Method	Description
User.list_workflows([max_results])	List all workflows owned by a user.
User.workflow(workflow_reference)	Construct a new workflow instance that references a workflow owned by a user.

Examples

Basics

workflow = redivis.user("imathews").workflow("example_workflow_climate_analysis")
tables = workflow.list_tables()

for table in tables:
    # Properties will be populated with the table.list resource representation
    print(table.properties) 
    
    table.get()
    # Properties will now be populated with the table.get resource representation
    print(table.properties) 

workflow.table("join_lat_lon_output").exists() # -> TRUE

Scoped queries

workflow = redivis.user("imathews").workflow("example_workflow_climate_analysis")

query = workflow.query("""
    SELECT
        id,
        EXTRACT(YEAR FROM date) AS year,
        SUM(value) AS annual_precip
    FROM daily_observations
    WHERE (element = 'PRCP')
    GROUP BY id, year
""")

query.to_pandas_dataframe()
# 	id	        year	    annual_precip
# 0	CA0023026HN	2003	    2925.0
# ...

Attributes

properties	A dict containing the API resource representation of the workflow. This will be fully populated after calling Workflow.get(), and partially populated for workflows created via User.list_workflows. Otherwise will be None.
qualified_reference	The fully qualified reference for the workflow, which can be used in SQL queries or the REST API. E.g., imathews.example_workflow_climate_analysis:x7kh
scoped_reference	The canonical reference for the workflow, without the username qualifier. E.g.,: example_workflow_climate_analysis:x7kh
user	A reference to the User instance that constructed this workflow.

Methods

Workflow.exists()	Check whether the workflow exists.
Workflow.get()	Get the workflow, populating the properties attribute on the current instance.
Workflow.list_tables([max_results])	List all tables in the workflow.
Workflow.query(query_string)	Create a query scoped to the workflow.
Workflow.table(table_reference)	Create a reference to a specific table within the workflow.