Skip to Workflow Atlas
AI-Driven ETL and Interaction PatternAI systemIntermediate

AI-Powered Data Query and Chat Workflow

AI-Powered Data Query and Chat Workflow is a 8-node automation blueprint connecting OpenAI, Google BigQuery. Inspect its trigger, execution graph, branches, and implementation requirements.

Interactive system map

Follow the runtime. Inspect what supports it.

Solid horizontal paths show main-channel execution. Violet dependencies sit beneath the exact step they configure or empower.

8

Nodes

6

Links

2

Run groups

Connected tools

2 integrations

  • OpenAI
  • Google BigQuery

Canvas controls

Fit wide systems, then zoom into any run group.

AI-Powered Data Query and Chat Workflow execution lanes2 run groups containing 8 workflow nodes and 6 visible links. Solid horizontal lines are main-channel runtime links. Violet dashed lines connect typed dependencies beneath the runtime step they support. Focus any node to inspect its immediate path.Trigger Executed by the AI Tool. trigger node, executeWorkflowTrigger. 0 incoming and 1 outgoing connections.STARTTrigger Executed by the A…TRIGGEREXECUTEWORKFLOWTRIGGER0 IN / 1 OUTSanitising the Query. transform node, code. 1 incoming and 1 outgoing connections.STEP 02Sanitising the QueryTRANSFORMCODE1 IN / 1 OUTQuery Database. integration node, googleBigQuery. 1 incoming and 0 outgoing connections.OUTCOMEQuery DatabaseINTEGRATIONGOOGLEBIGQUERY1 IN / 0 OUTChat with the User. trigger node, chatTrigger. 0 incoming and 1 outgoing connections.STARTChat with the UserTRIGGERCHATTRIGGER0 IN / 1 OUTAI Control Tower Agent. ai node, agent. 4 incoming and 0 outgoing connections.OUTCOMEAI Control Tower AgentAIAGENT4 IN / 0 OUTCall Query Tool. ai node, toolWorkflow. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Call Query ToolAITOOLWORKFLOW0 IN / 1 OUTOpenAI Chat Model. OpenAI node, lmChatOpenAi. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1OpenAI Chat ModelOPENAILMCHATOPENAI0 IN / 1 OUTChat Memory. ai node, memoryBufferWindow. 0 incoming and 1 outgoing connections.DEPENDENCY · DEPTH 1Chat MemoryAIMEMORYBUFFERWINDOW0 IN / 1 OUT

Signal inspector

Focus, hover, or select a step to isolate its runtime and support links.

Main-channel runtimeTyped dependencytriggeraidecisiontransformintegration
Scroll horizontally to follow every connected flow.8 connected nodesEnter or click to lock · Escape to clear

Runtime breakdown

Read the execution spine before its dependencies.

Each run group separates main-channel steps from the models, tools, retrievers, and data services that support them. Start and outcome labels apply only to runtime nodes.

01

Run Group

Trigger Executed by the AI Tool

2 Execution Links
  1. Start

    Trigger Executed by the AI Tool

    Trigger

  2. Step 2

    Sanitising the Query

    Transform

  3. Outcome

    Query Database

    Integration

02

Run Group

Chat with the User

1 Execution Link3 Support Dependencies
  1. Start

    Chat with the User

    Trigger

  2. Outcome

    AI Control Tower Agent

    AI reasoning

Attached dependencies

These nodes support the runtime above; they are not additional starts or outcomes.

3 nodes
  • Call Query Tool

    AI reasoning dependency

  • OpenAI Chat Model

    AI reasoning dependency

  • Chat Memory

    AI reasoning dependency

Turn the map into a plan

Adapt this blueprint to your company.

Bring the system shape into a workspace, then define the production controls, data boundaries, owners, and delivery sequence around your context.